Automatic Disable of Autoformat in Excel without selecting range of cells

  • Thread starter Thread starter Iris
  • Start date Start date
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.
 
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
 
Back
Top