#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 145
Default auto sum feature

Hi - new user. I've seen other people scroll over a group of cells and have
it quickly sum for them in the lower right corner without putting any
formulas into specific cells. Is this a feature that i need to "turn on"?
Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default auto sum feature

Tammy,

Right click the 'Status bar', that's the bar below the sheet tabs and you
will see the functions available. Select 'Sum' select your range and the sum
is in the status bar.

Mike

"Tammy" wrote:

Hi - new user. I've seen other people scroll over a group of cells and have
it quickly sum for them in the lower right corner without putting any
formulas into specific cells. Is this a feature that i need to "turn on"?
Thanks.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default auto sum feature

Make sure the Status Bar is visible under ViewStatus Bar

Then right-click on the bar and select Sum.

Select the range of cells.


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 12:03:01 -0700, Tammy
wrote:

Hi - new user. I've seen other people scroll over a group of cells and have
it quickly sum for them in the lower right corner without putting any
formulas into specific cells. Is this a feature that i need to "turn on"?
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
Any auto-save feature for Excel 2000? Eric Excel Discussion (Misc queries) 2 April 19th 08 08:31 PM
Using auto sum feature Dave Excel Discussion (Misc queries) 3 September 25th 07 04:57 PM
auto save feature in excel Digvijay Kamal Excel Worksheet Functions 1 July 14th 07 03:55 PM
Excel's 2003 Auto Recover Feature Marilyn Excel Discussion (Misc queries) 2 November 10th 06 10:16 PM
where can I find the Auto Sum feature on Excel Lexus841 Excel Worksheet Functions 1 January 24th 06 10:00 PM


All times are GMT +1. The time now is 03:11 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"