Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop Down Menus in Toolbar
I am a new Excel user. My husband has a drop-down menu next to his AutoSum
that allows access to Sum, Average, count, Min and Max. I don't have access to that menu. Is that about the version I am running or can I add it? |
#2
|
|||
|
|||
That feature has been in Excel since Excel 97.
-- Jim "MotherB" wrote in message ... |I am a new Excel user. My husband has a drop-down menu next to his AutoSum | that allows access to Sum, Average, count, Min and Max. I don't have access | to that menu. Is that about the version I am running or can I add it? |
#3
|
|||
|
|||
This feature was added in Excel 2002, so if your version is earlier than
that, it won't be available: Building formulas faster http://office.microsoft.com/en-ca/as...346041033.aspx MotherB wrote: I am a new Excel user. My husband has a drop-down menu next to his AutoSum that allows access to Sum, Average, count, Min and Max. I don't have access to that menu. Is that about the version I am running or can I add it? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
My bad!
-- Jim "Jim Rech" wrote in message ... | That feature has been in Excel since Excel 97. | | -- | Jim | "MotherB" wrote in message | ... ||I am a new Excel user. My husband has a drop-down menu next to his AutoSum || that allows access to Sum, Average, count, Min and Max. I don't have | access || to that menu. Is that about the version I am running or can I add it? | | |
#5
|
|||
|
|||
When I look at my system, it appears that I am running Excel 2003. Just for
the record: is that "button" there in versions after 2002 or does it have to be added? I know I sound like a simpleton, but I'd rather ask.....Thanks for your help. "Debra Dalgleish" wrote: This feature was added in Excel 2002, so if your version is earlier than that, it won't be available: Building formulas faster http://office.microsoft.com/en-ca/as...346041033.aspx MotherB wrote: I am a new Excel user. My husband has a drop-down menu next to his AutoSum that allows access to Sum, Average, count, Min and Max. I don't have access to that menu. Is that about the version I am running or can I add it? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#6
|
|||
|
|||
If you have Excel 2003, that button should be available on the standard
toolbar. Have you customized your toolbars? If not, you could try a reset: Choose ToolsCustomize On the Toolbars tab, select the Standard toolbar Click the Reset button Click OK to confirm Close the Customize dialog box. motherb wrote: When I look at my system, it appears that I am running Excel 2003. Just for the record: is that "button" there in versions after 2002 or does it have to be added? I know I sound like a simpleton, but I'd rather ask.....Thanks for your help. "Debra Dalgleish" wrote: This feature was added in Excel 2002, so if your version is earlier than that, it won't be available: Building formulas faster http://office.microsoft.com/en-ca/as...346041033.aspx MotherB wrote: I am a new Excel user. My husband has a drop-down menu next to his AutoSum that allows access to Sum, Average, count, Min and Max. I don't have access to that menu. Is that about the version I am running or can I add it? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i set up drop down menus to populate cells in excel? | Excel Discussion (Misc queries) | |||
how do I insert drop down menus into excel that are dependent on . | Excel Discussion (Misc queries) | |||
Drop Down Menu's | Excel Discussion (Misc queries) | |||
Forms Toolbar vs. Control Toolbox vs. Data Validation for drop dow | Excel Discussion (Misc queries) | |||
Drop down menus | Excel Discussion (Misc queries) |