ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Status Bar Configuration area (https://www.excelbanter.com/excel-worksheet-functions/97511-status-bar-configuration-area.html)

Jolly Jolly

Status Bar Configuration area
 
I could use help on the Status Bar Configuration -- especially the area where
totals are provided (average, etc.)

Select numbers in teh worksheet. Then in the status bar you can see their
total, average, or other results depending on choice in Status Bar
Configuration. I find nothing in Help relating to the Status Bar
Configuration.



Ron Coderre

Status Bar Configuration area
 
If you don't see the Status Bar......

From the Excel main menu:
<tools<options<view tab
Check: Status Bar

Then....Right-Click on the Status Bar to view the calculation options
(None, Average, Count, etc)

Choose the function you want
Done!

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Jolly Jolly" wrote:

I could use help on the Status Bar Configuration -- especially the area where
totals are provided (average, etc.)

Select numbers in teh worksheet. Then in the status bar you can see their
total, average, or other results depending on choice in Status Bar
Configuration. I find nothing in Help relating to the Status Bar
Configuration.



Jolly Jolly

Status Bar Configuration area
 
I can see this information, but the Status Bar Configuration (the name at the
top of the menu) is a new menu to 2007 with lots more on it than the
calculations. There is nothing in Help explaining it or the many items
located on it.

So, why is it here? What does it do (in addition to add, subtract, etc.),
and what value is it to the user?

Thanks

Jolly



"Ron Coderre" wrote:

If you don't see the Status Bar......

From the Excel main menu:
<tools<options<view tab
Check: Status Bar

Then....Right-Click on the Status Bar to view the calculation options
(None, Average, Count, etc)

Choose the function you want
Done!

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Jolly Jolly" wrote:

I could use help on the Status Bar Configuration -- especially the area where
totals are provided (average, etc.)

Select numbers in teh worksheet. Then in the status bar you can see their
total, average, or other results depending on choice in Status Bar
Configuration. I find nothing in Help relating to the Status Bar
Configuration.



Ron Coderre

Status Bar Configuration area
 
Ahhhh....Excel 2007! Important fact.
I don't use XL2007...Hopefully, someone who does will respond.

Sorry I couldn't be more help.
***********
Regards,
Ron

XL2002, WinXP


"Jolly Jolly" wrote:

I can see this information, but the Status Bar Configuration (the name at the
top of the menu) is a new menu to 2007 with lots more on it than the
calculations. There is nothing in Help explaining it or the many items
located on it.

So, why is it here? What does it do (in addition to add, subtract, etc.),
and what value is it to the user?

Thanks

Jolly



"Ron Coderre" wrote:

If you don't see the Status Bar......

From the Excel main menu:
<tools<options<view tab
Check: Status Bar

Then....Right-Click on the Status Bar to view the calculation options
(None, Average, Count, etc)

Choose the function you want
Done!

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Jolly Jolly" wrote:

I could use help on the Status Bar Configuration -- especially the area where
totals are provided (average, etc.)

Select numbers in teh worksheet. Then in the status bar you can see their
total, average, or other results depending on choice in Status Bar
Configuration. I find nothing in Help relating to the Status Bar
Configuration.




All times are GMT +1. The time now is 07:16 PM.

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