Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Absolute referencing

excel training courses - Absolute referencing

ResolvedVersion Standard

Wed 29 Nov 2006, 16:39 Delegate Kate said...

Kate has attended:
Excel Introduction course

Absolute referencing

Is it safest to always put in the dollar signs before every column and row reference or can that sometimes goes wrong?

Wed 29 Nov 2006, 22:14 Trainer Amanda said...

RE: Absolute referencing

Hi Kate

Thanks for your question.

You do not need to make every cell in a formula into an absolute reference (the name for a cell that has $ before the column letter and row number), you only need to do this when you need a specific cell in your formula to remain constant/the same in order to get the correct formula result.

Most of the time leaving your formula how it is without making an cells into an absolute reference works fine.

Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

How to select certain data in an Excel 2010 workbook

If you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique.

For example: If you want to select all data in cells A2 to E10, then click on cell A2, hold down the Shift key and click on cell E10 and all the data you want to see is highlighted.

Keep holding down the Shift key and you can move from cell E10 to any other cell in the spreadsheet.

View all Excel hints and tips

excel training courses - Absolute referencing

Absolute referencing

RE: Absolute referencing

Excel articles

Excel tip:

How to select certain data in an Excel 2010 workbook