Single cell references

References to single cells are always given in the format columnrow, for example A1, D13, and so on. You can use either upper-case or lower-case letters to create cell references. Even if you have altered the column or row heading format, cell references must still be entered in this standard form.

See Entering cell references for details of how to enter a cell reference: