New workbooks have default settings in font format, views, and the number of worksheets they contain, and can be changed based on personal habits.
Changing the default display format for a new workbook is also done in the Excel Options dialog box.
First, Excel2010 version
1, open "file" → "options", as shown in the picture:
2, open "Excel Options", the dialog box, the General tab in the "New Workbook" column in the specific settings, as shown in the figure:
Second, Excel2003 version
1, select "Tools" → "Options", as shown in the picture:
2. Set up in the General tab, where you can set the location of the workbook to be saved and the files opened at startup, as shown in the figure: