Search

Types of Ranges in Excel Worksheet

 

A Single Cell Range (current Active Cell)

A Single Cell Range contains only one Cell, which is also the current Active Cell of the worksheet. To select a Single Cell Range, click on the Cell.

An example of Single Cell Range is shown below.

Single Cell Range

 

A Single Range (a single contiguous selection of two or more cells)

A Single Range is single contiguous selection of two or more cells. As you can see from below image, 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.

A Single Range can be selected by left-clicking, dragging and releasing the mouse over the cells in an Excel worksheet. An example of Single Range is shown below.

Single Range

 

Multiple Range (more than one Range in a single Excel worksheet)

Multiple Range means more than one Range in a single Excel worksheet. Note that even though there are many ranges selected in a single Excel worksheet, there can be only one Active Cell. In this case, the Active Cell is the first cell of the last Range selected.

Multiple Ranges can be selected in a single Excel worksheet, by pressing and holding the "Ctrl" key while making the Range selection. An example of Multiple Range is shown below.

Multiple Range

 

 

 

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