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.
Here’s how:
- 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.)
[[{"fid":"295689","view_mode":"default","fields":{"format":"default","alignment":"","field_file_image_alt_text[und][0][value]":"hide cells 1","field_file_image_title_text[und][0][value]":"hide cells 1"},"link_text":false,"type":"media","field_deltas":{"1":{"format":"default","alignment":"","field_file_image_alt_text[und][0][value]":"hide cells 1","field_file_image_title_text[und][0][value]":"hide cells 1"}},"attributes":{"alt":"hide cells 1","title":"hide cells 1","class":"media-element file-default","data-delta":"1"}}]]
- 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 ;)
Related tips
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
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email (Karen@roem.co.uk) or visit her website at www.roem.co.uk