READY BAR

[MrDodd]

At the bottom of the excel application window is a ready bar. When a
worksheet is active there are certain keyboard functions that can be viewed
in the far right had corner. ex: NUM, SCRL, CAPS. My question is how can you
get the count for a number of highligted cells to show on that bar.

ready----------------------------------------------------[ ][CAPS] [NUM]
[SCRL]

 

[FSt1]

hi
officially, i think it's called the status bar or at least that is the name
i have to use when coding.
on th status bar, right click the area(far right) that says NUM. you should
get a popup. select count. the status bar will now count the high lighted
cells. right click NUM again to change back.

Regards
FSt1

 

[Gord Dibben]

Right-click anywhere on the Status Bar.

NUM may not be showing if NumLock is toggled off.


Gord Dibben MS Excel MVP

hi
officially, i think it's called the status bar or at least that is the name
i have to use when coding.
on th status bar, right click the area(far right) that says NUM. you should
get a popup. select count. the status bar will now count the high lighted
cells. right click NUM again to change back.

Regards
FSt1

At the bottom of the excel application window is a ready bar. When a
worksheet is active there are certain keyboard functions that can be viewed
in the far right had corner. ex: NUM, SCRL, CAPS. My question is how can you
get the count for a number of highligted cells to show on that bar.

ready----------------------------------------------------[ ][CAPS] [NUM]
[SCRL]