How to change default view in excel in O365?

%3CLINGO-SUB%20id%3D%22lingo-sub-1361233%22%20slang%3D%22en-US%22%3EHow%20to%20change%20default%20view%20in%20excel%20in%20O365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1361233%22%20slang%3D%22en-US%22%3E%3CP%3EWorking%20with%20online%20version%20of%20excel.%3C%2FP%3E%3CP%3EI%20can%20create%20and%20save%20views%2C%20but%20they%20are%20not%20persistent%20across%20sheets.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20create%20views%20that%20are%20persistent%20across%20all%20sheets%20in%20a%20workbook%3F%26nbsp%3B%20Or....%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20change%20the%20'Default'%20view%20settings%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1361233%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1385578%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20default%20view%20in%20excel%20in%20O365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1385578%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F656740%22%20target%3D%22_blank%22%3E%40Newby2245%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20change%20default%20view%20in%20Excel%2C%20you%20need%20to%20go%20to%20the%20Excel%20Options%20to%20change%20its%20default%20setting.%3C%2FP%3E%3CP%3E1.%20Enable%20Excel%2C%20and%20click%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EOffice%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ebutton%20or%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EFile%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Etab%20%26gt%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EOptions%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%3CSPAN%3E2.%20In%20the%20pop-up%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EExcel%20Options%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bdialog%2C%20find%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EDefault%20view%20for%20new%20sheets%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bin%20right%20section%2C%20and%20choose%20the%20view%20you%20want%20to%20specify%20from%20the%20drop%20down%20list.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E3.%20Click%26nbsp%3B%3CSTRONG%3EOK%3C%2FSTRONG%3E%26nbsp%3Bto%20close%20the%20dialog.%20And%20when%20you%20create%20a%20new%20workbook%2C%20the%20default%20view%20will%20be%20changed%20to%20the%20new%20view%20you%20choose.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3ENote%3C%2FSTRONG%3E%3A%20The%20changing%20view%20only%20work%20in%20the%20new%20creating%20workbooks%2C%20the%20existing%20workbook%20will%20be%20kept%20in%20Normal%20view%20when%20you%20open%20them.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Working with online version of excel.

I can create and save views, but they are not persistent across sheets.

Is there a way to create views that are persistent across all sheets in a workbook?  Or....

Is there a way to change the 'Default' view settings?

 

Thanks in advance.

 

2 Replies
Highlighted

@Newby2245 

 

To change default view in Excel, you need to go to the Excel Options to change its default setting.

1. Enable Excel, and click Office button or File tab > Options.

2. In the pop-up Excel Options dialog, find Default view for new sheets in right section, and choose the view you want to specify from the drop down list.

3. Click OK to close the dialog. And when you create a new workbook, the default view will be changed to the new view you choose.

 

Note: The changing view only work in the new creating workbooks, the existing workbook will be kept in Normal view when you open them.

 

Highlighted

@Newby2245 

Sheet View in Excel Online is mainly to keep filtering and sorting of the data in the sheet independent for different users. Thus you can't apply created custom view to another sheet with another data. If only not to duplicate the sheet.

Customization of the Default view - not sure, but I'm doubt. Excel Online has very poor customization options.