Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL: F4 Key Does Not Change Cell Formula Reference As Expected

XL: F4 Key Does Not Change Cell Formula Reference As Expected

View products that 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 as expected.

↑ Back to the top

Cause

This behavior 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.

↑ Back to the top

Workaround

To work around this issue, type the formula with the appropriate reference or references.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

More information

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

↑ Back to the top

References

For more information about absolute and relative references, click Microsoft Excel Help on the Help menu, type about cell and range references in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top

Keywords: KB212064, kbpending, kbbug, kbarchive, kbnosurvey

↑ Back to the top

Article Info
Article ID : 212064
Revision : 5
Created on : 3/4/2014
Published on : 3/4/2014
Exists online : False
Views : 313