ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I copy a worksheet so that hidden columns remain secret? (https://www.excelbanter.com/excel-discussion-misc-queries/149419-how-do-i-copy-worksheet-so-hidden-columns-remain-secret.html)

Vanessa Long

How do I copy a worksheet so that hidden columns remain secret?
 
I want to copy the visible information only on a worksheet with hidden
columns. I would like the reader to think there are no hidden columns and
that the information on the screen is all there is. Help!

Mike H

How do I copy a worksheet so that hidden columns remain secret?
 
Vanessa,

Select your columns then

F5|special|visible cells only

Then do you copy and paste.

Mike

Select

"Vanessa Long" wrote:

I want to copy the visible information only on a worksheet with hidden
columns. I would like the reader to think there are no hidden columns and
that the information on the screen is all there is. Help!



All times are GMT +1. The time now is 06:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com