Tuesday, 13 September 2016

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

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.

Related: Best Way to Update & Download Toshiba Satellite A205-S4607 Speech System v.1.00.2520 driver,[Solved] Download Toshiba Satellite C655D-S9511D Face Recognition v.3.1.17 driver,How to Download Toshiba Satellite L655-S5106BN Media Controller Plug-in v. driver,Download Toshiba Satellite L845-SP4281RM PC Health Monitor v. driver,How Can You Update & Download Toshiba Satellite Pro U500-EZ1321 Web Camera Application v. driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.,Method to Update & Download ASUS K41VD Intel INF Update Driver v.,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: Tech Support: Cannot download Adobe Flash Player to watch movies and play games.,Troubleshoot:cannot create link\/formula to reference named range of merged cells.,Fast Solution to Error: Cannot connect to website search engines, receive "Internet Explorer Cannot Display the Webpage" errors,Solution to Problem: Cannot log off without error,Can't download PP templates automatically to Windows 7 w/IE 8,Can't change drive letter - Vista,Can't change homegroup sharing permission,Can't connect XP shared printer to Win7 except as a local printer.__,Can You Connect the LAN Adapter for Wii On your Windows 7 Laptop?

No comments:

Post a Comment