Posted to microsoft.public.excel.misc

shaurabh

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Still can select locked cells in protected sheet	Andy	New Users to Excel	11	October 29th 05 07:45 PM
Cells User Select Locked after upgrade to Excel 2002	TWilson	Excel Discussion (Misc queries)	1	August 5th 05 12:22 PM
how do you "select locked cells" w/o "select unlocked cells"?	princejohnpaulfin	Excel Discussion (Misc queries)	3	July 16th 05 03:53 AM
auto filter question	Juco	Excel Worksheet Functions	1	November 28th 04 02:51 PM
The Auto Filter button lost the column specified option.	D	Excel Worksheet Functions	1	November 4th 04 11:47 PM

All times are GMT +1. The time now is 07:15 PM.

About Us

"It's about Microsoft Excel"