In her regular series for Cambridge Network members - now in its 15th year - software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she explains how to make sure hidden rows and columns are not copied (Microsoft Excel).
Tame your computer - a hiding hint
Do you sometimes hide rows or columns in your workbook? If so, have you ever tried to copy the area and noticed it also pastes the hidden rows and columns?
Well, there is a way to only paste what you see.
- Select the cells you want to copy.
- On the Home tab, in the Editing group, click Find & Select, followed by Go To Special. (Or press CTRL + G and click the Special button.)
- Select Visible cells only and click OK or press ENTER.
- Make sure the cells are still selected and copy and paste as normal. (CTRL + C and CTRL + V, anyone?)
So in a nutshell, introduce step 2 and 3 and Bob’s your uncle.
Finally, Happy Spreadsheet Day for yesterday (Sunday)! Yep, it really exists ;)
This tip is written for Microsoft 365 desktop apps and Windows 10 users, but might also be useful in Office 2010, 2013 and 2016. I meticulously test every tip I write to make sure it is correct, easy to understand and time-saving. Let me know if something isn't clear or doesn't work.
18 October 2021