Skip to Content
Home
Maps
Calendar
Site Index / Search
Directory
  St. Edward's University

Computer Competency Requirement Navigation Bar
Competency Index
Competency Tutorial Index
Competency Glossary
Competency Site Index
Module 5 - Spreadsheets
Lesson 3 - Index Formulas
Section 8 - Absolute Addressing

Absolute addresses do not change during copying. Absolute addresses are specified by preceding the row and column address of the cell reference with a $. For example, $A$1 is an absolute address.

After highlighting a cell reference, you can use the F4 key as a shortcut on a PC to toggle the state of a cell reference through Relative, Absolute, and Mixed.

Type of Addressing
Example
Relative
B1
Absolute
$B$1
Mixed
$B1 or B$1
Module 5 Lesson 3 Section 7
Module 5 Lesson 3 Section 9

 

 
St. Edward's University Logo St. Edward's University
3001 South Congress Avenue
Austin, Texas 78704
512-448-8400
Contact: itccmail@stedwards.edu
Updated: 08/2007
© 2003, St. Edward's University