XL97: F4 Key Does Not Change Cell Formula Reference

The information in this article applies to:

SYMPTOMS

When you try to change a cell reference to absolute, mixed, or relative by using the F4 key, the cell reference may not change.


CAUSE

This problem can occur when you are trying to change the cell reference of an entire row or multiple rows. For example, if you have =SUM(2:2) in cell A1 and try to change the reference using the F4 key, nothing happens.


WORKAROUND

To workaround this problem, you can type the formula with the appropriate references.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

If you want the reference to be relative, use =SUM(2:2) . If you want the reference to be absolute, use =SUM($2:$2). An example of a mixed reference would be =SUM($2:2).


REFERENCES

For more information about absolute and relative references, click the index tab in Microsoft Excel Help, and type the following text:

references (cell), absolute/relative/mixed
and then double-click the selected text to go to the "About cell and range references" topic.

Additional query words: XL97 reference

Keywords : xlformat
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbbug
Technology :


Last Reviewed: October 30, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.