REMOVE EMPTY CELLS: FIND AND DELETE BLANK ROWS AND COLUMNS | MICROSOFT EXCEL 2016
Do you want to learn how to delete blank cells in excel, then you are at the right place today, I am going to show to how to delete blank cells in excel and also guide some extra ordinary methods of excel 2016.
Stay tune,
1. Open your Excel sheet 2016
2. First, select your data column where you want to remove blank cells.
3. Now use the shortcut: Ctrl + G or F5
4. You will get one Goto popup box.
5. Click on Special button and you will get one popup box
6. Then Select Blank radio button.
7. Now you can see all the blank cells will be selected.
8. Just press Ctrl + - then you will get delete cells popup box, just select Shift Cells UP.
9. Now your blank cells are deleted from your raws and columns in excel 2016.
This tutorial will support in excel versions:
Excel 2003,
Excel 2007,
Excel 2010,
Excel 2013,
Excel 2016
I hope you like to learned how to delete blank cells in excel. If you like, this video please share with your friends.
Song: Elektronomia - Sky High [NCS Release]
Music provided by NoCopyrightSounds.
Video Link: • Elektronomia - Sky High | Progressive...
Download Link: https://NCS.lnk.to/SkyHigh