Discover latest Indian Blogs Excel Shortcuts - Select the blank fields Skip to main content

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.

Little Savings - Excel

Comments