Monday 10 September 2012

Cell Reference Examples

A1 is Cell in column A and row 1
A1:A10 is the Range of cells in column A and rows 1 through 10
A1:F1 is the Range of cells in row 1 and columns A through F
1:1 is the All cells in row 1
1:5 is All cells in rows 5 through 10
A:A is All cells in column A
A:F is All cells in columns A through F
Summary!A1:A10 is the Range of cells in column A and rows 1
through 10 in worksheet named Summary

No comments:

Post a Comment