How To Delete Empty Cells In Excel At Once?

Asked By Opland Pamela 0 points N/A Posted on - 01/10/2018

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.

• Status: Open
• Question Views: 376
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Software Others
• Question Tags: Excel

Answered By Les R Fife 0 points N/A #307732

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.

About Les R Fife

Questions
2

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 01/10/2018
• Question Category: Software Others