D
Danielle
Is there such a thing as "F4" a range?
N
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?
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?
C
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
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
J
joeu2004
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
1 becomes $A$1:$D$1, then A$1$1, then$A1:$D1, then A1
1 again. If you need a mix of absolute/relativesyntax (e.g. $A$1
$1), you need to highlight each component and cycleF4 separately -- or simply type what you want.