Forum Discussion

Tim_Hill2190's avatar
Tim_Hill2190
Copper Contributor
Sep 25, 2020

Excel freezes when formatting cells

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!

 

  • 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.
  • Sunnyside63's avatar
    Sunnyside63
    Copper Contributor

    Changing default printer to a PDF printer seems to have worked for me and it makes sense regarding when this started happening.  I had an older personal laptop and everything had been fine with Office apps (2010 version) and then I started noticing this problem.  I've recently purchased a new laptop and everything was fine at first but then suddenly this started happening again.  I realize now that it's related to having multiple printers from different sites installed.  I'm working part time and using this laptop and the previous for personal use and for work using a separate user account.  All printers installed show in both accounts and I'm guessing that the trashing or delay is caused by Excel trying to attach the the last printer used.  Setting default to a PDF printer that's always available prevents this from happening.  Thanks for the useful hint 

  • wolfy86's avatar
    wolfy86
    Copper Contributor
    Setting the pdf printer as default was the solution in a Office 2019!!
  • GeoffD33's avatar
    GeoffD33
    Copper Contributor

    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.

  • FKS-3's avatar
    FKS-3
    Copper Contributor
    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
  • Emiru's avatar
    Emiru
    Brass Contributor
    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.
    • DoroIA's avatar
      DoroIA
      Copper Contributor

      Thank you again!

      like all the others, I tried every think till formatting the PC! and nothing worked. 

      As it was a PC I used little I accepted to save the file myself every two minutes because on mine, it was not starting again after a few seconds but it was blocked until I kill the process.

      And ! You saved me

      thanks again

    • usama9055's avatar
      usama9055
      Copper Contributor
      I had been experiencing the same problem for almost five months. However, I resolved the issue by removing all printers from my system, and now Microsoft Excel is working perfectly
      • NikolinoDE's avatar
        NikolinoDE
        Gold Contributor

        Lalit_singh_inda 

        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.

         

        Thank you,

        NikolinoDE

        I know I don't know anything (Socrates)

Resources