F4 key

Hello Hala

Thank you for your question and welcome to the forum.

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

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

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

Kind regards
Amanda