1. Click on the cell where your formula is contained. Examine the formula to see where the reference needs to be changed. In the latest version of Excel you can click on the cell
http://www.ehow.com/how_7414577_changecellrefere...

transport maximum.
http://wiki.answers.com/Q/What_does_TM_mean_in_ref...

1. PLACE all numbers that you update regularly on their own sheet tab. Ad. 2. REFERENCE those numbers using the following methods. TYPE " to start a formula in the cell and navigate
http://www.wikihow.com/UseCellReferences

Enter the number 2 into cell B1. Copy cell B1 Highlight range in column A you wish to be multiplied (e.g. A1:A10) Paste > Paste Special > multiply Delete contents
http://www.quora.com/MicrosoftExcel/HowdoIrefe...
