Tame your computer - a hiding hint

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).

roem tip time logo

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:

  1. Select the cells you want to copy.
  2. 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"}}]]

  1. Select Visible cells only and click OK or press ENTER.
  2. 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


Looking for something specific?