ed
Autofill options can be found at a couple or more various places.
1. Edit>Fill...........check out the options.
2. Right-click and drag then release to see some autofill options.
3. If you have data in a column and a formula in an adjacent column,
double-click on a cell in the adjacent column to autofill.
Don't understand the other request about toggle total row.
Gord Dibben MS Excel MVP
