3 WAYS TO REMOVE BLANK CELLS OR EMPTY CELLS

This video will guide you on how to remove blank cells or empty cells from selected range of data.Show more

The first thing to do is to highlight the range of cells. If you want to select all cells with data, click anywhere in the table and press CTRL + A.
When you have selected the data range, you can now go to the Data tab where Go To Special Excel function can be found. This video will show the detailed way of doing it as well as the keyboard shortcuts to speed up the process.

The 2nd method to remove blank cells is through the keyboard shortcut ALT – H – FD and the 3rd one is a shorter way to do it. It’s though the F5 key. Just one click and Go To window where you can select Special is right in front of you.

After watching this, you will learn or be guided with the complete process of removing blank cells.

Title: 3 Ways to Remove Blank Cells or Empty Cells

#removeblankcells
#howtoremoveblankcells
#keyboardshortcuttoremoveblankcells