### Articles related to cell references

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

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.comImproving the Formula: Using

**Cell References**. While the formula on the previous page works, it has one major drawback - If you need to change the data used ...http://spreadsheets.about.com/od/excelformulas/ss/formula_begin_3.htm

The

**cell**reference - Spreadsheets - About.comEntering 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

Absolute

**Cell**Reference - Excel/ Spreadsheet DefinitionDefinition: In 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 ...http://spreadsheets.about.com/od/r/g/absolute_cell_r.htm

Relative

**Cell**Reference - Definition in SpreadsheetsDefinition: In 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 ...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

**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

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

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

**cell**reference. ... a formula has been moved or copied to another**cell**and the**cell references**are incorrect.http://spreadsheets.about.com/od/formulatips/qt/REF_error.htm

What Are Relative and Absolute

**Cell References**VideoRelative and absolute

**cell references**are formulas found in Excel. A relative formula has data moving along while the absolute locks information in place.http://video.about.com/spreadsheets/What-Are-Relative-and-Absolute-Cell-References.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