Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Friday, May 29, 2009 – Permalink –

Report Manager

Define Print & View Areas


The Excel 2000 Report Manager add-in is not included with Excel 2002+, as was the case with previous versions of Excel.

To use it, you must first download the Excel 2002 Report Manager add-in from Downloads on Microsoft Office Online. Follow the instructions on the Downloads page to install the Report Manager.
(For 2007 see Support.Microsoft.com)

from Microsoft Office Online


"Using the Report Manager add-in program, you can combine worksheets , views (a set of display and print settings that you can name and apply to a workbook. You can create more than one view of the same workbook without saving separate copies of the workbook.), and scenarios (a named set of input values that you can substitute in a worksheet model.) into printable reports. For example, if you have a Best Case and a Worst case scenario, a Summary view, and a Details view, you can create a report that presents the Best Case scenario in the Details view and another report that presents the Best Case Scenario in the Summary view. Reports that you create are automatically saved with your workbook so that you can print them at any time."


Note If the Report Manager is not available on the View menu after downloading the add-in, click Add-ins on the Tools menu, and then select Report Manager.

You can use the Report Manager to do the following:

Create a report for printing

  1. On the View menu, click Report Manager.
  2. Click Add.
  3. In the Report Name box, type a name for the report.
  4. In the Sheet box, click the sheet you want to use for the first section of the report.
  5. Do one of the following:
    • To use a view for the first section of the report, select the View check box, and then click the view in the View box.
    • To use a scenario for the first section of the report, select the Scenario check box, and then click the scenario in the Scenario box.
  6. Click Add to enter the view or scenario as a section in the Sections in this Report box.
  7. Repeat step 5 and 6 until you've created all of the sections you want in the report.
  8. To change the order of the sections, in the Sections in this report box, click the section you want to move, and then click either Move Up or Move Down.
  9. To number the pages of the report consecutively, select the Use Continuous Page Numbers check box.
Note Microsoft Excel prints sections of a report in the order in which they're listed in the Sections in this report box.

Edit a report for printing

  1. On the View menu, click Report Manager.
  2. In the Reports box, click the report you want to edit, and then click Edit.
  3. Do one or more of the following:
    • To add a new section, click the sheet, view, and scenario you want under Section to Add, and then click Add.
    • To delete a section, click the section in the Sections in this report box, and then click Delete.
    • To change the order of the sections, in the Sections in this report box, click the section you want to move, and then click either Move Up or Move Down.
    • To number the pages of the report consecutively, select the Use Continuous Page Numbers check box.
    Note Microsoft Excel prints sections of a report in the order in which they're listed in the Sections in this report box.

Print a report

  1. On the View menu, click Report Manager.
  2. In the Reports box, click the report you want to print.
  3. Click Print.
  4. In the Copies box, type the number of copies you want to print.
Also see: Template Wizard with Data Tracking




See all Topics

Labels: ,


<Doug Klippert@ 3:34 AM

Comments: Post a Comment