Hello everyone, I am great admirer of the tricks Excel provides to make work easy and better. I want to if there is any way to delete empty cells in Excel at once.
How To Delete Empty Cells In Excel At Once?
Yes, you can remove all empty cells at once.
Step1. Select at data by pressing ctrl+a.
Step2. Press key f5.
Step3. Click special….
Step4. In GoTo dialog box, choose blank and click OK.
Step5. All the bare cells in the sheet will be highlighted.
Step6. Right-click on the cell and select Delete option.
Step7. Select option in the way you want to arrange your data.
Step8. Click OK.