Small Business Resources, Business Advice and Forms from AllBusiness.com

Business Glossary

Search the Business Glossary:

Business Definition for: absolute address

absolute address

  1. a fixed location in the computer's memory. See computer architecture ; offset .
  2. in a spreadsheet program, a cell address that refers to a fixed location that will not change when a formula is copied to another location. In Lotus 1-2-3 and Excel, absolute addresses are indicated by placing a dollar sign before the column and row indicator. For example, if the formula 2*$D$7 is entered into a cell, then $D$7 is an absolute address. If this formula is copied to another cell, the address $D$7 will not change. Contrast relative address .

Copyright © 2006, 2003, 2000, 1998, 1996, 1995, 1992, 1989, 1986 by Barron's Educational Series, Inc. Reprinted by arrangement with Publisher.