Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default lost drop down next to autosum

I used to have a drop down next to my autosum icon that let you choose from
sum ,average... so you did not need to use the insert function feature. It
is gone - any idea how to get it back?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default lost drop down next to autosum

Are you using an earlier version of Excel than you were before? The
dropdown was added in Excel 2002.

If you're using Excel 2002 or later version, you could reset the toolbar:
Choose ToolsCustomize
On the Toolbars tab, select Standard
Click the Reset button
Click OK to reset.
Close the Customize dialog box

Patricia wrote:
I used to have a drop down next to my autosum icon that let you choose from
sum ,average... so you did not need to use the insert function feature. It
is gone - any idea how to get it back?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default lost drop down next to autosum

This was added in xl2002.

So if you're using multiple versions (home and work), you may not have it in
both locations.



Patricia wrote:

I used to have a drop down next to my autosum icon that let you choose from
sum ,average... so you did not need to use the insert function feature. It
is gone - any idea how to get it back?


--

Dave Peterson
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
How to determine the maximum lost? Eric Excel Discussion (Misc queries) 3 March 6th 06 09:49 PM
I have lost the in cell drop down in validation Stan Lawson Excel Worksheet Functions 2 February 28th 06 12:06 AM
Limit drop down list and linking to other info Intuit Excel Worksheet Functions 13 February 2nd 06 09:48 PM
Lost Drop & Drag after update Ray Excel Discussion (Misc queries) 0 November 22nd 05 02:17 PM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM


All times are GMT +1. The time now is 04:08 PM.

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"