Delete Blank Rows And Columns In Excel With A Few Clicks

Delete Blank Rows And Columns In Excel With A Few Clicks

Spreadsheets can get messy. Cleaning a sheet of blank rows or columns sounds straightforward enough, but it can be time-consuming if you do it manually. This method gets the job done in just a few clicks, even on huge spreadsheets.

First, highlight the area of your spreadsheet where the blank rows are. Include the row just above the first blank row and the row just below the final blank row in your selection.

If you’re running Excel 2013, navigate to the “Home” tab, then the “Editing” section, and click “Find & Select”. Click “Go To Special…” on the drop-down menu and select “Blanks”. Click “OK”. Now, only the blank cells should be highlighted. Click the “Home” tab again, navigate to the “Cells” section, and click “Delete Sheet Rows” from the drop-down menu. You can repeat a similar process to remove blank columns from your spreadsheet.

Even if you’re not running Excel 2013, a quick Google search for “Find and Select” in your version of Excel will turn up a keyboard shortcut that will do the same for you. For example, on Mac Office 2011, the hotkey shortcut is Ctrl+G.

How to Quickly and Easily Delete Blank Rows and Columns in Excel 2013 [How-To Geek]

The Cheapest NBN 50 Plans

Here are the cheapest plans available for Australia’s most popular NBN speed tier.

At Lifehacker, we independently select and write about stuff we love and think you'll like too. We have affiliate and advertising partnerships, which means we may collect a share of sales or other compensation from the links on this page. BTW – prices are accurate and items in stock at the time of posting.


2 responses to “Delete Blank Rows And Columns In Excel With A Few Clicks”