TUG Tip of the Week - October 19, 2016

Spreadsheet Tip – Adjust Columns

You can adjust columns on the spreadsheet by any of the following methods: A percentage, multiplying by an amount, dividing by an amount, replacing amounts, adding or subtracting an amount, or spreading an amount proportionally over the items.  

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 Column.  

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).