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?
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?
Edit>Go To>Special, check Visible cells only before you Copy
--
Kind regards,
Niek Otten
"Steve" <[email protected]> wrote in message
news:[email protected]...
>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?
After selecting, and before copying, use Edit->Goto->Special and click
Visible Cells Only, followed by OK. Now you can copy and paste as you wish
"Steve" wrote:
> 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?
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
"Steve" wrote:
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks