#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 336
Default quick sum display

usually when a block of cells is selected, the sum of the data in the cells
is displayed at the bottom of the screen but this has stopped. Can anyone
help me turn the function back on please?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default quick sum display

Right click in that area of the status bar, and you'll see a choice of
"None" and the functions available.
If "None" is checked, just check on one of the functions you wish to see
displayed.

On the other hand, you might be missing the status bar all together!
If so, click on:
<View <Status Bar.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Martin" wrote in message
...
usually when a block of cells is selected, the sum of the data in the

cells
is displayed at the bottom of the screen but this has stopped. Can anyone
help me turn the function back on please?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default quick sum display

Right-click on the status bar and select from the options.

You currently have it set to "None".


Gord Dibben MS Excel MVP

On Sun, 2 Jul 2006 12:13:02 -0700, Martin
wrote:

usually when a block of cells is selected, the sum of the data in the cells
is displayed at the bottom of the screen but this has stopped. Can anyone
help me turn the function back on please?


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
how to display numbers in thousands i.e display 10,000 as 10 excel2002 Excel Worksheet Functions 4 April 26th 06 07:53 PM
how to display subjects taught by a specific teacher upon selection of the teacher name in a drop down box janice fernandes New Users to Excel 5 March 9th 06 12:24 PM
How to display results to certain number of significant figures Coeliac Excel Discussion (Misc queries) 1 January 10th 06 12:04 PM
How do you display Greek and Russian languages in excel? Mark Hayden Excel Discussion (Misc queries) 1 August 1st 05 08:06 AM
Combine & Display “Fixed” & “Automatically Updated” Date Parts texcel Excel Worksheet Functions 1 November 1st 04 05:38 PM


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

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

About Us

"It's about Microsoft Excel"