View Single Post
  #3   Report Post  
fourthmatrix fourthmatrix is offline
Junior Member
 
Posts: 1
Default Locked fonts in Excel

Quote:
Originally Posted by gaca0002 View Post
I'm working on an Excel spreadsheet filled with just number values. In order
to highlight a particular number, I tried to make it bold and in red colored
font. As soon as I move to another cell, however, the changes revert back to
unbold and black font. I've tried to format the cell to the way I want it.
I've tried to change the font and then hit save prior to moving to the next
cell, but cannot get the change to remain. Please, help!

Thanks
This might help you:
1 - In Excel 2010 go to the Format Cells window by either:
Home tab Expand the Fonts group (bottom right)
OR right click on highlighted cells and click on Format Cells
2 - go to the Protection tab.
3 - If the Locked option is checked, then uncheck.

Hopefully this will resolve the issue.

Cheers!