Excel: copy and paste only shown not hidden cells into new sheet

[MU]

I have a worksheet in which I hide information when I don't want to use it,
and make custom views. Now, I would like to take this a step further. How
can I copy this custom view and paste it into a new worksheet without all of
the hidden rows and columns coming with it?

[Dave Peterson]

Select the range to copy
edit|goto|special
click visible cells only

Edit|copy
and
edit|paste



MU wrote:
>
> I have a worksheet in which I hide information when I don't want to use it,
> and make custom views. Now, I would like to take this a step further. How
> can I copy this custom view and paste it into a new worksheet without all of
> the hidden rows and columns coming with it?

--

Dave Peterson

[The Squeaky Wheel]

Did you ever find an answer? I have the same question for Excel 2007. Thank you.

[john55]

maybe this

Please Login or Register  to view this content.