Copying a Report to a Spreadsheet

Selecting and Copying a Report
Using Office 97
Using earlier version of Microsoft Office
Using other spreadsheets.

Selecting and Copying a Report (This document presumes the use of Internet Explorer)

To select the Report:

(1) Click anywhere in the report to make it the active frame.

(2) Click on "Edit .....Select All" from the menu bar.

(1) Click anywhere in the report to make it the active frame.

(2) Press and hold down the left mouse button on the top line of the report.

(3) Drag the mouse down and across the report until the whole report is highlighted, then release the mouse button.

To copy the Report:

Now either press "Ctrl + C" or click on "Edit ... Copy" on the menu bar ("Alt + E" followed by "C" for keyboard shortcuts) to copy to the clipboard the report you have selected.

Using Office 97:

If you are using Office 97, all you have to do is open Excel and paste the report into a new report. (Use either "Ctrl + V" or if using the mouse choose "Edit.....Paste" from the menu bar. Your report will now appear in your spreadsheet.

Using earlier versions of Microsoft Office:

If you are using an earlier version of Office (eg. 4.3) then you will need to open Word first and paste the report into Word. Then select the report again and copy it in Word, then open up Excel and paste it into Excel. If you do not use Word first, the report will paste into Excel, but, all the formatting and columns will be lost.

Using other spreadsheets:

This application has not been designed to be used with anything other than Microsoft Office. You may find you can paste reports into other applications as well, but support is not offered for this.