Best Method to Fix Computer Errors: Troubleshooting:Cannot change font; cells won't format--WORK AROUND Error

Tuesday, 13 September 2016

Cannot change font; cells won't format--WORK AROUND

In the spirit of reciprocity, thought I'd put this problem & fix out there since I just spent an hour pulling out my hair and strangely (and maybe for the first time ever) could not find any threads out there with the same/similar problem. I'm pretty
proficient with Excel too, but this was killing me...absolutely maddening.
Anyway, I noticed the problem when I cut and paste a bunch of cells from one workbook to another. When I'd highlight the entire worksheet to adjust the font the cells that had been pasted would not change. I then realized that I had many many sheets within
these two HUGE workbooks that for whatever reason would not allow a font change--I could change ALL other formatting that I tried. And, the cell wouldsay it was the font that I wanted even though it clearly wasn't.
After protecting/unprotecting, sharing/unsharing, closing/reopening, changing default font, running Office diagnostics, etc...THE FIX...CHANGE THE FONT SIZE .
As soon as I changed the font size (even by one pt.) all of the fonts changed to the proper font and then I just reverted to the original size.
If you ever run into this stupid problem now here's a thread out there to try and help you resolve this.

Anwsers to the Problem Cannot change font; cells won't format--WORK AROUND

Download SmartPCFixer for Free Now

Run CHKDSK to Fix Cannot change font; cells won't format--WORK AROUND

Go to the Start button.
In the Search box, type "cmd" (without quotes) and press Enter.
At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
Reboot your computer.

An error might pop up:

"Access denied as you do not have significant privileges. You have to invoke this utility in elevated mode."

If you receive the above error message, it means you are not logged into you computer as an Administrator. If that's the case, follow these steps to run the command prompt in elevated mode:

Go to theStart button.
Go to "All Programs > Accessories" and right click on "Command Prompt".
Select "Run as Administrator".
In the Search box, type "cmd" (without quotes) and press Enter.
At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
Reboot your computer.

Another Safe way to Fix the Problem: Cannot change font; cells won't format--WORK AROUND:

How to Fix Cannot change font; cells won't format--WORK AROUND with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your computer. When you open SmartPCFixer, it will perform a scan.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.