Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Excel Shortcuts - Select the blank fields

# Little Savings

While dealing with the mutliple columns in an Excel sheet, it is always to select the blanks spaces at different places.

In Microsoft excel, it is easy to highlight the Blank Spaces by using the following way.

Route:

  • Select the whole sheet
  • Go to Find & Select under Home tab
  • Select to Go To Special
  • Select Blanks
  • Now you can edit /delete the fields by selecting the Delete option from Home page.

Note that it will delete the rows/columns with content too, while deleting the blank spaces.




This post first appeared on Little Savings, please read the originial post: here

Share the post

Excel Shortcuts - Select the blank fields

×

Subscribe to Little Savings

Get updates delivered right to your inbox!

Thank you for your subscription

×