How do I get Excel to stop auto-formatting?
 

(Grumbles)
I have gone into the "Tools" tab and in the "AutoCorrect Options,"
"Customize," and "Options" sections and turned off every autocorrect and
autoformat feature I can find. Yet Excel STILL tries to figure out the
formats for the next cell I enter data into. How do you stop Excel from
doing this? (It's pretty lousy and guessing what I want.) Thank you!

How do I get Excel to stop auto-formatting?
 

Have you tried ToolsOptionsEdit.....uncheck "extend data range formats and
formulas"?


Gord Dibben MS Excel MVP

On Thu, 30 Mar 2006 07:26:02 -0800, topsquark
wrote:

(Grumbles)
I have gone into the "Tools" tab and in the "AutoCorrect Options,"
"Customize," and "Options" sections and turned off every autocorrect and
autoformat feature I can find. Yet Excel STILL tries to figure out the
formats for the next cell I enter data into. How do you stop Excel from
doing this? (It's pretty lousy and guessing what I want.) Thank you!

How do I get Excel to stop auto-formatting?
 

Ooooh! No, I didn't notice that one. Thank you!


"Gord Dibben" wrote:

Have you tried ToolsOptionsEdit.....uncheck "extend data range formats and
formulas"?


Gord Dibben MS Excel MVP

On Thu, 30 Mar 2006 07:26:02 -0800, topsquark
wrote:

(Grumbles)
I have gone into the "Tools" tab and in the "AutoCorrect Options,"
"Customize," and "Options" sections and turned off every autocorrect and
autoformat feature I can find. Yet Excel STILL tries to figure out the
formats for the next cell I enter data into. How do you stop Excel from
doing this? (It's pretty lousy and guessing what I want.) Thank you!