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