Automatic Disable of Autoformat in Excel without selecting range of cells

I

Iris

Hi,

Please help on how to automatically disable autoformat in
excel without specifying the range of cells that do not
need formatting.

Thanks.
 
D

Debra Dalgleish

Do you want Excel to stop copying the formatting from rows above? If so,
you can do the following:

1. Choose Tools>Options.
2. On the Edit tab, remove the check mark from
'Extend list formats and formulas'
3. Click OK
 
Top