Search

What is Range in Excel Worksheet and How to form a Range Address

 

A Range is a group of selected Cells in an Excel worksheet. A Range can be rectangular or square in shape. You can select a Range by left-click, drag and release the mouse over the cells you want to select.

You can distinguish the Range in a worksheet by the hi-lighted Cells. You can see from the below image that, the color of one Cell inside the Range is not hi-lighted. This is the Active Cell of the Range. Normally, this is the first cell you clicked while selecting the Range.

For Example; you want to select the Range from Cell address D6 to G12. To select Range from D6 to G12, click and drag from Cell address D6 through Cell address G12 with mouse (or vice versa).

Click and Drag to select Cell Range

A Cell is identified by a Cell address. Similarly, a Range in Excel worksheet is identified by a Range Address. The syntax for forming an Excel Range address is as below.

[Cell address of Top-Left cell in the Range]:[Cell address Bottom-Right Cell in the Range]

Thus the Range address of the Range in above example is is D6:G12.

Excel worksheet Range Address

The selected Range in Excel will be removed if you click on Excel worksheet or press any arrow in keyboard.

 

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
• Examples of Range Addresses in Excel worksheet
• 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