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

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


"Danielle" wrote in message ...
| 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




"Danielle" wrote in message
...
Is there such a thing as "F4" a range?

On Nov 28, 1:51 pm, Danielle
wrote:
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, 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.