This Tech Tip is brought to you by the Business and Technology Section. 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. Now choose the Delete Sheet Rows option under the Delete drop down box. In the Go to Special dialogue box, choose Blanks and hit OK. Here navigate to the Editing options and choose the Go To Special option under the Find & Select option.
Please note that this tip applies to removing multiple columns as well.įirst select the portion of the spreadsheet from where you wish to remove the blank rows and then hit the Home tab.
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.
