Easy way Shortcut Key to Delete Multiple Blank Row/Cell at Once in MS Excel : Blank rows or cell look unprofessional in spreadsheet and can create issues for calculation, sorting and data analysis. If you manually try to delete multiple blanks rows, then it will take lot of time and effort. But don’t worry Microsoft Excel come with lot of shortcut keys and tools.
So here I will guide you one of the fastest and easiest way to delete all blanks rows or cell at once in Microsoft Excel by using shortcut key. Just follow the below instructions
1. Select the entire data which you want to delete blank rows or cells and press “F5”, a go to dialogue box will appear, click on “Special” and select “Blanks” and “Ok”.
2. All blank rows will be selected, now press “Ctrl+(-)” and select “Entire row” and hit “Enter”. That’s it all blank rows will be deleted at once.
Read More:-