Report Writer - Edit Menu

The Edit menu in the Report Writer contains most of the standard Windows® editing options.

Undo (Ctrl+Z)

This option returns you to a state prior to the last action in the Report Writer grid. You can use this command to roll back up to 10 unsaved changes.

The Undo option and the corresponding Undo speed button appear as unavailable if you cannot reverse the last action.

Redo (Ctrl+Y)

This option recovers up to 10 actions that you previously undid.

The Redo option and the corresponding Redo speed button appear as unavailable if you saved the report since your last action or if you cannot recover the last action.

Cut (Ctrl+X)

This option lets you relocate selected cells to another place in the report.

1. Select the cell or a range of cells to move.
2. Select Cut either from the Edit menu or the right-click menu to copy the cells to the clipboard.
3. Select Paste to move the data to the new location.

After you paste the data to its new location, the data is removed from the original location and placed in the new cells.

You can also use the Cut speed button for this purpose.

Copy (Ctrl+C)

This option lets you copy the selected data to the clipboard. The original data is unaffected. You can either paste the data on the clipboard back into the Report Writer or into another application.

You can also use the Copy speed button for this purpose.

Paste (Ctrl+V)

This option places the copied information from the clipboard into the active cell. If you save a range of cells to the clipboard, then the active cell acts as the upper-left anchor for the copied range of cells. You can paste data copied from the Report Writer, as well as data from other applications, into the grid.

You can also use the Paste speed button for this purpose.

Clear

This option lets you reset some or all the parameters in a cell. After selecting this option, additional options appear:

• Selecting All removes the formatting and formula in the cell.
• Selecting Formats resets all format parameters to the default settings.
• Selecting Contents deletes only the formulas or values in the cells while maintaining the format.

Delete

This option removes a cell, row, or column from the report.

Find

This option opens the Find dialog box, which provides several options for searching the current report for alpha or numeric values. You can search by columns or rows and by the values that appear in the cells or in the formulas used to calculate the results.

Replace

This option is similar to the Find option and lets you search for a specified alpha or numeric value. It also allows you to change it to a Replace With value.

Text

This option opens an Enter Text Here dialog box that allows you to enter text. The box opens to a size that corresponds to the cell that you selected prior to selecting the option. You can drag the sides of the box to make it bigger.

If the cell already contains text or a formula, then it appears in the text box. Enter the text that you want to insert into the cell or paste it in from another source. Select the Wrap Text check box to ensure that all your text is visible in the report. Use the Enter key to move down a line. Select OK to add the new or revised text to your report.

After you select the Wrap Text check box, you can also adjust the column width or row height to make your added text appear the way that you want it to.

Calculate Now (F9)

This option forces all formulas in the report to recalculate.