Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Keeps applying auto-font settings I don't want
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. -- Seb Thirlway remove large animal from email address if you want to reply. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Keeps applying auto-font settings I don't want
I believe you need to uncheck "Extend data range formats & formulas", under
Tools - Options - Edit. -- Best Regards, Luke M "Seb Thirlway" wrote in message ... 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. -- Seb Thirlway remove large animal from email address if you want to reply. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying settings across Worksheets | Excel Discussion (Misc queries) | |||
Applying template settings over multiple charts | Charts and Charting in Excel | |||
Turn off font Auto Scale globally in Excel 2003? | Charts and Charting in Excel | |||
Applying conditional formatting to a workbook in excel 2003 | Excel Discussion (Misc queries) | |||
Applying Print Settings to Several Spreadsheets At Once | Excel Discussion (Misc queries) |