Excel is a popular program that can save you countless hours in calculating and recalculating information. You can also use its powerful filters and PivotTables to quickly retrieve information and manipulate it in numerous ways. Blank rows, however, makes this all difficult and messy. OK, you can obviously delete your empty rows one by one, but there’s a quick way to select and delete all of them.
Here’s how:
1. If necessary, select the range containing the empty rows.
2. Press F5 and click on the Special button.
3. Click on the Blanks radio button and click OK.
4. All rows containing a blank cell anywhere in the row are selected, so be careful to check the data!
5. On the Home tab, in the Cells group, click on the arrow next to the Delete button and select Delete Sheet Rows.
And wouldn’t these steps be a great one to record as a macro? See Tip 351 for further details.
* Unless stated otherwise, these tips were written for Microsoft Office 2010.
July 13th 2015
PS I'm committed to sharing the best of what I know with others so please don't keep these tips a secret. If you enjoyed today's tip, please forward it to anyone you feel may benefit or reprint it (with full copyright and subscription information) in your newsletters and message boards. Got a tip to share? Submit it by emailing karen@roem.co.uk - if your tip is selected, I'll publish it along with your name; the bragging rights will last a lifetime.
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email ( Karen@roem.co.uk) or visit her website at www.roem.co.uk
Please note: Cambridge Network's Learning Collaboration members have the opportunity to book places on Roem Ltd courses at a reduced rate.