Use Custom Views in Excel to Save Specific Worksheet Layouts

MakeUseOf | 10/9/2017 | Nancy Messieh
kimberly163 (Posted by) Level 3
Click For Photo: http://cdn.makeuseof.com/wp-content/uploads/2016/11/Excel-994x400.jpg?x81309

Excel’s Custom View setting makes it easy to view specific information on a crowded spreadsheet or to create different layouts for your data. You can use it to create custom headers or footers, create a print-friendly version of your spreadsheet, or you can create a view in which freeze panes or split rows are activated.

The first thing you’ll want to do is to create the view you want to save as a custom view. For example, let’s say you want in some instances to be able to hide a series of rows in your custom view. First, create a custom view for when all rows and columns are shown:

Worksheet - View - Tab - Click - Custom

Open up your worksheet and go to the View tab and click Custom Views.

In the dialog box that pops up, click Add.

Type - Name - Custom - View - Eg

Type in a name for your Custom View (e.g. “Full View”). Make sure Hidden Rows, Columns, and Filter settings is checked.

Next, create the custom view setting for when specific columns or rows are hidden:

Rows - Columns - Hide

Select the rows or columns you want to hide, right click them and click Hide.

Go back to the Custom Views dialog box and click Add.

Type - Name - Custom - View - Eg

Type in a name for your Custom View (e.g. “Hidden View”)....
(Excerpt) Read more at: MakeUseOf
47 other people are viewing this story
Wake Up To Breaking News!
Sign In or Register to comment.