how do i make a cell absolute

A

Ardus Petus

A cell is always absolute.
It is the references to a cell that can be relative and/or absolute, I.e the
way Excel increments/decrements parts of the reference when the reference is
copied around.

HTH
 
P

Paul B

Carly, =$A$1,

$A$1 (absolute column and absolute row) $A$1
A$1 (relative column and absolute row) C$1
$A1 (absolute column and relative row) $A3
A1 (relative column and relative row) C3

Look in help under Switch between relative, absolute, and mixed references




--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
S

Saruman

To turn a formula in a cell to an absolute formula, click on the cell, then
click into the formula bar near the top of the menu bars and then press F4.
Every press of F4 afterwards, changes the absolute to Row then Column then
None
 
D

Dave Peterson

Just in case:

=abs(a1)

will return the absolute value of the value in A1.

Yeah, I didn't think so, but just in case that's what you meant...
 
L

Linda H

Thank you a thousand times. I have been trying to remember how to put
absolute references within cells using the keyboard and could not remember.
 
Top