What should I do if excel freezes?
Most cases where Excel is stuck are because too many formulas have been inserted. These formulas will run during operation, so it will become very stuck. Just clear the formulas.
The following is how to quickly clear formulas:
Recommended: "Excel Tutorial"
1. Clear several filtering rules that come with the system.
Filtering is the fastest. As long as the filtering rules are set once and are not cleared, the conditional deletion will be repeated every time the table is operated. It is recommended to clear all conditional formats and set them when you want to use them.
1. Open the Excel worksheet and select "Start" - "Conditional Formatting" on the toolbar.
#2. Select "Clear Rules" - "Clear Rules for the Entire Worksheet" in the drop-down box.
2. Clear all formulas and formats in the table
This operation will clear the format and all applied formulas in the entire table. Please consider carefully before use. .
1. Open the Excel worksheet and select "Start" - "Clear" on the toolbar.
#2. Select "Clear Format" in the drop-down box. If you clear all formats and still get stuck, you can only try reinstalling Office.
The above is the detailed content of What to do if excel freezes. For more information, please follow other related articles on the PHP Chinese website!