Excel freezes when formatting cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1712978%22%20slang%3D%22en-US%22%3EExcel%20freezes%20when%20formatting%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1712978%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20try%20to%20format%20a%20cell%20in%20Excel%20-%20bolding%2C%20underlining%2C%20switching%20font%20size%20-%20the%20program%20freezes%20and%20I%20need%20to%20re-start.%26nbsp%3B%20Is%20a%20new%20issue%20from%20last%202%20days%20having%20worked%20without%20problems%20previously.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20program%20repair%2C%20updates%20and%20re-installing%20Office%20and%20running%20in%20safe%20mode.%26nbsp%3B%20No%20luck.%26nbsp%3B%20Any%20suggestions%20for%20how%20I%20solve%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1712978%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1714049%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20freezes%20when%20formatting%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1714049%22%20slang%3D%22de-DE%22%3EUnfortunately%2C%20I%20can't%20help%20you%20there.%20The%20only%20thing%20I%20have%20to%20offer%20is%20an%20old%20ticket%20through%20office%202016%20with%20roughly%20the%20same%20problem.%20Take%20a%20look%2C%20maybe%20this%20will%20help%20you.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fmicrosoft-excel-2016-crashes-on-formatting-cells%2F51e29d30-82b0-4eae-bc3f-577b97d04bc9%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fmicrosoft-excel-2016-crashes-on-formatting-cells%2F51e29d30-82b0-4eae-bc3f-577b97d04bc9%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2022002%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20freezes%20when%20formatting%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2022002%22%20slang%3D%22en-US%22%3EThis%20may%20sound%20ridiculously%20simple%2C%20but%20try%20to%20change%20your%20default%20printer%20to%20PDF.%20I%20have%20suffered%20from%20the%20same%20problem%20and%20this%20helped%20instantly.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2128549%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20freezes%20when%20formatting%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2128549%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F914143%22%20target%3D%22_blank%22%3E%40Emiru%3C%2FA%3E%26nbsp%3BBrilliant.%20Have%20been%20having%20this%20problem%20for%20a%20while%20(may%20be%20because%20I%20am%20still%20using%20Windows%207).%20I%20Changed%20the%20PDF%20printer%20to%20default%20and%20all%20is%20now%20fine.%20Many%20thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

When I try to format a cell in Excel - bolding, underlining, switching font size - the program freezes and I need to re-start.  Is a new issue from last 2 days having worked without problems previously.

 

I've tried program repair, updates and re-installing Office and running in safe mode.  No luck.  Any suggestions for how I solve?

 

Many thanks!

 

13 Replies
Unfortunately, I can't help you there. The only thing I have to offer is an old ticket through office 2016 with roughly the same problem. Take a look, maybe this will help you.

https://answers.microsoft.com/en-us/msoffice/forum/all/microsoft-excel-2016-crashes-on-formatting-ce...

Nikolino
I know I don't know anything (Socrates)
This may sound ridiculously simple, but try to change your default printer to PDF. I have suffered from the same problem and this helped instantly.

@Emiru   Thank you. Thank you.  I just had the same problem for the past 8 hours.  I went in to set my default printer.  I did not have one set.  I had powered down my printer the night before.  I set the default printer to the pdf option.  It worked.    Thanks, again. 

@Emiru Brilliant. Have been having this problem for a while (may be because I am still using Windows 7). I Changed the PDF printer to default and all is now fine. Many thanks!

can't imagine how on earth you ever figured this out, but i'm glad you did, worked perfectly, thanks!

@charlie1volley Very strange, but that does appear to work.  I just changed my default printer to Microsoft PDF and the format cells no longer pauses/hangs Excel for 40-60 seconds.  Great workaround, now let's see if the good folks at Microsoft can fix that one

 

This just happened to me today and the solution worked! Thank you!!

@THill9999 Where? Where do we set this? In Excel Print dialogue? Or in Windows Printers? TIA

I solved my issue by going in Excel and selecting File, Print, Printer and selecting a printer.  I did not have a printer listed when I experienced my issue.

Hi @MarioPetrella, on windows 10 I just went to Settings > Printers & scanners > select: Microsoft print to PDF under the list of Printers & scanners > click: Manage > select: Set as default.  When you go back to the Printers & scanners menu, it should say Default underneath Microsoft print to PDF...

@charlie1volley  Thanks! 

 

I found that I needed to make a change in Windows settings; but ... 

 

After I failed using the Print dialogue in the app (that also caused a hang), followed by being unable to get a "make Default" dialogue within the list of Printers, AND showing no printers in Settings. (I did, however, see a check box for allowing Windows to manage Printer selection. 

 

So, what I did to resolve my issue was to first re-Start the machine; then when I came back up I was able to right-click on Microsoft PDF among the list of Printers in the File Explorer window, and set that as the Default (at this point I received a dialogue informing me that Windows would no longer Manage my printers for me). 

 

So it looks like, in my case, some change occurred under the covers that cascaded into the issue I was experiencing. 

 

Thank you to all for assisting correcting my problem! 

@Emiru

Thanks it works, Microsoft sucks!!!

Wie kann ich eine 15 spaltige und 1000 Zeilen Datei mit unterschiedlichen Zahlen von 1-300 so reihen, daß alle Zahlen aufsteigend in der Zeile gereiht werden