How to Return All Worksheets in an Excel Workbook Back to Normal View

Excel 2013 has a few different view options that you can select from to help you format your spreadsheet properly. The view setting is an independent trait of each worksheet in a workbook, so it is entirely possible for you to have a single Excel workbook that contains multiple different view settings.

Fortunately there is an option in Excel 2013 that allows you to quickly select all of the worksheets within your workbook, then apply a change to all of those worksheets simultaneously. So if you are in a situation where you need all of your worksheets in the same view, and you don’t want to go through every worksheet and adjust that setting manually, then our steps below will show you how to return all of your worksheets back to the Normal view.


How to Change the View Setting for All Worksheets at Once in Excel 2013

The steps in this article will show you how to quickly select all of the worksheets in a workbook, then apply the same view setting to all of them. While this guide will focus on changing the view setting to the Normal View option, you could select any of the other view options instead.

Step 1: Open your workbook in Excel 2013.


Step 2: Right-click one of the worksheet tabs at the bottom of the window, then click the Select All Sheets option.

return excel worksheets to nromal view



Step 3: Click the View tab at the top of the window.

open the view menu



Step 4: Click the Normal option in the Workbook Views section of the ribbon.

how to change the view setting for all excel worksheets at once



Note that this will work regardless of the individual view settings of each worksheet.


Are you having trouble getting your worksheets to print properly? Read our Excel printing guide to see some of the more common print settings that you can use to make your spreadsheets print better. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.