View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Not include hidden columns in copy paste

Select the range to copy
edit|goto|special|visible cells only
then try copy|paste

jbc wrote:

I want to copy and paste a range that includes hidden columns. is there a
way to paste the data w/o including the hidden columns?

I want to email the pasted data and don't want to distribute the hidden
columns.

Thanks.

jbc


--

Dave Peterson