How to Select Range in Excel: Simple Steps and Examples

To select a range in Excel, click and drag your mouse over the cells you want or use the keyboard by clicking the first cell, holding Shift, and clicking the last cell. You can also type a range like A1:C5 in the Name Box to select it instantly.

Syntax

In Excel, a range is written as StartCell:EndCell. For example, A1:C3 means all cells from column A row 1 to column C row 3.

• StartCell: The top-left cell of the range.
• EndCell: The bottom-right cell of the range.
• Colon (:): Separates the start and end cells to define the range.

excel

A1:C3

Output

Selects all cells from A1 to C3 (3 columns and 3 rows)

Example

This example shows how to select a range using the Name Box and keyboard shortcuts.

excel

1. Click the Name Box (top-left corner above column A).
2. Type A1:C3 and press Enter.
3. Excel highlights cells from A1 to C3.

Alternatively:
1. Click cell A1.
2. Hold the Shift key.
3. Click cell C3.
4. The range A1:C3 is selected.

Output

Cells A1, A2, A3, B1, B2, B3, C1, C2, C3 are selected (highlighted)

Common Pitfalls

Common mistakes when selecting ranges include:

• Not holding Shift when clicking the last cell, which selects only one cell.
• Typing an incorrect range like A1-C3 (using a dash instead of a colon).
• Trying to select non-adjacent cells by dragging, which only selects a continuous block.

To select multiple non-adjacent cells or ranges, hold Ctrl (Windows) or Cmd (Mac) while clicking.

excel

Wrong: A1-C3
Right: A1:C3

Quick Reference

Action	How to Select
Select continuous range with mouse	Click and drag over cells
Select continuous range with keyboard	Click first cell, hold Shift, click last cell
Select range using Name Box	Type range (e.g., A1:C5) in Name Box and press Enter
Select entire row	Click row number on left
Select entire column	Click column letter on top
Select multiple non-adjacent cells	Hold Ctrl (Cmd on Mac) and click cells

Key Takeaways

Use StartCell:EndCell format to define ranges in Excel.

Hold Shift and click to select a continuous range with keyboard.

Use the Name Box to quickly select any range by typing it.

Hold Ctrl (or Cmd) to select multiple non-adjacent cells.

Avoid using incorrect symbols like dash (-) instead of colon (:) in ranges.