Hide Rows - copy and paste only rows that show

Hello,

If you could tell me how to do the following it would be appreciated.
If I hide rows 2, 4, 6 in a 7 row spreadsheet, then rows 1,3,5, 7 are
showing. If I highligh these row numbers, copy, and paste, it pastes rows
1-7, not the odd rows that are showing. Any help is appreciated.

We could copy only the visible rows using F5 > Special

After you select the rows 1-7,
press F5 > Special > Check "Visible cells only" > OK
then right-click to copy (and paste elsewhere)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Access101" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> If you could tell me how to do the following it would be appreciated.
> If I hide rows 2, 4, 6 in a 7 row spreadsheet, then rows 1,3,5, 7 are
> showing. If I highligh these row numbers, copy, and paste, it pastes rows
> 1-7, not the odd rows that are showing. Any help is appreciate

That's it. Max, thanks so much.

"Max" wrote:

> We could copy only the visible rows using F5 > Special
>
> After you select the rows 1-7,
> press F5 > Special > Check "Visible cells only" > OK
> then right-click to copy (and paste elsewhere)
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Access101" <[email protected]> wrote in message
> news:[email protected]...
> > Hello,
> >
> > If you could tell me how to do the following it would be appreciated.
> > If I hide rows 2, 4, 6 in a 7 row spreadsheet, then rows 1,3,5, 7 are
> > showing. If I highligh these row numbers, copy, and paste, it pastes rows
> > 1-7, not the odd rows that are showing. Any help is appreciate
>
>
>

Pleasure` ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Access101" <[email protected]> wrote in message
news:[email protected]...
> That's it. Max, thanks so much.