How do I turn off automatic bold formatting of cells below other bolded cells?

S

Stuart Krasnoff

I have a sheet I use as a template in which I bolded cells b1-b8. I
left b9 and b10 blank with no bolding. b10 is bolded. When I select any
cell below b10 it shows as not bolded. When I enter data in b11 it
automatically converts to bold. I dont want it to do this. I want to
turn this extremely annoying feature off, butI can't find the switch.
Any help out there would be appreciated.

Thanks...
 
J

J.E. McGimpsey

Stuart Krasnoff said:
I have a sheet I use as a template in which I bolded cells b1-b8. I
left b9 and b10 blank with no bolding. b10 is bolded. When I select any
cell below b10 it shows as not bolded. When I enter data in b11 it
automatically converts to bold. I dont want it to do this. I want to
turn this extremely annoying feature off, butI can't find the switch.
Any help out there would be appreciated.
Click to expand...

Uncheck the Extend Formats and Formulas checkbox in Preferences/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

how to turn off automatic bold formatting of cells below other bolded cells 1
How do I get the days in calendar (Busy/Out of office) to bold? 1
How do I turn off annotating with ink in Excel 2016 2
How do I turn off the automated update of styles? 3
Automatic formatting 2
Backgroud color for 1 cell based on a range of cells values 3
How do I subtract using formulas? 4
How do I remove bold from equaiton editor? 1

Top