ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   READY BAR (https://www.excelbanter.com/excel-discussion-misc-queries/197064-ready-bar.html)

MrDodd

READY BAR
 
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

READY BAR
 
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

"MrDodd" wrote:

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]


Gord Dibben

READY BAR
 
Right-click anywhere on the Status Bar.

NUM may not be showing if NumLock is toggled off.


Gord Dibben MS Excel MVP

On Thu, 31 Jul 2008 08:50:05 -0700, FSt1
wrote:

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

"MrDodd" wrote:

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]




All times are GMT +1. The time now is 08:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com