You are reading a single comment by @greentricky and its replies.
Click here to read the full conversation.
-
To quickly delete the blank rows I was just going to filter the first column removing blanks then paste into a new sheet. Is there a faster /more smart way?
why paste them in to a new sheet?
Assuming a blank cell in column A means the whole row is blank
I would just select column A, ctrl+G, special, blanks, delete, entire rowIf you are doing the above two actions constantly for sheets with the same structure, just record it as a macro but it is so quick using shortcuts I find doing any alternative hard to justify
greentricky
Agh! It's just been too long a week!
Yeah of course.
To quickly delete the blank rows I was just going to filter the first column removing blanks then paste into a new sheet. Is there a faster /more smart way?