I need to renable autosum button

F

Flint

I set excel so that each column heading has drop down buttons enabling me to
sort out entries (rows) by what is entered in any cell. Now my autosum button
is disabled. I can still make formulas step by step. I don't remember how i
set it up that way, or I'd just turn it off while trying to enter
formulas.....

TIA
 
G

gls858

Flint said:
I set excel so that each column heading has drop down buttons enabling me to
sort out entries (rows) by what is entered in any cell. Now my autosum button
is disabled. I can still make formulas step by step. I don't remember how i
set it up that way, or I'd just turn it off while trying to enter
formulas.....

TIA
Click to expand...

Go to Data > Filter uncheck Auto filter. This will remove the drop
down boxes.

gls858
 
F

Flint

Hope top-posting is not the way to go here...
I was able to remove the dropdown boxes, however autosum button still not
working....?

Flint
 
Top