How to Use Custom Views

Author Zaheer    Category Guides     Tags ,

Most people don’t have the knowledge on what are custom views. What are Excel’s custom views? Custom Views in Microsoft Excel is a competent and well-organized way to view your presentation. All the names that are indicated in your custom views show all the items at a given moment. The custom views update all your files whenever you open it and they enable you to find the items in just a moment. They are being restricted in just single items such as notes or tasks. Thus, you can search automatically and combine number of mixed lists of items to the mail messages coming from the calendar. In consequence, if many messages are received meeting the criteria while the custom view is open, these messages are added automatically to the view. Through this, you save a lot of frustrations through clicking the mouse repeatedly.

How Would Custom Views Help the User on Frequent Basis?

By using custom views, you can easily search your queries. Thus, you can also connect to “save as custom view” displayed in your toolbar. In Entourage 2001, this custom view is called “messages received today” and it is located under the folders of custom views in your folder list. This is very common, through custom views you can simply view your messages in an instant instead of having the Advanced Find wherein you are to enter the criteria whenever the user wanted to see the files. The other thing that you have to know is that, contents are changing daily without the any interventions of the users, therefore, the views remains applicable and significant.

Where Can the User Find Custom Views?

If you are keen to notice that the Entourage provides a number of custom views that are pre-configured. Entourage 2004 is used and accessed through clicking the navigation button “project center”. Some of the custom views in every type of the view are folder list provided. Try to click the “expand” triangle button next in any of the view folder, and click the preferred view displaying the data that match your criteria. If you want to show the custom pre-configured views, just click the folder of custom views in the Entourage 2001 folder list.

How Does the User Create Efficient Custom Views?

It is very inconvenient when you are interrupted with your presentation flow by having to scroll and position every area when it is needed. Most people wanted to demonstrate what they want to utter through pointing out the preferred areas of your worksheets. Through Microsoft Excel, you can create your presentation using custom views. Custom views can be accessed in the toolbar list by just clicking. Custom views have the resemblance to the Advanced Find with similar numerous powerful features.

The first thing that you have to do in creating custom views is to follow these instructions below:

  • Type in Go to then opt for the view for your worksheet area.
  • Go to custom views
  • The user has to click the Add Button then enter your view name then click OK.

These above instructions are to be repeated in case you have to create another custom views. These are instructions to create the presentation custom bar.

  • Customize or connect to Go to tools.
  • Connect to tool bar tab then click the New button.
  • The user should have enter a name for his tool bar
  • Click to the tab for commands.
  • Click “View under Categories”
  • Click “Custom Views under Commands” then drag this to your custom tool bar.
  • Click the “close” button

For the quick custom view for your presentation, click the small down arrow on the Custom View button and then select the view you want to present from the presentation.

How the User Delete a Single Custom View?

When deleting one custom view, you need to go to the menu bar, and then go to custom views. Look for the view tab, “workbook views group” and “custom views” displayed in your monitor. You can view the views box then select your desired view name and then click the “delete” button.

Moreover, you can also use custom view to save the display settings like widths, row heights, columns, filter settings, window settings and cell selections. In addition, in print settings, you can save the margins, sheet settings, page settings, footers and headers for your worksheet. Thus, you can apply it immediately when you need another worksheet.

Post comment