To enter a reference to an entire row or column, type the row number or column letter twice, separated by a colon (for example, ...