You are here: Home / Archives for June 2008

Change the number of the recently used workbooks

June 2, 2008 By

When you click on Excel File menu you get a list of the most recently used workbooks.

By default Excel provides a list of four files in the recently used list of workbooks. However you can change this number to your needs as follows:

  1. On the Tools menu click Options.
  2. On the Options window click the General tab.
  3. Make sure the check box labeled ‘Recently used file list’ is selected.
  4. Change the number of entries as you desire.
  5. To hide or clear the history of recently used workbooks, simply clear the check box.

Applies to: Excel 2003

Filed Under: Customization Tagged With: , ,

How to create, display and delete custom views

June 1, 2008 By

If you have a large Excel worksheet and find it difficult to navigate from one part of the worksheet to another, then you can use a feature in Excel called Custom Views to define parts of your worksheet as unique units.To create a custom view:

  1. Select the worksheet area that you want to define as a view.
  2. In the View menu click Custom Views. The Custom Views window will open.

custview1.gif

  1. Click the Add button. The Add View window will open.

custview2.gif

  1. Enter a name for the view then click OK.
  2. Your view should now be created.

To display a custom view:

  1. In the View menu click Custom Views.
  2. The Custom Views window will open with a list of available views.
  3. Select the required view then click Show. Or simply double-click on the name of the view.

To Delete a custom view, follow the same procedure for a display but click on Delete instead of Show.

Applies to: Excel 2003

Filed Under: Customization Tagged With: ,
Newer Posts »