OpenOffice.org video based manual
Plan-B for OpenOffice.org, learning office productivity software with videos


Tech Support for OpenOffice.org
Applications
Go to Open Office Writer Index
Go to Open Office Impress Index
Go to Open Office Math Index
Go to Open Office Draw Index
Go to Open Office Calc Index
Go to Open Office Base Index
Go to Open Office Online Help Index

Name Cell Reference

A name cell reference is an that has been given a customized name. This kind of does not change when copied unto other cells, unlike Also, unlike relative and absolute cell references, descriptive text can be used as its form unlike the column letter and row number format (A1, B2) which are usually used.

These named cell references are used primarilly to easily identify a cell with a value that is often used in the formula of the spreadsheet. This would typically represent a constant value like the rate of increase/decrease of the data being calculated.

OpenOffice Calc has features that let you define, insert and change these references to fit specific tasks.

Using Name References

The following screencasts demonstrate how to use name references:

OpenOffice.org™ is a trademark of OpenOffice.org.

Get OpenOffice.org - Free!