Wednesday, April 26, 2017

How to Fix Excel Freezing when Trying to Merge and Center in Windows 7

Please Disable Tracking in Firefox so that my ad revenue and sharing widget are not blocked.  Thanks!

You can see a shield icon at the left end of the location/address bar when you are in private browsing mode that some content is blocked.
 Method 1
Left click the shield and click Disable Tracking.
Method 2
Disable this feature in "Options/Preferences > Privacy".
  • Options/Preferences > Privacy: "Use Tracking Protection in Private Windows"







 Don't Pull your hair out...


Sometimes the simplest fix and the ones that we do not immediately think of can
in the end be the most effective.  That's the case with this fix.

A co-worker of mine was having this problem with Excel freezing while she was
trying to merge and center a series of cells.  

After trying numerous other methods to fix the problem I settled on trying to let 
Microsoft fix the problem with not much faith that it actually would.  Here's how.

Make sure "Excel" and any Microsoft Office programs are closed and are not running

From the Desktop Left Click "Start"

Then Left Click on "Control Panel"

Then Left Click on "Programs and Features".

In the new window scroll down the list of installed programs.

Right Click on "Microsoft Office" or "Microsoft Office Excel" 

Then Left click "Change" in the drop down menu. 

In the next window Left Click the radio box labeled "Repair" and then Left Click the button
on the bottom right of the window.

Microsoft will attempt to repair Microsoft Office. 

Close the windows when it is finished.  

Open Excel and try to merge and center again.

You should now be able to Merge and Center in Excel with no problems.