ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   lost drop down next to autosum (https://www.excelbanter.com/excel-discussion-misc-queries/123554-lost-drop-down-next-autosum.html)

Patricia

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?

Debra Dalgleish

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


Dave Peterson

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


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com