Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 11th 06, 09:58 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 193
Default add up cell content to get answer at bottom of sheet

I used to be able to highlight cells and the total would be shown at the
bottom left hand site of the spreadsheet. How do I get that back?

Thanks

  #2   Report Post  
Old July 11th 06, 10:07 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 644
Default add up cell content to get answer at bottom of sheet

On my version it's at the bottom right. Anyhow right click the status
bar (the grey one) and select sum. Addionally, you'll find there are
several other function that may be performed on the highlighted
selection.

HTH

Die_Another_Day
Robert wrote:
I used to be able to highlight cells and the total would be shown at the
bottom left hand site of the spreadsheet. How do I get that back?

Thanks


  #3   Report Post  
Old July 11th 06, 10:18 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default add up cell content to get answer at bottom of sheet

Right-click on the Status Bar and select "Sum" from the options.

You may be currently set to "none"

If you don't have a status bar showing, go to ViewStatus Bar.


Gord Dibben MS Excel MVP

On Tue, 11 Jul 2006 13:58:01 -0700, Robert
wrote:

I used to be able to highlight cells and the total would be shown at the
bottom left hand site of the spreadsheet. How do I get that back?

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
macro to find cell content in sheets and make sheet active Nigel Excel Discussion (Misc queries) 4 June 26th 14 02:38 PM
if and then formula tiggatattoo Excel Worksheet Functions 2 June 8th 06 08:43 PM
Clicking Cell Link Changes Cell on Another Sheet nshah Excel Discussion (Misc queries) 1 August 31st 05 01:50 AM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017