View Single Post
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

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

Sam wrote:

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!


--

Dave Peterson