How do I fix Excel 2010 not responding?
How do I fix Excel 2010 not responding?
Excel not responding, hangs, freezes or stops working
- Start Excel in safe mode.
- Install the latest updates.
- Check to make sure Excel is not in use by another process.
- Investigate possible issues with add-ins.
- Investigate Excel file details and contents.
- Check whether your file is being generated by a third party.
How do you remove freeze in Excel?
To unfreeze panes, open your Excel spreadsheet. Select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Windows group. Then click on the Unfreeze Panes option in the popup menu. Now when you move around in your spreadsheet, columns and rows should display as normal.
How do you unfreeze panes in Excel 2010 starter?
For Excel 2007/2010, click the View tab. From the Window group click the Freeze Panes button and select the Freeze Panes command. To unfreeze, retrace your steps and select the Unfreeze Panes command.
How do I reset excel to default settings?
Click on the “Tools” menu and then click “Customize.”. Right-click the menu you want to restore and then click the “Reset” button. This will restore the menu to its original settings. Consequently, restoring all the menus will restore Microsoft Excel to its defaults.
How do you force quit excel?
To quickly force quit on Windows, use the keyboard shortcut Alt + F4….How to force quit on Windows using Task Manager
- Press Control + Alt + Delete.
- Choose Task Manager.
- Select the application that you want to force quit.
- Click End task.
How do you unlock cells in Excel?
Here’s how to lock or unlock cells in Microsoft Excel 2016 and 2013.
- Select the cells you wish to modify.
- Choose the “Home” tab.
- In the “Cells” area, select “Format” > “Format Cells“.
- Select the “Protection” tab.
- Uncheck the box for “Locked” to unlock the cells. Check the box to lock them. Select “OK“.
Is it possible to recover unsaved excel document?
Then go to the File tab on your Ribbon and click Open. Click Recent and then scroll to the bottom of the page and click Recover Unsaved Workbooks (see the screenshot below). A Document Recovery pane should appear with all unsaved Excel files listed (see the screenshot below). Choose the file that you want to recover.
How do I unlock freeze panes in Excel?
How to Freeze Panes in an Excel 2010 Worksheet. In the Window group of the View tab, choose Freeze Panes→Unfreeze Panes to unlock the fixed rows and columns. You can click the Freeze Top Row or Freeze First Column command in the Freeze Panes drop-down menu to freeze just the top row or first column in the worksheet,…
What to do if Excel freezes?
Reinstall Office Right-click the “Start” button, then select “ Control Panel “. Select “Programs“. Select “Uninstall a program“. Locate “Microsoft Office” in the list. Right-click it, then choose “Change“. Select “Quick Repair“, then click “Repair“. Once the repair is complete. Try to launch Excel and see if you have a freezing problem.
Why is Excel freezing my computer?
Incompatible Add-Ins
How do I freeze only certain rows in Excel?
To freeze certain rows in Excel, first scroll to the first row to be frozen (the first row you want to freeze needs to be the first row visible on screen), now select all the rows you want to freeze and click the Freeze Panes button. Do the same if you wish to freeze certain columns.
