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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top