0
Dadwneud
Pleidleisiau
Helo bawb,
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
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
0
Dadwneud
Pleidleisiau
Hi dak4482,
Mae'n ddrwg gennyf am yr ateb hwyr.
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, cliciwch ar Arbennig > Blanciau > 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 fel y mae arnoch ei angen.
Please let me know if you have any further questions.
Amanda
Mae'n ddrwg gennyf am yr ateb hwyr.
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, cliciwch ar Arbennig > Blanciau > 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 fel y mae arnoch ei angen.
Please let me know if you have any further questions.
Amanda
0
Dadwneud
Pleidleisiau
I have searched the website for comfort or efficiency to complete this process and I think this is the most suitable play snake on the site to do it effectively.
play solitaire
play solitaire
- Tudalen:
- 1
Ni wnaed unrhyw atebion i'r swydd hon eto.