Sep 25 2020 05:58 AM
Sep 25 2020 05:58 AM
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?
Sep 25 2020 11:23 AM
Dec 30 2020 12:37 AMSolution
Jan 26 2021 10:37 AM
@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.
Feb 27 2021 12:06 PM
@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 :)
Jun 14 2021 01:45 PM
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.
Jun 17 2021 01:42 PM
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...
Jun 20 2021 01:20 PM
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!
Oct 13 2021 08:45 AM
Oct 31 2021 03:33 AM
@Tim_Hill2190 so we are now a year on from this issue being highlighted and Microsoft still haven't issued a simple fix? Don't they monitor this community?? Obviously too busy working on Windows 11 which is going to be just horrendous for most of us.
Jan 25 2022 07:27 AM
Thank you for your feedback.
I would be happy if you would describe the steps (what exactly you did) to us.
This would also help others here in the forum.
When describing, please also describe the digital environment.
Office version, operating system, storage medium (hard drive, OneDrive, Sharepoint, etc.), printer model.
I know I don't know anything (Socrates)