Thread: Pasting sub sets.

Using Excel as a Db,
how may I copy / paste a sub set?
I currently get the entire Db pasting
when trying to copy/paste desired rows
(the others being hidden).

Thanks



spam@uce.gov

Rodney,

Before copying, use Edit / Go To.... Special, Visible cells only.

HTH,
Bernie
MS Excel MVP


"Rodney" <rodney@touch88gum.com.au> wrote in message news:OyGKvquyFHA.1252@TK2MSFTNGP09.phx.gbl...
> Using Excel as a Db,
> how may I copy / paste a sub set?
> I currently get the entire Db pasting
> when trying to copy/paste desired rows
> (the others being hidden).
>
> Thanks
>
>
>
> spam@uce.gov
>
>
>
>
>

AAaaaaaaaah, so that's where it was hiding.
My help file offered no hints.

May your stockings overflow at christmas with gifts that delight.


| Before copying, use Edit / Go To.... Special, Visible cells only.
|
| HTH,
| Bernie
| MS Excel MVP

And if you do it often, you may wish to add that particular icon to your
toolbar, to make it a little easier.

Right click in the toolbar and choose "Customize".
Click on the "Commands" tab,
and in the left window click on "Edit".

In the right window, scroll down almost to the bottom and click on the
"SelectVisibleCells" icon, and drag it to your toolbar.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Rodney" <rodney@touch88gum.com.au> wrote in message
news:uYKK5Z5yFHA.664@tk2msftngp13.phx.gbl...
> AAaaaaaaaah, so that's where it was hiding.
> My help file offered no hints.
>
> May your stockings overflow at christmas with gifts that delight.
>
>
> | Before copying, use Edit / Go To.... Special, Visible cells only.
> |
> | HTH,
> | Bernie
> | MS Excel MVP
>
>
>

Yes, I use it daily RD,
followed your instructions, and have it on the toolbar.
Great!
Thank you very much.


spam@uce.gov





"RagDyer" <RagDyer@cutoutmsn.com> wrote in message news:#C6IeH6yFHA.4032@TK2MSFTNGP15.phx.gbl...
| And if you do it often, you may wish to add that particular icon to your
| toolbar, to make it a little easier.
|
| Right click in the toolbar and choose "Customize".
| Click on the "Commands" tab,
| and in the left window click on "Edit".
|
| In the right window, scroll down almost to the bottom and click on the
| "SelectVisibleCells" icon, and drag it to your toolbar.
|
| --
| HTH,
|
| RD
| ==============================================
| Please keep all correspondence within the Group, so all may benefit!
| ==============================================
|
|
| "Rodney" <rodney@touch88gum.com.au> wrote in message
| news:uYKK5Z5yFHA.664@tk2msftngp13.phx.gbl...
| > AAaaaaaaaah, so that's where it was hiding.
| > My help file offered no hints.
| >
| > May your stockings overflow at christmas with gifts that delight.
| >
| >
| > | Before copying, use Edit / Go To.... Special, Visible cells only.
| > |
| > | HTH,
| > | Bernie
| > | MS Excel MVP
| >
| >
| >
|