how do i select all the visible cells only when using auto filter

i have applied auto filter on a worksheet
now i want to select all the visible cells satisfying the filter criteria.
how do i do this

Hi shaurabh,

If I understand you correctly, all you have to do is
copy and paste the data to a new worksheet.

HTH
Martin

Ctrl + *

maybe

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"shaurabh" <shaurabh@discussions.microsoft.com> wrote in message
news:2D187D60-1D24-4ABE-8A45-0E795504426A@microsoft.com...
>i have applied auto filter on a worksheet
> now i want to select all the visible cells satisfying the filter criteria.
> how do i do this
>

Another way press F5 and special and select visible cells only

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com> wrote in message
news:OgeeM0BmGHA.4220@TK2MSFTNGP04.phx.gbl...
> Ctrl + *
>
> maybe
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Excel 95 - Excel 2007
> Northwest Excel Solutions
> www.nwexcelsolutions.com
> "It is a good thing to follow the first law of holes;
> if you are in one stop digging." Lord Healey
>
>
> "shaurabh" <shaurabh@discussions.microsoft.com> wrote in message
> news:2D187D60-1D24-4ABE-8A45-0E795504426A@microsoft.com...
>>i have applied auto filter on a worksheet
>> now i want to select all the visible cells satisfying the filter
>> criteria.
>> how do i do this
>>
>
>

this works thanx a lot

"Peo Sjoblom" wrote:

> Another way press F5 and special and select visible cells only
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Excel 95 - Excel 2007
> Northwest Excel Solutions
> www.nwexcelsolutions.com
> "It is a good thing to follow the first law of holes;
> if you are in one stop digging." Lord Healey
>
>
> "Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com> wrote in message
> news:OgeeM0BmGHA.4220@TK2MSFTNGP04.phx.gbl...
> > Ctrl + *
> >
> > maybe
> >
> > --
> >
> > Regards,
> >
> > Peo Sjoblom
> >
> > Excel 95 - Excel 2007
> > Northwest Excel Solutions
> > www.nwexcelsolutions.com
> > "It is a good thing to follow the first law of holes;
> > if you are in one stop digging." Lord Healey
> >
> >
> > "shaurabh" <shaurabh@discussions.microsoft.com> wrote in message
> > news:2D187D60-1D24-4ABE-8A45-0E795504426A@microsoft.com...
> >>i have applied auto filter on a worksheet
> >> now i want to select all the visible cells satisfying the filter
> >> criteria.
> >> how do i do this
> >>
> >
> >
>
>
>