| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Filters not working correctly
When filtering a table, the filter returns the correct value(s). However, if
you attempt to copy, delete, or format the filtered values, all values are copied or deleted, even the hidden ones. In Excel 2003, the filter returned "Visible Cells Only" by default. This is not happening in 2007. I can work around by gong to Find & Select on the Home tab -- Go to Special and selecting Visible cells only. This is very tedious and is not the way it should work. Please let me know what settings I need to change to get the filters to work correctly. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheet not working with filters. | Excel Worksheet Functions | |||
| Formulas not working correctly | Excel Worksheet Functions | |||
| SUM formula not working correctly | Excel Worksheet Functions | |||
| Filters not working properly | Excel Discussion (Misc queries) | |||
| Filters in Excel 2003 are not working | Excel Worksheet Functions | |||
Threaded Mode
