ExcelBanter - delete all empty cells in a range

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - delete all empty cells in a range (https://www.excelbanter.com/excel-worksheet-functions/129899-delete-all-empty-cells-range.html)

Gary

delete all empty cells in a range

How can I delete all empty cells from a range of 5000 cells?

Dave F

delete all empty cells in a range

Select the range, then Edit--Goto--Blanks

Click OK and all blanks will be selected. Then Edit--Delete.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

"Gary" wrote:

How can I delete all empty cells from a range of 5000 cells?

Gord Dibben

delete all empty cells in a range

Select the range then F5SpecialBlanksOK

EditDelete**** Up or Left

Gord Dibben MS Excel MVP

On Thu, 8 Feb 2007 11:36:36 -0700, "Gary" wrote:

How can I delete all empty cells from a range of 5000 cells?

All times are GMT +1. The time now is 11:43 AM.