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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Test question 1
Disable auto (date) format? 3
How to stop automatic cell shading 3
convert lower to upper case automatically without using UPPER 6
Format as table problems.. 1
Excel autoformatting dates 1
Autoformat/Conditional Format of entered Number 2
autoformatting issues in excel 1

Back
Top