How to Change the Default View in Excel 2013

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.

As an Amazon affiliate, I earn from qualifying purchases.

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.

Now that you know how to change the default view in Excel 2013, you can use the view that you prefer without having to make that change every time you create a new wrokbook.

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