Spreadsheet Tip - Adjust Columns

TUG Tip -- Estimating

Spreadsheet Tip - Adjust Columns

You can adjust columns on the spreadsheet by any of the following Adjustment Types: Percent, Multiply, Divide, Replace, Add or Spread. To adjust the columns, use one of these techniques:

1) Drag the mouse

2) Use CTRL + click and SHIFT + click

3) Right-click and select Adjust…

Tip: The tool tip shows both the accumulated adjustments and the original amount. You can select an item and then select Adjust Column. Select Undo Adjustment to return the item to the original amount. Select Finalize Adjustment to make the adjusted amount permanent. (You cannot undo a finalized adjustment).