How to set excel into compatibility mode

Excel is the office software we often use. Win7 system uses a higher version of Excel to open some tables created by a lower version of Excel. The words "Compatibility Mode" will be displayed. How to solve the problem that Excel in Win7 system will display the words "Compatibility Mode", which affects the appearance of Excel? The editor has compiled some solutions for everyone. If necessary, you may wish to learn together.
Recommendation: Laptop win7 system download
Solution:
1. After opening a form, click the "office" icon button in the upper left corner and click "Save As";
2. In Save As Select "Excel Workbook" from the menu, and then click Save;
3. Re-open the table you just saved, and there will be no "Compatibility Mode" in the title;
4. In fact, this method is to save the lower version Convert the file to a higher version and don't like the words "Compatibility Mode".
Today I will share the solution to the problem that Excel in Win7 system will display the words "Compatibility Mode", but the words "Compatibility Mode" will disappear. I hope it will be helpful to everyone!

1. First open the excel software, find the "File" menu, click "Options", and in the "Options" window, click the "Advanced" tab.
2. Secondly, in the "Advanced" tab, find the "Compatibility Options" column, click the "Excel workbook type used when opening the file" drop-down menu, and select the "excel workbook" option.
3. Then in the "Compatibility Options", find the "Enable all macros" column and select the "Enable" option.
3. Finally, in the "Compatibility Options", find the "Delete unused cells" column, select the "Delete unused cells when opening the document" option, click the "OK" button to save the settings You can change the excl compatibility mode.

The method to modify excel compatibility mode is as follows
1. Open the Excel compatibility mode file and click the file tab in the upper left corner .
2. Select the Save As option in the File menu list.
3. Set the default file saving format in the save type item in the Save As window. Excel file (suffix is ​​xlsx), change the file name and save location, and click Save.
4. Open the file again and it will be in the normal normal mode. Extended information: excel compatibility mode Reason: When we use a higher version of Excel (2007, 2010) to open an Excel2003 document, the top middle of the interface will appear: file name + [compatibility mode]. Because the file format used by the new version of excel is xlsx, and if you use the new version to open the old file format xls, it will be opened in compatibility mode
If you need to set the compatibility mode, you can follow the following steps:
1. Click the File menu, select "Save", and then select "Save in Compatibility Mode";
2. In the "Save As" dialog box, find the "Save as type" and set it to "Excel97-2003 Work "Book";
3. Click the Save button to complete saving the file, and then the Excel table can be modified into compatibility mode.