Blank rows or Blank cells is a common problem we all face one time or another in daily office life. This is very common when you try to import any data from somewhere (like your office ERP, a text file or a CSV file).
Today I will show you a very simple trick to delete blank rows from excel spreadsheets in a quick way.
Please follow this step to execute your operation:
- Select your data
Press F5 or CTRL+G:
This will open “Go to” dialog in Excel. Now hit on that “special” button or press (ALT+S).
- From “select special” screen, select “Blanks” (shown excel aside)
Now, all the blank cells will be selected.
- After-which, just press CTRL and Minus sign (-)
- Select “shift cells up” or “entire row” as you needed.
That is all. Now you will notice successfully removed blank rows from the spreadsheet.
If you are looking for keyboard short-cut:
Press in the same order once you select the cells.
'F5/CTRL+G' then 'ALT+s' then 'ALT+k' Enter 'CTRL+ –'
Here I created a short video where I showing how to remove blanks from the Excel Sheet.
Please Subscribe my Channel if you like this video.