how to turn off "smart" formatting

  • Thread starter Thread starter Tim Zych
  • Start date Start date
T

Tim Zych

In A1:A10:
-Type in some text.
-Format as Bold and Underlined.

In A11 (unformatted), type in a word and hit enter.

On my machine, the formatting is automatically changed to
Bold and Underlined.

Is there a way to turn this "smart" feature off?

XL2000 sr1
 
That's it..thanks Ken!
-----Original Message-----
Tools / Options / Edit Tab / Uncheck 'Extend List formats and formulas'

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

---------------------------------------------------------- ------------------
Attitude - A little thing that makes a BIG difference
---------------------------------------------------------- ------------------






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.535 / Virus Database: 330 - Release Date: 01/11/2003


.
Click to expand...
 
Back
Top