| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Editing Filtered Data
How can I edit a subset of filtered data in excel 2007 without harming the
hidden data? Currently I access the filtered subset and I change the data in a column by entering the desired text into the first field of the column and then using the copy down command to change all other fields. When I do this the hidden data is also changed as a result of the copy down command. In Excel 2003 I was able to filter and change a subset of data using the copy command without ever effecting the hidden data. -- PBSEV |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter data and fill only filtered data | Excel Discussion (Misc queries) | |||
| Sum of filtered data | Excel Worksheet Functions | |||
| Editing a list of data | Excel Discussion (Misc queries) | |||
| Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
| Using ONLY the data filtered | Excel Discussion (Misc queries) | |||
Hybrid Mode
