Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto filtering
How to select/copy only cells that are shown through auto filitering?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Column Auto Filtering | Excel Discussion (Misc queries) | |||
auto filtering? | Excel Worksheet Functions | |||
Advanced Auto Filtering | Excel Worksheet Functions | |||
Auto-Filtering and Copying | Excel Discussion (Misc queries) | |||
Auto filtering & COUNTIF | Excel Worksheet Functions |