Examples of Range Addresses in Excel worksheet
Similar to Cell addresses, there are addresses for Ranges in Excel worksheet. Range addresses are used to identify the Range in Excel worksheet.
Following are some examples of Range Addresses.
Range Addresss | Description |
---|---|
B12 | A single cell Range |
D6:G12 | Range starting from D6 (Top-Left cell) and ending in G12 (Bottom-Right cell). |
A1:A1048576 | Range containing the entire A column. |
A:A | Range containing the entire A column. |
X1:X1048576 | Range containing the entire X column. |
X:X | Range containing the entire X column. |
A3:XFD3 | Range containing the entire 3rd row. |
3:3 | Range containing the entire 3rd row. |
A1:XFD1048576 | Range containing entire worksheet (all cells are included) |
A:XFD | Range containing entire worksheet (all cells are included) |
1:1048576 | Range containing entire worksheet (all cells are included) |
A:D | Entire first four columns (from A to D) |
D:H | Entire columns from D to H |
6:10 | Entire rows from row number 6 to 10 |