close

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?

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

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

--

Dave Peterson

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()

E-mail轉寄