View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default I can't see totals in status bar when I highlight cells

Hi,

This feature does not always work. Also, VBA code can overwrite this area
with other content of blank.

But that feature is entirely different from the SUM and COUNT info, those
refer to any selected range and have nothing to do with the Filter.

For make sure your Status bar is displayed (2003) choose View, Status Bar.
In 2007 right click the Status bar and turn on the options you want. (this
won't effect the 15 or 70 records found message).

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Crnhskr" wrote in message
...
When using the Filter function, or when simply highlighting a range of
numeric cells, I don't see the row count or sum in the status bar at the
bottom. Previously when using filter, you would see 15 of 70 rows, or
something like that. Now I don't see anything.