| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filtering in a worksheet and then cut items out i lose unfiltered
I filter in a worksheet to access specific rows I would like to cut and paste
into sheet 2. When i take the filter off to access the other information it has been cut also. Why does this not work correctly. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filtering in a worksheet and then cut items out i lose unfiltered
After filtering
Press F5 or Edit|Go To Click on Special and select 'Visible Cells only' Now if you Cut or Copy you will only filtered cells will be impacted... -- If you find this post helpful pl. choose "Yes"... "Rhonitee" wrote: I filter in a worksheet to access specific rows I would like to cut and paste into sheet 2. When i take the filter off to access the other information it has been cut also. Why does this not work correctly. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete only the unfiltered row? | Excel Discussion (Misc queries) | |||
| When I load a previous Excel workbook I lose my worksheet tabs. | Excel Worksheet Functions | |||
| Filtering for Like Items in a Column | Excel Discussion (Misc queries) | |||
| filtering to show items in a listbox | Excel Discussion (Misc queries) | |||
| lose formatting when emailing worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
