Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or
×

fileCant delete blank rows.

More
5 days 16 hours ago - 5 days 16 hours ago #3968 by Amanda Lee
Replied by Amanda Lee on topic Cant delete blank rows.
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
Attachments:
Last edit: 5 days 16 hours ago by Amanda Lee.

Please Log in or Create an account to join the conversation.

More
2 months 4 weeks ago #3744 by dak4482
Cant delete blank rows. was created by dak4482
Hi all,
Have a spreadsheet that I'm working on. In the columns there are numerous blank cells that I'm trying to delete. After selecting the columns I select DELETE then DELETE BLANK ROWS and it comes back with ZERO Blank rows deleted even though there are hundreds of blank rows in the column I selected. BUG??? I've checked the formatting that shows nothing. The column is not locked. Any other ideas?
Dan

Please Log in or Create an account to join the conversation.

Moderators: ExcelfansOfficeFansAmanda Lee