Turn off built in smart formatting

  • Thread starter Thread starter bobbo
  • Start date Start date
B

bobbo

I am preparing a spreadsheet where certain lines are highlighted. If a
few highlighted lines are together it starts to apply that fill color
on the new lines when I start to enter data into them. How do I turn
this feature off?
 
Tools>Options>Edit.

Uncheck "extend data range formats and formulas"


Gord Dibben MS Excel MVP
 
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

Conditional Formatting Tricky question 5
Turning off formatting 7
copy conditional formatting using built in feature? 1
Excel 2003 - Turning off hyperlinks? 1
The data for the search should be organized in a single contiguousrange in one column. 3
How to turn off highlighting?? 2
How to keep loaded file's format intact? 1
Windows Explorer, turn off column highlighting? 1

Back
Top