Copying Excel Data with Hidden Columns

Have you ever tried to copy cells in Excel when the range contains hidden columns? If you have, you may be frustrated by the outcome – the hidden columns of data will paste as well.

The next time you need to do this, highlight the cells, press Ctrl+G, click the Special button, and select Visible cells only.  Now when you copy and paste, Excel will stop pasting the hidden data.

Extra Tip: If you did want to paste all that data but have the columns stay hidden, after you perform a normal copy and paste, right-click again and choose Paste Special > Keep Source Column Widths.

Author:  Ryan Donelan
rdonelan@microknowledge.com

Remember, if you are a MicroKnowledge customer and have a software question to ask, feel free to contact us at any time by using our Support link at the top of the site. Your question might be featured in our next blog entry!

Do you have a related tip to share? Leave a comment. We’d love to hear from you.

Category: Tech Tips