close
Question by Mara: is there a way to atuo-delete blank cells on Excel?
Add your own answer in the comments!
I have an excel doc and I did a lot of copy/pasting and now there's tons of blank cells in between each item that I need to delete. Is there a way I can do this faster than by clicking each one and deleting it?
I mean blank rows of cells. I have huge gaps of blank rows and its taking forever to select them all to delete.
Best answer:
Answer by Colanth
If there are a few blank columns, or a few blank rows, you can select them all, then delete them. You can't delete individual cells in a spreadsheet.
Add your own answer in the comments!
全站熱搜