| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULA FOR SUM TOTAL OF SELECTED ROWS | Excel Discussion (Misc queries) | |||
| How to get Total of Colored Cell in Selected Range | Excel Discussion (Misc queries) | |||
| What happened to the display of the total in cells selected | Excel Discussion (Misc queries) | |||
| total selected cells display at bottom of screen | Excel Discussion (Misc queries) | |||
| How do I obtain total for auto filter value selected ? | Excel Discussion (Misc queries) | |||
Linear Mode
