### Articles related to cell references

**Cell Reference**Definition (Excel Spreadsheets)

Related Tutorial: Using

**Cell References**in Excel Formulas. In Excel, a**cell****reference**identifies the location a cell or group of cells in the worksheet. Sometimes ...http://spreadsheets.about.com/od/c/g/cell_ref_def.htm

Using

**Cell References**in Excel Formulas - Spreadsheets - About.comThis step in the tutorial using

**cell references**in Excel formulas.http://spreadsheets.about.com/od/excelformulas/ss/formula_begin_3.htm

Absolute

**Cell Reference**- Excel/ Spreadsheet DefinitionDefinition of the term Absolute

**Cell Reference**in Excel and other spreadsheets.http://spreadsheets.about.com/od/r/g/absolute_cell_r.htm

**Cell References**in Excel Spreadsheets - About.com

Excel

**cell references**are explained in this example. Also covered is how to use**cell references**in Excel formulas and functions.http://spreadsheets.about.com/od/excel101/ss/enter_data_4.htm

Relative

**Cell Reference**- Definition in SpreadsheetsBy default, a spreadsheet

**cell reference**is relative. What this means is that as a formula or function is copied and pasted to other cells, the**cell references**in the ...http://spreadsheets.about.com/od/r/g/rel_cell_ref.htm

Using

**Cell References**in Excel Formulas - Spreadsheets - About.com**Cell references**describe the location of a cell in an Excel spreadsheet. These

**cell**

**references**can be used in formulas. Excel will calculate the answer for the ...

http://spreadsheets.about.com/od/exceltips/qt/cell_ref.htm

Excel Mixed

**Cell Reference**Definition - Spreadsheets - About.comBy default, a spreadsheet

**cell reference**is relative. What this means is that as a formula or function is copied and pasted to other cells, the**cell references**in the ...http://spreadsheets.about.com/od/m/g/090422_mixed_cell_reference.htm

Using Pointing to Enter

**Cell References**into an Excel FormulaThis step in the tutorial uses the mouse pointer to enter the

**cell references**for the formula into cell D2. Click on cell D2 to make it the active cell; Type the equal ...http://spreadsheets.about.com/od/excelformulas/ss/formula_begin_5.htm

#REF! Excel Error Message - Tips & Solutions - Spreadsheets

A #REF! error message in Excel refers to an invalid

**cell reference**. Read the article to find the causes and cures for this common problem.http://spreadsheets.about.com/od/formulatips/qt/REF_error.htm

Excel SUM - INDIRECT Dynamic Range Formula - Spreadsheets

Aug 7, 2013

**...**Excel's INDIRECT function makes it easy to create a dynamic range of**cell****references**in formulas without having to edit the formula itself.http://spreadsheets.about.com/od/tipsandfaqs/ss/2013-08-07-excel-sum-indirect-dynamic-range-formula.htm