close

I have a large spreadsheet and have hidden rows. I do not want to copy the
hidden rows into a new spreadsheet. How do I do that?

Editgt;Go Togt;Special, check Visible cells only before you Copy

--
Kind regards,

Niek Otten

quot;Stevequot; gt; wrote in message
...
gt;I have a large spreadsheet and have hidden rows. I do not want to copy
gt;the
gt; hidden rows into a new spreadsheet. How do I do that?
After selecting, and before copying, use Edit-gt;Goto-gt;Special and click
Visible Cells Only, followed by OK. Now you can copy and paste as you wish

quot;Stevequot; wrote:

gt; I have a large spreadsheet and have hidden rows. I do not want to copy the
gt; hidden rows into a new spreadsheet. How do I do that?

ONe way, is go ahead and copy the hidden cells and then use the feature in
ASAP Utilities to delete them.

Available free at www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3
quot;Stevequot; wrote:

gt; I have a large spreadsheet and have hidden rows. I do not want to copy the
gt; hidden rows into a new spreadsheet. How do I do that?

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

    software

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