Right-clicking in the worksheet

The worksheet in the Financial Statement Designer is a spreadsheet of cells arranged in a 500-row by 500-column grid. You can perform common spreadsheet tasks, such as the following:

To do this

Right-click this

Cut a selection from the worksheet and place it on the clipboard

A cell, row, or column and click Cut.

Copy a selection from the worksheet and place it on the clipboard

A cell, row, or column and click Copy.

Paste information from the clipboard into selected cells in the worksheet

A cell, row, or column and click Paste.

Insert a row

One of the following:

  • A row and click Insert.
  • A cell and click Insert > Row.

Delete a row

One of the following:

  • A row and click Delete.
  • A cell and click Delete > Row.

Hide a row

A row and click Hide.

The hidden row is shaded to indicate that it does not appear in the preview or print on the statement.

Unhide a row

A shaded row and click Unhide.

The shown row is unshaded.

Insert a column

One of the following:

  • A column and click Insert.
  • A cell and click Insert > Column.

Delete a column

One of the following:

  • A column and click Delete.
  • A cell and click Delete > Column.

Hide a column

A column and click Hide.

The hidden column is shaded to indicate that it does not appear in the preview or print on the statement.

Unhide a column

A shaded column and click Unhide.

The shown column is unshaded.

Apply a border to a cell, row, or column

A cell, row, or column and click Borders.

Remove the contents of a cell

A cell and click Clear Contents.