Format disappears after saving excel spreadsheet

Problem:

After saving the Excel spreadsheet, the original formatting is lost when it is reopened.

Solution:

Click on the three horizontal lines next to the file in the upper left corner of the table

Then click on the option below to go to the next Settings window

#After entering the table options interface, find General and Save and click it, and then find the default document saving format in this window.

After finding it, click the drop-down button in the options on the left and set the default format for saving the document to "*microsoft excel97-2003 file (.xls)" That's it.

#If you want to know more related content, please pay attention to the excel tutorial column on the php Chinese website!

The above is the detailed content of Format disappears after saving excel spreadsheet. For more information, please follow other related articles on the PHP Chinese website!