Hi dak4482,
Sorry for the late reply.
The function Delete Blank Rows works well on my computer. Could you please check if the entire row of the blank cells you wanted to delete is blank? Since the function deletes entire blank rows but not blank cells.
And if you only want to delete blank cells but not rows. Please press
F5, click on
Special >
Blanks >
OK to select all the blank cells.
Then right-click on any of the selected blank cells, click Delete, then select
Shift cells left/ up, OR
Entire row/ column as you need.
Please let me know if you have any further questions.
Amanda