If you’ve ever worked with Excel files before, you’ve probably ran into the situation where you had to get rid of a bunch of blank lines or empty rows. There are several different ways to do it, but you certainly don’t want to go through and manually delete every blank cell or row! Read on to learn how to do it efficiently.
That is a long and complicated way of doing that. For an easier method, that also preserves your ordering, just highlight the target columns/rows and press F5, click on Special and select Blanks and OK. Now all the blank cells will be selected and ready for a simple right click delete and shift cells up.
Now wasn’t that much easier than macros and sorting?
Thanks for this tip! I’ve definitely run into this problem before and it’s great have this resource out here for others. We’d love to hear more tips at http://www.facebook.com/office
Cheers,
Andy
MSFT Office Outreach