We like the auto fill options button when changing formulas for many cells.
However, we would like to change the default auto fill from COPY CELLS to
FILL FORMATTING ONLY.

Is there anyway to do this?


Patti Brookens
Strickler Agency Inc
Chambersburg PA