ExcelBanter - Not include hidden columns in copy paste

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Not include hidden columns in copy paste (https://www.excelbanter.com/excel-discussion-misc-queries/150803-not-include-hidden-columns-copy-paste.html)

jbc

Not include hidden columns in copy paste

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

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

jbc

Not include hidden columns in copy paste

Worked like a charm. Thank you for your quick response.

jbc

"Dave Peterson" wrote:

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

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