F4 Key not working....

[Calvin]

Hi,

When I hit F4 the absolute value key doesn't work. Any suggestions?
--
Calvin

[Michael]

Hi Calvin
The F4 key is not something that can be turned on / off by mistake.
Are you sure you are working on a formula ??
If you type in say, A1+A2, F4 won't work unless there is an = sign in front
of it.
HTH
Michael Mitchelson


"Calvin" wrote:

> Hi,
>
> When I hit F4 the absolute value key doesn't work. Any suggestions?
> --
> Calvin

[Niek Otten]

The cursor has to be on or directly near the address to have F4 take effect

BTW do you have a keyboard which requires F Lock to be switched on to
activate the function keys?

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Michael" <[email protected]> wrote in message
news:[email protected]...
> Hi Calvin
> The F4 key is not something that can be turned on / off by mistake.
> Are you sure you are working on a formula ??
> If you type in say, A1+A2, F4 won't work unless there is an = sign in
> front
> of it.
> HTH
> Michael Mitchelson
>
>
> "Calvin" wrote:
>
>> Hi,
>>
>> When I hit F4 the absolute value key doesn't work. Any suggestions?
>> --
>> Calvin