Budget Worksheet Right-Click Menu
The following menu items are available when you right-click on the budget worksheet.
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 (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. |