How to delete blank space in MS Excel worksheet

Office 2007-2010

  1. Click on Find and Select under home tab
  2. Click on Go to.goto
  3. Click on SpecialGotoSpecial

Shortcut Method

  1. Press F5 and Go to Menu will pop up directly