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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |