ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lost highlighting sum tool (https://www.excelbanter.com/excel-discussion-misc-queries/198422-lost-highlighting-sum-tool.html)

Eric

Lost highlighting sum tool
 
I accidentally turned off the tool where it shows the sum at the bottom right
of the screen when you highlight cells. I was told that righ-clicking the
bottom right hand side of the scrren would display some options, with "sum"
being one of them. However, the box that the sum is usually displayed in
isn't on the screen anymore either, and there is no Sum option that displays
when I right click. Did I perhaps turn of something else, or delete the box
somehow? I'm not sure. Thanks for your help.

Jim Thomlinson

Lost highlighting sum tool
 
Lets go back one step further. Do you have a status bar on your screen.
Select View and ensure that Status Bar is checked. If not Check it.

The status bar should say Ready. It will be in the bottom left hand corner
of the screen. If you click anywhere on that bar you will get a pop up list
of options. Make sure Sum is selected.
--
HTH...

Jim Thomlinson


"Eric" wrote:

I accidentally turned off the tool where it shows the sum at the bottom right
of the screen when you highlight cells. I was told that righ-clicking the
bottom right hand side of the scrren would display some options, with "sum"
being one of them. However, the box that the sum is usually displayed in
isn't on the screen anymore either, and there is no Sum option that displays
when I right click. Did I perhaps turn of something else, or delete the box
somehow? I'm not sure. Thanks for your help.


Gord Dibben

Lost highlighting sum tool
 
Sounds like you have disabled the Status Bar.

ViewStatus Bar


Gord Dibben MS Excel MVP

On Mon, 11 Aug 2008 13:26:27 -0700, Eric
wrote:

I accidentally turned off the tool where it shows the sum at the bottom right
of the screen when you highlight cells. I was told that righ-clicking the
bottom right hand side of the scrren would display some options, with "sum"
being one of them. However, the box that the sum is usually displayed in
isn't on the screen anymore either, and there is no Sum option that displays
when I right click. Did I perhaps turn of something else, or delete the box
somehow? I'm not sure. Thanks for your help.




All times are GMT +1. The time now is 12:13 PM.

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