| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Empty status bar
One of our users has a status bar which is completely empty, there is no
auto-filter or even ready written on it. I have right-clicked on the bar and tried every single option, but none appears. I have modified the calculation option, and nothing appears. I am at a loss as to what to do. I open the same spreadsheet on my computer and the count is there when I filter a column. Any help would be greatly appreciated Thanks Jeannie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Empty status bar
http://www.contextures.com/xlautofilter02.html#Count
there is also a workaround using SUBTOTAL on the same page -- Regards, Peo Sjoblom "Jeannie" wrote in message ... One of our users has a status bar which is completely empty, there is no auto-filter or even ready written on it. I have right-clicked on the bar and tried every single option, but none appears. I have modified the calculation option, and nothing appears. I am at a loss as to what to do. I open the same spreadsheet on my computer and the count is there when I filter a column. Any help would be greatly appreciated Thanks Jeannie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Empty status bar
I've tried everything appearing on that link and nothing works since the
status bar does not give any information at all, this seems to work only if the status bar has a mention such as ready or autofilter on it. Any other suggestions would be greatly appreciated "Peo Sjoblom" wrote: http://www.contextures.com/xlautofilter02.html#Count there is also a workaround using SUBTOTAL on the same page -- Regards, Peo Sjoblom "Jeannie" wrote in message ... One of our users has a status bar which is completely empty, there is no auto-filter or even ready written on it. I have right-clicked on the bar and tried every single option, but none appears. I have modified the calculation option, and nothing appears. I am at a loss as to what to do. I open the same spreadsheet on my computer and the count is there when I filter a column. Any help would be greatly appreciated Thanks Jeannie |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Empty status bar
Hi Jeannie
try ToolsOptionsViewcheck Status Bar -- Regards Roger Govier "Jeannie" wrote in message ... I've tried everything appearing on that link and nothing works since the status bar does not give any information at all, this seems to work only if the status bar has a mention such as ready or autofilter on it. Any other suggestions would be greatly appreciated "Peo Sjoblom" wrote: http://www.contextures.com/xlautofilter02.html#Count there is also a workaround using SUBTOTAL on the same page -- Regards, Peo Sjoblom "Jeannie" wrote in message ... One of our users has a status bar which is completely empty, there is no auto-filter or even ready written on it. I have right-clicked on the bar and tried every single option, but none appears. I have modified the calculation option, and nothing appears. I am at a loss as to what to do. I open the same spreadsheet on my computer and the count is there when I filter a column. Any help would be greatly appreciated Thanks Jeannie |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Empty status bar
Actually the status bar is visible, since I can see the "num" on the right
side when NumLock is on, however, nothing shows on the left side Any other suggestions would be greatly appreciated "Roger Govier" wrote: Hi Jeannie try ToolsOptionsViewcheck Status Bar -- Regards Roger Govier "Jeannie" wrote in message ... I've tried everything appearing on that link and nothing works since the status bar does not give any information at all, this seems to work only if the status bar has a mention such as ready or autofilter on it. Any other suggestions would be greatly appreciated "Peo Sjoblom" wrote: http://www.contextures.com/xlautofilter02.html#Count there is also a workaround using SUBTOTAL on the same page -- Regards, Peo Sjoblom "Jeannie" wrote in message ... One of our users has a status bar which is completely empty, there is no auto-filter or even ready written on it. I have right-clicked on the bar and tried every single option, but none appears. I have modified the calculation option, and nothing appears. I am at a loss as to what to do. I open the same spreadsheet on my computer and the count is there when I filter a column. Any help would be greatly appreciated Thanks Jeannie |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Empty status bar
So didn't the workaround using SUBTOTAL work?
-- Regards, Peo Sjoblom "Jeannie" wrote in message ... Actually the status bar is visible, since I can see the "num" on the right side when NumLock is on, however, nothing shows on the left side Any other suggestions would be greatly appreciated "Roger Govier" wrote: Hi Jeannie try ToolsOptionsViewcheck Status Bar -- Regards Roger Govier "Jeannie" wrote in message ... I've tried everything appearing on that link and nothing works since the status bar does not give any information at all, this seems to work only if the status bar has a mention such as ready or autofilter on it. Any other suggestions would be greatly appreciated "Peo Sjoblom" wrote: http://www.contextures.com/xlautofilter02.html#Count there is also a workaround using SUBTOTAL on the same page -- Regards, Peo Sjoblom "Jeannie" wrote in message ... One of our users has a status bar which is completely empty, there is no auto-filter or even ready written on it. I have right-clicked on the bar and tried every single option, but none appears. I have modified the calculation option, and nothing appears. I am at a loss as to what to do. I open the same spreadsheet on my computer and the count is there when I filter a column. Any help would be greatly appreciated Thanks Jeannie |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Empty status bar
I have this problem too.
It's where Excel does an autosum to the left of the numlock indicator on the status bar. Although I right click on the area and choose and option it still doesn't do an autosum. Stuart "Peo Sjoblom" wrote: So didn't the workaround using SUBTOTAL work? -- Regards, Peo Sjoblom "Jeannie" wrote in message ... Actually the status bar is visible, since I can see the "num" on the right side when NumLock is on, however, nothing shows on the left side Any other suggestions would be greatly appreciated "Roger Govier" wrote: Hi Jeannie try ToolsOptionsViewcheck Status Bar -- Regards Roger Govier "Jeannie" wrote in message ... I've tried everything appearing on that link and nothing works since the status bar does not give any information at all, this seems to work only if the status bar has a mention such as ready or autofilter on it. Any other suggestions would be greatly appreciated "Peo Sjoblom" wrote: http://www.contextures.com/xlautofilter02.html#Count there is also a workaround using SUBTOTAL on the same page -- Regards, Peo Sjoblom "Jeannie" wrote in message ... One of our users has a status bar which is completely empty, there is no auto-filter or even ready written on it. I have right-clicked on the bar and tried every single option, but none appears. I have modified the calculation option, and nothing appears. I am at a loss as to what to do. I open the same spreadsheet on my computer and the count is there when I filter a column. Any help would be greatly appreciated Thanks Jeannie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clipboard empty but get cannot empty CB when trying to copy | Excel Worksheet Functions | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| in excel..:can't empty clip are" but already empty | Excel Discussion (Misc queries) | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
Linear Mode
