How to Make Blank Rows Between Populated Rows in Excel
Spreadsheet applications like Excel enable you to insert, delete or rearrange entire rows of business data in ways that are difficult or messy to do with old-fashioned pencil and paper ledgers. For instance, if you notice that a large Excel worksheet you created with data from a report or professional journal is missing data, you can insert one or more new, blank rows in between existing rows already populated with data.
-
1.
Launch Excel and load the worksheet you want to work with.
-
2.
Click or tap the "Home" tab.
-
3.
Click or tap any cell within the row you want to insert a blank row above.
-
4.
Click or tap the arrow on the"Insert" button above the "Cells" ribbon category.
-
5.
Click or tab "Insert Sheet Rows" to create a blank row above the selected row. If you want a blank row beneath the select row, click or tap "Insert Cells & Shift Down."
References
Tips
- You don't need to use the Ribbon to insert blanks rows. Click the row number you want to add another row above, right-click your mouse anywhere within the selected row, then click "Insert Rows."
Writer Bio
Allen Bethea has written articles on programming, web design,operating systems and computer hardware since 2002. He holds a Bachelor of Science from UNC-Chapel Hill and AAS degrees in office technology, mechanical engineering/drafting and internet technology. Allen has extensive experience with desktop and system software for both Windows and Linux operating systems.