Font change won't take!
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 |
Answer: Font change won't take!
Hi there! I'm sorry to hear that you're having trouble with formatting your Excel spreadsheet. Here are some steps you can try to resolve the issue:
If you have tried these steps and are still having trouble with the formatting changes not sticking, it's possible that there is a problem with your Excel installation or with the file itself. In this case, you may want to try repairing or reinstalling Excel, or creating a new file and copying the data over to see if that resolves the issue. |
Font change won't take!
Check and see if the cell(s) have conditional formatting applied - that may
be what's forcing the color back to black when you leave it. In the menu bar: Format | Conditional Formatting see if there are any conditions applied. You can also try selecting the cells and choosing Clear | Formats and seeing if you can't set the color/bold property after that. But any special number properties you had applied to them will also disappear. "gaca0002" wrote: 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 |
Locked fonts in Excel
Quote:
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! |
All times are GMT +1. The time now is 04:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com