Automatic Disable of Autoformat in Excel without selecting range of cells

[Iris]

Hi,

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

Thanks.

 

[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