How To Delete Empty Cells In Excel At Once?

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #307732

How To Delete Empty Cells In Excel At Once?

qa-featured

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.

Related Questions