F4 does not work in Excel

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

Guest

In Excel, if I am typing a formula and for example let's say I want C4 to be
an absolute reference. The F4 key is suppose to change a plain C4 into $C$4.
My F4 key works fine at work but not at home? Work is Excel 2000 and home
is Excel 2002. Is there a patch, or is it something in Tools/Options?
 
Are you sure you're editting the formula--not just selecting the cell?
 
Heather

The cell reference(s) must be highlighted in the formula bar before F4 will
cycle through the options.

If doing that, maybe your keyboard has an F-Lock feature that needs to be
toggled? Do the the other Function keys work properly?

Gord Dibben Excel MVP
 
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

If AND/OR funciton with multiple criteria 2
Learning arrays. 13
Not Calculating 14
what's the function to use absolute value in excel for a macbook? 1
Calculation to subtract TimeValue from Now() Value 1
Alt+F4 1
F4 key when pressed does chg. cell to Absolute 1
F4 key does not toggle relative/absolute cell references. 2

Back
Top