How to Change the Default View in Excel 2013

Last updated on May 9th, 2023 at 04:57 pm

Microsoft Excel 2013 has a number of different possible uses, and it isn’t uncommon for one person to take advantage of many of these uses. So, in certain situations, different views of a worksheet are more helpful than others. If you find that you prefer a different view in Excel than the current default option, then you can follow the steps outlined below to set a different default view in Excel 2013.

Amazon gift cards are perfect for the online shoppers in your life, and they can be purchased in a variety of denominations. You can even create a video gift card. Learn more about the different types of Amazon gift cards here.


Use a Different Default View in Excel 2013

Note that making this adjustment will force Excel to open in this view anytime you launch the program. If you just want to be able to change the view in Excel occasionally, then you would be better served by clicking the View tab at the top of the window, then selecting your preferred view.


Step 1: Open Microsoft Excel 2013, then select your workbook type.


Step 2: Click the File tab at the top of the window.

click the file tab



Step 3: Click Options at the bottom of the column on the left side of the window.

click options in the left column



Step 4: Click the General option in the left side of the Excel Options window.

click general in the left column of the excel options window



Step 5: Click the drop-down menu to the right of Default view for new sheets, then select the view that you want to use whenever you create a new worksheet.

how to change the default view in excel 2013



Step 5: Click the OK button at the bottom of the window.


If your copy of Excel 2013 is saving to SkyDrive by default, you can adjust that setting. Learn how to save to your computer by default in Excel 2013.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Newest Guides