Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Member
 
Posts: 54
Default Sum of selected cells ?

Excel normally shows the sum of the selected cells in the lower right hand corner. It has stopped doing so. Is there an option somewhere that turns this off and on, similiar to the manual vs automatic calc option?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default Sum of selected cells ?

Right click where you normally see it and select sum from the box

Regards,

Peo Sjoblom

Dave H wrote:
Excel normally shows the sum of the selected cells in the lower right
hand corner. It has stopped doing so. Is there an option somewhere
that turns this off and on, similiar to the manual vs automatic calc
option?

Thanks




  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default Sum of selected cells ?

That is ... assuming that the Status Bar is enabled.

Click <View, and make sure there's a check by "Status Bar".
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Peo Sjoblom" wrote in message
...
Right click where you normally see it and select sum from the box

Regards,

Peo Sjoblom

Dave H wrote:
Excel normally shows the sum of the selected cells in the lower right
hand corner. It has stopped doing so. Is there an option somewhere
that turns this off and on, similiar to the manual vs automatic calc
option?

Thanks



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cells are selected but aren't displayed as selected Nifty Excel Discussion (Misc queries) 2 September 17th 06 07:22 PM
A validated List which link to selected cells according to what is selected on the list WL Excel Worksheet Functions 1 June 5th 06 08:52 PM
Excluding selected cells in excel Farhad Excel Discussion (Misc queries) 3 May 29th 06 08:45 PM
Macro, Copy Selected Cells Down a Column DB33 Excel Discussion (Misc queries) 9 February 15th 06 09:29 PM
one cell's value Highlights selected cells....how? [email protected] Excel Discussion (Misc queries) 2 February 15th 06 09:39 AM


All times are GMT +1. The time now is 12:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"