Turn Off Auto Format of Cells

[BuddieB]

I have a tempalte at the office with a range of cells (B1 to B5) with text that uses the formatting Small Fonts + Size 7 + Bold.

However the rest of the sheet is set to Arial Font, Size 10 no bold.

When I type anything in cell B6, it picks up the formatting from above and formats it as Small Fonts, Size 7, but I want it to appear with the base format (Arial, Size 10, no bold)

Why does it keep reformatting anything that I type under these particular cells? I can't seem to find anythign on auto formatting, or autocorrect or anything under the Tools-Options...

Please help, I have a bunch of people at my office complaining about this and I can't seem to help them!

 

[Juan Pablo González]

Under Tools | Options, Edit... uncheck the 'Extend list formats and formulas' box.

 

[BuddieB]

Thank you so much. I had missed that check box when I looked through the Options!