Budget Worksheet Right-Click Menu

The following menu items are available when you right-click on the budget worksheet. If available, click a menu name for more information about its form or process.

Format Cells

Enable a form to change the font, color, border, alignment, and format of a cell.

Sort Ascending

Sort data in an ascending order on a selected column.

Sort Descending

Sort data in a descending order on a selected column.

Cut

Cut data from the worksheet.

Copy

Copy data from a single cell or a range of cells in the worksheet.

Paste

Paste data from a single cell or a range of cells in the worksheet to a single cell or a range of cells. If you attempt to paste into a range of cells that contains read-only cells (such as Titles and Total Columns), Paste applies only to the budget entry cells.

Insert

Enable a form to insert rows or columns. This feature is only available in columns without headings.

Delete

Enable a form to delete rows or columns. This feature is only available in columns without headings.

Undo Last Action

Undo the last action performed.

Redo Last Action

Redo the last action performed.

Refresh Rows

Update the segment titles, comparative data, and totals columns (read-only cells) in the selected Budget Item rows. The selected rows will be validated prior to the update.

Validate Rows

Validate a selected row or set of rows.

Modify Selected Items

Modify selected (highlighted) items on the budget worksheet. Available on cells, rows, or columns located between the "Titles" and "Totals." Modifications are not available in read-only cells.

Budget Items

Place a "B" in Column A of the worksheet. If Column A already has a value of "B," no change is made.

Comment Lines

Remove the "B" in Column A of the worksheet. If Column A is blank, no change is made. Note: These rows will not be validated or transferred, but they will be saved when the worksheet is transferred.