Excel 2003: Keeps applying auto-font settings I don't want

S

Seb Thirlway

Hi

This has finally started to seriously annoy me.

I'm using Excel 2003 SP3. I have a pretty large list of information. A few
rows above the first blank row, I have the whole row formatted Bold+Italic.
When I enter anything into a blank row below - even though the cell format is
set to normal font - as soon as I leave a cell after typing, Excel "decides"
that I want it formatted Bold+Italic. This is driving me nuts.

It also happens with cell colours etc. How can I switch this off? If I
want something bold, italic, coloured, whatever, I'll do it myself!

I've looked through all the menus, paying particular attention to the Format
menu, but there seems to be no option to switch this "feature" off.
 
L

Luke M

I believe you need to uncheck "Extend data range formats & formulas", under
Tools - Options - Edit.
 

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 in Excel 2007 - font choice grayed out 0
I only want to change the formatting of one word in an Excel cell 2
In Excel 2003, I cannot display the toolbar with BOLD,UNDERLINE 2
format painter 4
Excel 2003; Lost Cell Shading 3
How can I pre format all Excel comments to Tahoma, font size 12, . 3
How can I bold a symbol in an Equation object in Word 2003? 3
Excel 2003 Formula Error 2

Top