How to only "paste values" of cells that are not "hidden"?

S

Sam

Hello,

In my document, many columns are hidden. Say column B is hidden,
and I need to copy columns A and C and paste values into another
Excel document. How can I do that? When I select columns A and C, copy
and paste values, the other document contains columns A,B and C, instead of
just columns A and C.

Thank you!
 
D

Dave Peterson

Select A:C
Edit|Goto|Special|click "visible cells only"
Edit|Copy
go to the other sheet
edit|pastespecial|values
 
Top