How to change excel table compatibility mode to normal mode

php editor Xinyi will introduce to you how to change the excel table compatibility mode to the normal mode. In excel, sometimes when opening a table, it will be displayed in compatibility mode, causing some functions to be unavailable. To change the table to normal mode, just click "File" - "Options" - "Advanced" - "Show" and uncheck "Show features in all workbooks". This will switch the form back to normal mode, ensuring you can use all features normally.

1. Open a worksheet and display an additional compatibility mode in the name of the worksheet, as shown in the figure.

#2. In this worksheet, after modifying the content and saving it, the dialog box of the compatibility checker always pops up. It is very troublesome to see this page, as shown in the figure shown.

3. Click the Office button, click Save As, and then there are many selection lists. We choose the default file saving format, as shown in the figure.

#4. After selecting the save format, the save page will appear. You can change the file name or use the original one directly, as shown in the figure.

#5. When you open the file name you just saved, the compatibility mode will not appear, and there will be no compatibility checker dialog box when you click save.

The above is the operation method that the editor brings to you to change the compatibility mode of the excel table to the normal mode. Have you learned it? I hope my sharing can bring help to everyone. Friends should also practice more diligently after class and become more proficient in various settings of Excel software, so that future work and study can be more convenient. Let’s work hard together!

The above is the detailed content of How to change excel table compatibility mode to normal mode. For more information, please follow other related articles on the PHP Chinese website!