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?

That feature has been in Excel since Excel 97.

--
Jim
"MotherB" <[email protected]> wrote in message
news:[email protected]...
|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?

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

My bad!

--
Jim
"Jim Rech" <[email protected]> wrote in message
news:%[email protected]...
| That feature has been in Excel since Excel 97.
|
| --
| Jim
| "MotherB" <[email protected]> wrote in message
| news:[email protected]...
||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?
|
|

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
>
>

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 Tools>Customize
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