Auto filtering
 

How to select/copy only cells that are shown through auto filitering?

Auto filtering
 

Hi,

That is not necessary, just select all the cells which are displayed and
copy them, Excel only copies visible cells from a filtered list.

You can choose F5, Special, Visible cells but its not necessary.
--
Thanks,
Shane Devenshire


"kkh" wrote:

How to select/copy only cells that are shown through auto filitering?

Auto filtering
 

Hi kkh

Example to Copy the filter result to a new worksheet:

1) Select the whole data range or if you not have empty rows/columns in the range
you can use Ctrl * to select all data or use F5SpecialCurrent regionOK with
one cell selected in the data range.
If it copy all the data (there are a few reports of 2007 users) use also the shortcut
Alt ; or F5SpecialVisible cells onlyOK to select only the Visible cells.

2) Ctrl c in all Excel versions or:
Excel 97-2003: EditCopy
Excel 2007: Home tabClipboard groupCopy

3) Shift F11 in all Excel versions to insert a worksheet or:
Excel 97-2003: InsertWorksheet
Excel 2007: Home tabCells groupInsert...Sheet
Or use button next to the last tab

4) Ctrl v in all Excel versions or:
Excel 97-2003: EditPaste
Excel 2007: Home tabClipboard groupPaste


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"kkh" wrote in message ...
How to select/copy only cells that are shown through auto filitering?