Can you make a range absolute?

[Danielle]

Is there such a thing as "F4" a range?

 

[Niek Otten]

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?

 

[Conan Kelly]

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

 

[joeu2004]

Is there such a thing as "F4" a range?

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, A11 becomes $A$1:$D$1, then A$1$1, then
$A1:$D1, then A11 again. If you need a mix of absolute/relative
syntax (e.g. $A$1$1), you need to highlight each component and cycle
F4 separately -- or simply type what you want.