How to Delete the Extra Rows in My Excel Spreadsheet
Users of Microsoft Excel will agree that it can be very frustrating, not to mention annoying, when your spreadsheet is full of extra rows. One solution to this problem would be to manually go through the spreadsheet, select each blank row and delete it. But when your spreadsheet literally has thousands of rows, this would be extremely time-consuming. It's probably not how you want to spend a day. Luckily, there is a shortcut you can use that remedies this situation. These instructions are for the 2007 version.
Other People Are Reading
Instructions
-
-
1
Select one column of data that contains blank rows.
-
2
In the top Ribbon area, click the "Home" tab.
-
-
3
Find the Editing section, and click the arrow next to "Find and Select."
-
4
Click "Go To Special."
-
5
Select the "Blanks" button and click "OK." You will now see all blank cells within the column highlighted.
-
6
Go to "Delete" on the Ribbon and click the small arrow. Select "Delete Sheet Rows." All of the blank cells within your column will be deleted.
-
7
Repeat this procedure for each column that contains blank cells.
-
1
Tips & Warnings
Make sure you save a copy of any large spreadsheet before trying a new procedure such as this one, just in case you make an error or the procedure doesn't have the results you wanted.
