| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
When in filter mode status bar doesn't show range of cells filted
I am working with a large excel sheet of data but when I wish to know the
range of data within this for instance when I filter out specific data, it doesn't show me on the status bar how many cells have been selected, it simply states FILTER MODE. I need the status bar to tell me 100 of 250 cells have been selected. Have I turned off a certain function? Please help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
When in filter mode status bar doesn't show range of cells filted
No....you haven't changed any settings.
See Debra Dalgleish's website for an explanation and workarounds: http://www.contextures.com/xlautofilter02.html#Count Does that help? *********** Regards, Ron XL2002, WinXP "Marie McNamee" wrote: I am working with a large excel sheet of data but when I wish to know the range of data within this for instance when I filter out specific data, it doesn't show me on the status bar how many cells have been selected, it simply states FILTER MODE. I need the status bar to tell me 100 of 250 cells have been selected. Have I turned off a certain function? Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| color a range of cells based on a criteria | Excel Discussion (Misc queries) | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| How do I force Excel to show filter totals in the Status bar? | Excel Worksheet Functions | |||
| Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
| Select Range of Cells | Excel Discussion (Misc queries) | |||
Linear Mode
