Why are F2 and F4 keys not working?

  • Thread starter Thread starter ModelerGirl
  • Start date Start date
M

ModelerGirl

I've been trying to use the F2 key (to modify the formula in a cell) and
the F4 key (to change a reference to absolute), but neither one is
working. They had been working before, I think.

Is there something I need to do in order to turn them back on?

Thanks,

R
 
The F2 stuff:

First, are you sure F2 isn't working? If you hit F2, do you see the I-Bar
cursor at the far right in the formula bar? (If you edit in the formula bar)

Or is it at the far right in the cell (if you edit directly in the cell).

(Tools|options|Edit tab is where you can set this.)

If no to both of these, you can try resetting the F2 key by:
hitting alt-f11 to get to the VBE (where macros live)
hitting ctrl-G to see the immediate window
type this in and hit enter:
Application.OnKey "{F2}"

test it out.

The F4 stuff is more difficult. It can't be "stolen" by a helpful
developer--well, it can't be stolen when you're editing a cell.

Are you sure that cell contained a formula?
a1+a2
wouldn't react to the F4 button, but
=a1+a2
did.
 

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

F2 Key not working in Excel 2007 1
Absolute reference (F4 Key) not working 5
Alt-F4 won't close window and F2 won't rename 1
Excel F2 & MS Media Keyboard 3
The F4 key 5
SUMPRODUCT not working? 1
Change relative to absolute references in a block of cells 3
Trying to set up a cross reference chart, best way to copy formulas? 2

Back
Top