| To refer to |
Use |
| The cell in column A and row
10 |
A10 |
| The range of cells in column
A and rows 10 through 20. |
A10:A20 |
| The range of cells in row 15
and columns B through E |
B15:E15 |
| All cells in row 5 |
5:5 |
| All cells in rows 5 through
10 |
5:10 |
| All cells in column H |
H:H |
| All cells in column H
through J |
H:J |
