How to Delete/Remove Blank Rows & Columns in Excel 2010 Spreadsheet

Printer Friendly
Text Size: A A A A

Here is a small tip for those using Excel 2010 who want to remove all blank rows in an easy way without having to remove each blank row manually. Please note that this tip applies to removing multiple columns as well.

First select the portion of the spreadsheet from where you wish to remove the blank rows and then hit the Home tab. Here navigate to the Editing options and choose the Go To Special option under the Find & Select option.

Go To Special

In the Go to Special dialogue box, choose Blanks and hit OK.

Blanks Excel 2010

All the blank rows will be selected.

Now choose the Delete Sheet Rows option under the Delete drop down box.

Delete Sheet Rows

If you want to remove blank columns, select the portion of the spreadsheet from where you want to delete the blank columns, follow all steps as listed above and finally in the end select the ‘Delete Sheet Columns’ option.

This Tech Tip is brought to you by the Business and Technology Section ... IT solutions for today's CPAs. For more information and to view an archive of previous Tech Tips, please visit us here.

Do you have specific topics you would like to see covered in Tech Tips? Email any suggestions to