Not include hidden columns in copy paste

G

Guest

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
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy/Paste with Hidden Rows/Columns Excel 2007 3
Copy and Paste with hidden columns remaining hidden 2
Copy, paste 2
.csv Format, Hidden Columns, 2007 2
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da 3
Copy Formulas 1
Pasting current view 1
copy outlined data in excel 1

Top