F4 Key not working....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

When I hit F4 the absolute value key doesn't work. Any suggestions?
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting for time 1
Joining 2 if functions 2
How to remove the cell reference in a sheet at once 3
F4 not working 4
if statement 2
Formula autofill to cells below – formula arguments are cell areas in different columns 1
absolute reference 2
Repeat Operations 4

Back
Top