How to Find and Remove Empty or Blank Cells in Excel 2016
FBTwitterReddit
video description
Rating: 4.0; Vote: 1
were going to show you how to remove empty or blank cells in Excel 2016.
Don't forget to check out our main channel for more free how-to videos!
Join us on Facebook
Our App
To get started, open the drop-down Find & Select under the Home tab and click Go To Special
Select Blanks and hit OK.
Now that all the blank cells are selected, you can go and hit Delete.
Choose the option that fits your worksheet best and hit OK.
The results may not be ideal, but it will at least give you a starting point. You can select only certain groups of cells next time manually, or delete all blanks and manually move elements around to suit your needs.
To bring of the Special menu, you may also hit F5 on the keyboard and click Special from the Go To menu that comes up Date: 2023-07-08
