# How to Select Cells in Excel Without Dragging (7 Ideal Examples)

We’ll use the following dataset as an example. We’ll show how to select multiple cells across the table.

### Method 1 – Select Contiguous Cells in Excel Without Dragging

#### Case 1.1 – Use the Mouse and Shift Key

STEPS:

• Select cell B4.

• Press and hold the Shift key and click cell B8.
• This will select the range B4:B8.

#### Case 1.2 – Apply Keyboard Shortcut

STEPS:

• Click cell C4.
• Press Shift + Right Arrow.
• Press the Down Arrow cursor while holding Shift.

• The following marked range in the figure below will be selected.

#### Case 1.3 – Use the Name Box

STEPS:

• Go to the Name Box.
• Type B4:D7 in the box.
• Press Enter.
• This selects the indicated range.

### Method 2 – Non-Contiguous Cells Selection in Excel

STEPS:

• Press down the Ctrl key.
• Click the cells you want to select. We selected the cells B4, B10, C7, C10, and D4.

STEPS:

STEPS:

### Method 5 – Select All Cells in the Table Without Dragging

STEPS:

• Click any cell inside the cell.
• Press Ctrl + A.

### Method 6 – Entire Worksheet Selection in Excel

STEPS:

• Click the left-most corner area in a worksheet.

### Method 7 – Choose Cells in Excel with a Named Range

STEPS:

• We have Table1 representing the range B4:D6.
• Go to the Name Box.
• Click Table1 from the available options.
• It’ll select the required range.

## Related Article

<< Go Back to Select Cells | Excel Cells | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Aung Shine

Aung Shine completed his bachelor’s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF