ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   automatic total of selected cells (https://www.excelbanter.com/new-users-excel/216481-automatic-total-selected-cells.html)

MarlboroughT&C

automatic total of selected cells
 
Usually if I select a column or row of cells, I can see the total at the
bottom of the worksheet - this seems to have disappeared. How do I get it
back? I know this is dead simple, but I can't find the answer in help.

Gary''s Student

automatic total of selected cells
 
The area is called the Status Bar. Right-click the Bar and select the
desired function to appear there.
--
Gary''s Student - gsnu200826


"MarlboroughT&C" wrote:

Usually if I select a column or row of cells, I can see the total at the
bottom of the worksheet - this seems to have disappeared. How do I get it
back? I know this is dead simple, but I can't find the answer in help.


JE McGimpsey

automatic total of selected cells
 
And if you're not seeing the status bar, choose Tools/Options/View, and
check the Status Bar checkbox.

In article ,
Gary''s Student wrote:

The area is called the Status Bar. Right-click the Bar and select the
desired function to appear there.


MarlboroughT&C

automatic total of selected cells
 
Fantastic! I knew it would be something simple - thanks to you both.

"JE McGimpsey" wrote:

And if you're not seeing the status bar, choose Tools/Options/View, and
check the Status Bar checkbox.

In article ,
Gary''s Student wrote:

The area is called the Status Bar. Right-click the Bar and select the
desired function to appear there.



Gord Dibben

automatic total of selected cells
 
In Excel-not-for-Mac simply ViewStatus Bar

No need to go through ToolsOptions.


Gord


On Wed, 14 Jan 2009 09:38:35 -0700, JE McGimpsey
wrote:

And if you're not seeing the status bar, choose Tools/Options/View, and
check the Status Bar checkbox.

In article ,
Gary''s Student wrote:

The area is called the Status Bar. Right-click the Bar and select the
desired function to appear there.



JE McGimpsey

automatic total of selected cells
 
Thanks, Gord -

Actually, that works in Excel-for-Mac, too. I forget that, though, since
I've gotten rid of the View menu in my normal configuration.


In article ,
Gord Dibben <gorddibbATshawDOTca wrote:

In Excel-not-for-Mac simply ViewStatus Bar

No need to go through ToolsOptions.


Gord Dibben

automatic total of selected cells
 
I get caught same way due to removing default stuff from Toolbars and Menus.



On Wed, 14 Jan 2009 14:45:26 -0700, JE McGimpsey
wrote:

Thanks, Gord -

Actually, that works in Excel-for-Mac, too. I forget that, though, since
I've gotten rid of the View menu in my normal configuration.


In article ,
Gord Dibben <gorddibbATshawDOTca wrote:

In Excel-not-for-Mac simply ViewStatus Bar

No need to go through ToolsOptions.




All times are GMT +1. The time now is 06:49 AM.

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