- Select your data by command Ctrl+A (select all)
- Press F5
- This will open “Go to” dialog box in Excel.
- Now Select the “special” button.
- Then select “Blanks
- Now, all the blank cells will be selected.
- Just press CTRL and Minus sign (-)
- Choose “shift cells up” or “entire row” as needed.