A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Status Bar Auto Sum



 
 
Thread Tools Display Modes
  #1  
Old September 3rd, 2004, 03:46 PM
external usenet poster
 
Posts: n/a
Default Status Bar Auto Sum

In Excel 97 if select mutiple cells the sum of the cells
selected would be displated at the bottom right in the
status bar. Is this availible in Excel 2002 if yes how
do you turn it on.
  #2  
Old September 3rd, 2004, 04:07 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default

Hi
it is available. Right click on the status bar and choose the desired
function

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
In Excel 97 if select mutiple cells the sum of the cells
selected would be displated at the bottom right in the
status bar. Is this availible in Excel 2002 if yes how
do you turn it on.


  #3  
Old September 3rd, 2004, 04:43 PM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default

The AutoCalculate feature should appear automatically if two or more
cells with numbers are selected.

If it doesn't appear, AutoCalculate may be set to None:
Right-click in the AutoCalculate area of the Status Bar
Choose a function from the list

Or, the cells may contain numbers that are being treated as text. To
convert them to real numbers, you can use one of the techniques he

http://www.contextures.com/xlDataEntry03.html

wrote:
In Excel 97 if select mutiple cells the sum of the cells
selected would be displated at the bottom right in the
status bar. Is this availible in Excel 2002 if yes how
do you turn it on.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
restoring auto correct file back to original word version Sharon G General Discussion 4 August 8th, 2004 02:37 PM
auto save, auto backup poonam Worksheet Functions 1 July 15th, 2004 03:29 PM
summing based on auto filter Art General Discussion 2 June 13th, 2004 04:19 PM
Auto paragraph number - then remove auto Legalbits General Discussion 2 May 17th, 2004 08:11 PM
auto filter/ status bar ryan Worksheet Functions 1 October 3rd, 2003 09:01 PM


All times are GMT +1. The time now is 06:44 PM.


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