| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cut only data shown in autofilter?
I'm trying to autofiler data, then cut only that data from the worksheet. It
cuts everything, including data in hidden rows. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cut only data shown in autofilter?
Try this: Autofilter, select the data you want, go to Edit -- Office
Clipboard, click copy, open a new workbook (or worksheet) and past it from the clipboard. You'll have only the data from the autofilter. "Marianna" wrote: I'm trying to autofiler data, then cut only that data from the worksheet. It cuts everything, including data in hidden rows. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| Autofilter - failure to display ALL data down a column | Excel Worksheet Functions | |||
| Using AutoFilter to Sort Data Pulled in by INDEX / MATCH | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
Linear Mode
