Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lp lp is offline
external usenet poster
 
Posts: 8
Default auto SUM bottom page

on updating microsoft, i lost the auto SUM function that shows up on the
bottom of excel page (when you highlight a column or cell and then the total
appears in the bottom right hand corner on the tool bar). Also lost the
filter indicator on the bottom left side of the screen. I cant seem to be
able to get either function back and i use both alot. any help????
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default auto SUM bottom page

For the sum:

Right click on the status bar. A menu of functions should appear. Select
SUM.

For the filter count, see if this helps:

http://contextures.com/xlautofilter02.html#Count

--
Biff
Microsoft Excel MVP


"LP" wrote in message
...
on updating microsoft, i lost the auto SUM function that shows up on the
bottom of excel page (when you highlight a column or cell and then the
total
appears in the bottom right hand corner on the tool bar). Also lost the
filter indicator on the bottom left side of the screen. I cant seem to be
able to get either function back and i use both alot. any help????



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,624
Default auto SUM bottom page

Try Tools/Options/View, checking the Status Bar checkbox.

In article ,
LP wrote:

on updating microsoft, i lost the auto SUM function that shows up on the
bottom of excel page (when you highlight a column or cell and then the total
appears in the bottom right hand corner on the tool bar). Also lost the
filter indicator on the bottom left side of the screen. I cant seem to be
able to get either function back and i use both alot. any help????

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
tabs at bottom of page sam @ sykes Excel Discussion (Misc queries) 3 March 30th 07 12:04 AM
Trying to keep totals at bottom of each page ffzeus Excel Discussion (Misc queries) 1 August 9th 06 08:57 PM
Bottom of Page Mari Excel Discussion (Misc queries) 4 July 27th 06 11:14 PM
NUM on the bottom of page-Missing Blair Setting up and Configuration of Excel 7 August 13th 05 06:31 PM
how to print a row on the bottom of every page Punx Excel Discussion (Misc queries) 1 November 29th 04 04:20 PM


All times are GMT +1. The time now is 12:30 PM.

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

About Us

"It's about Microsoft Excel"