PDF download Download Article

A simple guide to adding one or more rows to your spreadsheet

PDF download Download Article

Trying to insert or delete rows in your Microsoft Excel worksheet? Whether you have new data or you're removing duplicate entries, adding and removing rows is easy! You can add one or more rows using a keyboard shortcut. Or, if you're trying to delete rows, you can select them and use the right-click menu to remove them from your spreadsheet. This wikiHow guide will show you how to insert and delete rows in Microsoft Excel.

Things You Should Know

  • Click and select the row number above which you want to insert a new row.
  • Select multiple rows to insert multiple new rows.
  • Press Ctrl + Shift + + on your keyboard to insert new rows.
  • Or, right-click the selected rows and select “Insert” to add new rows.
Method 1
Method 1 of 4:

Using Keyboard Shortcuts

PDF download Download Article
  1. This will select and highlight the entire row. After making a spreadsheet in Excel, you sometimes need to insert rows between existing rows. This method does exactly that.
    • You can select multiple rows to insert that amount of rows above the selection.
    • For example, if you want to insert 3 blank rows above row 17, select rows 17, 18, and 19.
  2. This will insert one or more rows (depending on how many you selected) above the selected rows.
  3. Advertisement
Method 2
Method 2 of 4:

Inserting a Row

PDF download Download Article
  1. In your Excel workbook file, at the lower-left corner of the worksheet are some tabs. These tabs can either be labeled Sheet1, Sheet2, etc., or renamed to a name you prefer. Click on the sheet you will insert rows into.
  2. Do this by clicking on the number of the row found on the left of the screen.
    • For example, if you’re tracking your bills in Excel and want to add a purchase that you forgot to input, you can select the row below where you want to insert the new line.
  3. A context menu will pop out.
  4. A row will be inserted above the one you selected.
    • Select Delete instead if you want to delete the selected row.
  5. Advertisement
Method 3
Method 3 of 4:

Inserting Multiple Rows

PDF download Download Article
  1. In your Excel workbook file, at the lower-left corner of the worksheet are some tabs. These tabs can either be labeled Sheet1, Sheet2, etc., or renamed to a name you prefer. Click on the sheet you will insert rows into.
  2. To insert multiple rows, highlight the rows below where you want to insert rows. Highlight the same number of rows as you want to insert.
    • For example, if you want to insert four new rows, select four rows.
    • You can select multiple rows by clicking the first row number, holding Shift, then clicking the last row number.
  3. A context menu will pop out.
  4. The number of rows you highlighted will be inserted above the rows you selected.
    • Select Delete instead if you want to delete the selected rows.
    • Functions like the SUM Function will change their cell reference range when you insert rows. If you’re using a VLOOKUP function, you may need to re-enter the range depending on the structure of your formula.
  5. Advertisement
Method 4
Method 4 of 4:

Inserting Nonadjacent Rows

PDF download Download Article
  1. In your Excel workbook file, at the lower-left corner of the worksheet are some tabs. These tabs can either be labeled Sheet1, Sheet2, etc., or renamed to a name you prefer. Click on the sheet you will insert rows into.
  2. To insert nonadjacent rows, hold down the CTRL key and select nonadjacent rows by left-clicking the row numbers using your mouse.
    • For example, you could select 3 nonadjacent rows to insert a new row above each selected row.
  3. A context menu will pop out.
  4. The number of rows you highlighted will be inserted above the rows you selected.
    • Select Delete instead if you want to delete the selected rows.
  5. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement

Video

Tips

Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!

You Might Also Like

Merge Cells in Excel Merge Cells in Microsoft Excel: A Quick Guide
Unprotect an Excel SheetUnprotect an Excel Sheet
Unhide All Rows and Columns in Microsoft Excel
Use If‐Else in Excel Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
Insert Pictures in Excel That Automatically Size to Fit Cells Insert Pictures in Excel That Automatically Size to Fit Cells
Create a Mortgage Calculator With Microsoft ExcelCreate a Mortgage Calculator With Microsoft Excel
Create a Graph in Excel Create a Graph in Excel
Unhide Columns in Excel Show Hidden Columns in Microsoft Excel & Unhide Column A
Ethernet Doesn't Have a Valid IP Configuration Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
Freeze Cells in Excel3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
Change from Lowercase to Uppercase in Excel Change from Lowercase to Uppercase in Microsoft Excel
Make a Spreadsheet in ExcelMake a Spreadsheet in Excel
Use ExcelNew to Excel? Here's Super Easy Tricks to Get You Started
Link Sheets in ExcelLink Sheets in Excel
Advertisement

About This Article

Kyle Smith
Written by:
wikiHow Technology Writer
This article was co-authored by wikiHow staff writer, Kyle Smith. Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo. This article has been viewed 186,980 times.
How helpful is this?
Co-authors: 6
Updated: March 6, 2023
Views: 186,980
Categories: Microsoft Excel
Thanks to all authors for creating a page that has been read 186,980 times.

Is this article up to date?

Advertisement