Can you make a range absolute?

  • Thread starter Thread starter Danielle
  • Start date Start date
Hi Danielle,

Yes.

F4 both the beginning and the ending cell, to get something like

$A$1:$D$500

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Is there such a thing as "F4" a range?
 
Danielle,

Edit your formula, move the cursor to the reference you want to change and
press the [F4] key on your key board. Pressing [F4] will toggle all
Absolute/Relative combinations. For example:

"A1" pressing [F4] will get you --> "$A$1" [F4] --> "A$1"
[F4] --> "$A1" [F4] --> back to "A1"

HTH,

Conan
 
Is there such a thing as "F4" a range?
Click to expand...

If you highlight both components of the range in edit mode, F4 will
cycle through the various absolute and relative syntax on both at the
same time. For example, A1:D1 becomes $A$1:$D$1, then A$1:D$1, then
$A1:$D1, then A1:D1 again. If you need a mix of absolute/relative
syntax (e.g. $A$1:D$1), you need to highlight each component and cycle
F4 separately -- or simply type what you want.
 
Back
Top