Apart from Copy ONLY unhidden rows/columns, another situation we used to run into is probably deleting or modifying hidden cells unintentionally. Sound familiar to you?
You think you have finished your job and send the file to your boss.
What????? How come the file becomes this?
Hidden rows sometimes can be annoying. If you copy a cell down (or delete a range of cells) with hidden rows in-between, you are going to make the same change (pasting or deleting) to all hidden cells in between. I suffered from it long long time ago and I believe it is a common problem encountered by many beginners.
As the screenshot below, first to COPY the cell (which is D2 in this example).
DO NOT Paste as usual or simply copying by dropping down the cells.
This entry was posted in Excel Tips and tagged Go to special, Visible cells only. Bookmark the permalink.