Do you intend setting up different views on how you would like your worksheet to appear?
Then the custom view is the solution to your problem. You can use a custom view to save specific display settings (such as column widths, row heights, hidden rows and columns, cell selections, filter settings, and window settings) and print settings (such as page settings, margins, headers and footers, and sheet settings) for a worksheet so that you can quickly apply these settings to that worksheet when needed.
In the example below we are going to apply filters for each branch and then save each branch filter as a custom view.
Applies To: MS Excel 2003, 2007 and 2010
1. Select as per screen shot below
2. Select the Add button
3. Enter the name of the Custom View as Default
4. Select OK
5. Select Filter under the Data tab
6. Filter the data by the East Coast branch
7. Repeat steps one-three but enter the name of the custom view as East Coast
8. Select OK
9. Filter the data by the West Coast branch
10. Repeat steps one-three but enter the name of the custom view as West Coast
11. Select OK
12. Filter the data by the North Coast branch
13. Repeat steps one-three but enter the name of the custom view as North Coast
14. Select OK
15. Filter the data by the South Coast branch
16. Repeat steps one-three but enter the name of the custom view as South Coast
17. Select OK
18. Repeat step one. The screen shot below will be displayed
To display a custom view, select from the list and select the show button.
If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email [email protected] and yours could be the next Tip of the Week.
Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations
