Search

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 AddresssDescription
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:XFDRange 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

 

Related Tutorials
• Important Excel Worksheet Navigation keys
• Excel Cursor and Mouse Pointer Shapes
• Row, Column and Cell in Excel worksheet
• How to change the Row height in Excel worksheet
• Excel AutoFit Row Height
• How to change the Column width in Excel worksheet
• Excel AutoFit Column Width
• How to hide or unhide Rows in Excel worksheet
• How to hide or unhide Columns in Excel worksheet
• Maximum rows and columns in Excel Worksheet
• What is Active Cell in Excel and How to identify Active Cell
• What is Range in Excel Worksheet and How to form a Range Address
• Types of Ranges in Excel Worksheet
• How to select Range in Excel worksheet
• How to select Multiple Range in Excel worksheet
• What is Group mode in Excel, How to exit Group edit mode
• How to select all worksheets to Excel group
• How to select Ranges from different worksheets using Excel Group edit mode
• How to hide or show Excel Worksheet Row and Column headings (Column Letter and Row Number)
• How to hide or show Excel Worksheet Gridlines
• How to change the color of Excel worksheet Tabs
• How to change the color of Excel Gridlines
• How to change the default font and size in Excel
• How to Move or Copy entire worksheet within an Excel workbook
• How to Move or Copy entire worksheet to another Excel workbook