Tuesday, May 27, 2014

F4 Magic in MS-Excel

F4 Magic:

The F4 key provides a shortcut for creating absolute or mixed references in a formula.

Once you have selected a cell to enter it into a formula:

- Press F4 key once to create an absolute reference, e.g. $A$8. This 'locks' or 'fixes' the cell into the formula so that the reference to this cell doesn't change when the formula is copied to other cells in the spreadsheet.

- Press F4 twice to create a mixed reference which locks Excel onto a particular row, e.g. A$8

- Press F4 three times to create a mixed reference with locks onto a particular column, e.g. $A8

- Press F4 again make the cell a relative reference again !!

Try it out....

No comments:

Post a Comment