LifeTricks.com 
USER CP
Site Navigation 
UPVOTE
UP
55
DOWN
DOWNVOTE
Excel Spreadsheet - Excel Spreadsheet Trick: Speedily Delete Blank Cells
UPVOTE
55
DOWNVOTE
  • life tricks short link

Excel Spreadsheet Trick: Speedily Delete Blank Cells

Excel Spreadsheet

Choose the column you want to filter, go to Data->Filter, after the downward button shows, undo Select All, pick up the last option, Blanks. All blank cells will show immediately. Go back to Home & click Delete directly, all of them will be removed.

Trick Source:

Is this trick using work of your own without attribution? Click here to PM the user and let them know!

Author Comments

Avatar of Love
amourdange says:

Some default data will be blank, for various reasons. If you need to delete these to maintain accuracy, especially when calculating the average value, the speedy way is to filter out all blank cells and delete them with one click



User Comments