Save Display and Print Settings in Excel

A custom view in Excel can consist of print settings such as margins, page breaks and print scaling and display settings such as filters and hidden columns. You can create as many custom views as you wish making them perfect for frequently used views and print jobs. They will save time and increase efficiency.

Switching between views is easy and depletes the need to unhide columns or remove filters to return to normal or another view you need to use.

Create a Custom View

1. Change the worksheet display and print settings as required

2. Click the View tab on the Ribbon

3. Click the Custom Views button in the Workbook Views group

Custom Views dialog box
Custom Views dialog box

4. Click the Add button

Add a new Custom View
Add a new Custom View

5. Enter a name for your custom view

6. Uncheck the Print settings or Hidden rows, columns and filter settings boxes if required and click Ok

Show a Custom View

Once you have created the required custom views. You need to know how to switch between the different views you have created.

It is always advised to create one view that contains your normal settings without any filters or hidden columns. This makes it easy to return to normal removing any display settings that had been applied.

1. Click the Custom Views button in the Workbook View group of the View tab

2. Select the view you want to apply and click the Show button

A button can be added to the toolbar to make switching views even quicker and easier.

Add the Custom View List to the Toolbar

Adding a button to the toolbar will allow you to select a Custom View from a list. This command was introduced with Excel 2010 meaning unfortunately it is not available with previous versions.

1. Click the Customise Quick Access Toolbar button on the end of the toolbar and select More Commands

Customise the Quick Access Toolbar
Customise the Quick Access Toolbar

2. Click the Popular Commands list and select All Commands

3. Scroll down until you see the Custom View buttons. There are two. The first one provides a list giving faster access to your custom views than the dialog box

Add the Custom View list button to the toolbar
Add the Custom View list button to the toolbar

4. Select the command and click the Add button

5. Click Ok

6. The button is added to the Quick Access Toolbar, click it and choose a view to easily switch between views.

Select a view
Select a view

Watch the Video

More by this Author

  • Sort Pictures in an Excel List

    If you are using pictures in your Excel spreadsheet you may be having some difficulty with sorting the pictures along with the other data in the list. The good news is that you can sort pictures in an Excel list just...

  • Create an Interactive Excel Chart using Option Buttons

    Form controls can be added to an Excel spreadsheet to create interactivity with the user. This article looks at using option button controls to allow a user to choose the data they want to see on a chart. The first...

  • Brock Lesnar Nutrition and Workouts

    Brock Lesnar is a phenomenon of a man and an athlete. Brock Lesnar weighs a lean 265 lbs and yet possesses extreme speed, agility and athleticism. How a man carrying so much muscle mass can maintain such high levels of...

Comments 1 comment

leeba ann varghes profile image

leeba ann varghes 4 years ago from India

Good job...and it was well explained..Thankyou.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.

    Click to Rate This Article