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.

Microsoft Word similarly allows you to switch between different views. Our guide on how to do I get my Word document back to normal view can show you how to change views in that application.

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.

Join Our Free Newsletter

Featured guides and deals

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