### Articles related to cell references

**Cell Reference**Definition (Excel Spreadsheets)

What are

**Cell References**? and How are they Used in Excel and Google Spreadsheets. By Ted ... Related Tutorial: Using**Cell References**in Excel Formulas.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 DefinitionIn Excel and Google Spreadsheets, an absolute

**cell reference**, like other**cell****references**, identifies the location a cell or group of cells and are used in such ...http://spreadsheets.about.com/od/r/g/absolute_cell_r.htm

Relative

**Cell Reference**- Definition in SpreadsheetsIn Excel and other spreadsheets, a relative

**cell reference**identifies the location of a cell or group of cells.**Cell references**are used in a variety of features such as ...http://spreadsheets.about.com/od/r/g/rel_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

7 DOs and DON'Ts of Entering Data in Excel

Entering data DOs and DON'Ts covers the dangers of blank rows and columns,
and why locking formulas, sorting, saving, and

**cell references**are good in Excel.http://spreadsheets.about.com/od/excel101/ss/enter_data_4.htm

**Cell References**in Excel Video

**Cell references**are the foundation for performing powerful calculations in Microsoft Excel. Learn the difference between relative and absolute references before ...

http://video.about.com/spreadsheets/Relative-and-Absolute-References-in-Excel.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

Entering the Lookup Value Argument using Absolute

**Cell References**Nov 24, 2012

**...**Absolute**cell references**are created by pressing the F4 key on the keyboard. Doing so adds dollar signs around the**cell reference**such as $D ...http://spreadsheets.about.com/od/tipsandfaqs/ss/2012-11-24-excel-vlookup-multiple-fields_5.htm