Join to Our Community
Community Grows With You
Subscription successful!
There was an error, please try again later.

# 09 Points Help You How to Select Multiple Cells in Excel

There are different tricks on how to select multiple cells in Excel? We will explore sequentially in this tutorial.

We can select multiple cells in Excel to perform editing, calculating, and formatting tasks. Selecting a single cell is quite simple: just click the cell. To select a group of cells, called a range, we can use either mouse or keyboard.

# (01) HOW TO SELECT CONTIGUOUS / SEQUENTIAL CELLS IN EXCEL

➢ Method 1: To select sequential cells, select the first cell and hold down the Shift key and then select the last cell we want. All cells in the selected area are highlighted, with the exception of the first cell.

➢ Method 2: Equivalently, select the first cell and continuously press the Shift+Navigation key (⬆, ⬇, ⬅ or ➡).

➢ Method 3: Equivalently, click a cell and drag the mouse over a group of cells to select a sequential area.

➢ Method 4: Equivalently, select the first cell and then press the Ctrl+Shift+Navigation key (⬆, ⬇, ⬅ or ➡) which will select the range of cells till the last nonblank cell in the same column or row as the active cell.

For example,

(i) Select a cell ➪ Then press Ctr+Shift+ ➡ (right arrow) which will select the range of cells till the last nonblank cell in the same row as the active cell.

(ii) Select a cell ➪ Then press Ctr+Shift+ ⬇ (down arrow) which will select the range of cells till the last nonblank cell in the same column as the active cell.

(iii) Select a cell ➪ Then press Ctr+Shift+ ➡ (right arrow) ➪ Then press Ctr+Shift+ ⬇ (down arrow) which will select the entire range of active cells.

■ Note: Notice the black border surrounding the selected area.

We had detail discussed on Excel shortcuts in separate two tutorials, suggested you read these tutorials:

80+ Excel Shortcuts with ALT Key || Best Hotkey of Keyboard Shortcuts

90+ Best Excel CTRL Shortcuts | Useful Keyboard Shortcuts |

# (02) HOW TO SELECT NON ADJACENT CELLS IN EXCEL

To select nonsequential cells, at first select a cell ➪ Then hold down the Ctrl key and click each additional cell we want to select.

# (03) HOW TO SELECT ALL CELLS IN A DATSET / TABLE

Select any cell anywhere in the dataset or table ➪ Apply Excel shortcut Ctrl+A (hold down the Ctrl key and then press A once).

# (04) HOW TO SELECT ALL CELLS IN THE WORKSHEET

We can select all cells in the active worksheet any of the following 2 methods:

(i) Method 1: Click on the ‘Select All button, a small inverted triangle, is located at the left corner between the intersection of column address A and row number 1.

(ii) Method 2: If worksheet with data/table, then press Ctrl+A+A (hold the Ctrl key and press the A key twice). Please keep a note that if the worksheet is blank, then press Ctrl+A (hold the Ctrl key and press the A key once).

(05) HOW TO SELECT ALL CELLS IN A ROW

(i) Method 1: To select a single entire row, click the row number. In the given example, the entire row number 4 has been selected by clicking on it.

(ii) Method 2: Alternatively, select a cell we want to select the row ➪ Press Shift+Spacebar (hold the Shift key and then press Spacebar). In the given example, we want to select row number 4. First, we select any cell from row number 4 and then press Shift+Spacebar. As a result, the entire row number 4 has been selected.

# (06) HOW TO SELECT MULTIPLE ROWS

## (A) Select Contiguous Multiple Rows

(i) Method 1: To select multiple rows, drag across multiple row numbers.

(i) Method 2: Optionally, firstly we select a single row with Shift+Spacebar and then press Ctrl+Shift+ (for downward rows selection) or Ctrl+Shift+⬆ (for upward rows selection).

## (B) Select Non-Adjacent Multiple Rows

If we want to select non-adjacent multiple rows, for example, row number 4, 7, 10 and 12; then follow the below steps:

(i) First select row number 4 by clicking on the row number is located on the left side.

(ii) Hold the Ctrl key and then select row number 7 by clicking on the row number.

(ii) Continue holding the Ctrl key, select row number 10 by clicking on the row number. Similar way we can select row number 12.

(07) HOW TO SELECT ALL CELLS IN A COLUMN

(i) Method 1: To select a single entire column, click a column heading. In the given example, the entire column C has been selected by clicking on it.

(ii) Method 2: Alternatively, select a column with Ctrl+Spacebar (hold the Ctrl key and then press Spacebar). In the given example, we want to select column C. So firstly we select any cell from column C and then press Ctrl+Spacebar. As a result, the entire column C has been selected.

# (08) HOW TO SELECT MULTIPLE COLUMNS

## (A) Select Contiguous Multiple Columns

(i) Method 1: To select multiple columns, drag across multiple column headings.

(i) Method 2: Equivalently, first select a single column with Ctrl+Spacebar and then press Ctrl+Shift+ (for right-side columns selection) or Ctrl+Shift+ (for left-side columns selection).

## (B) Select Non-Adjacent Multiple Columns

If we want to select non-adjacent multiple columns, for example, column C, F and column J; then follow the below steps:

(i) At first, select column C by clicking on the column heading.

(ii) Hold the Ctrl key and then select column F by clicking on the column heading.

(ii) Continue holding the Ctrl key, select column J by clicking on the column heading.

# (09) HOW TO SELECT MULTIPLE CELLS USING NAME BOX

Using Name box, we can easily select a range of cells. Prior to that we should define a specific name to the range.

(i) Select a range then type a specific name to the range in the Name box. For example, select the range B3:B12 and type a name ‘Sales’. In second case, select the range C3:C12 and type name ‘Bonus_date‘. We should not keep blank in between two words, rather put a underscore “_”. Otherwise, an error message appears for inserting a valid name.

(ii) If we select a specific range name from the Name box drop-down list, it selects the specific range. For example, If we click on ‘Sales’ from the Name box drop-down list, it will select the Sales Manager range. Similarly, if we click on ‘Bonus-date’, it will select the Bonus Date range.

Table: Selecting Cells in the Worksheet

Note: Request you to practice the mentioned shortcuts repeatedly for better performance. However, Click any nonselected cell to clear the selection, otherwise move any navigation key (⬆,⬇, ⬅ or ➡) in any direction.

If you would like to improve your academic and professional career as well, then the below courses help you a lot. Instead of Advanced Excel, a number of best courses suggested you through this platform that boosts your confidence and flies your career high.
Advance Excel Forum

## Premium Courses on ed2go

Microsoft Excel 2019/Office 365 Series

Bestseller
4.9/5

Introduction to Database Development (Self-Paced Tutorial)

Bestseller
4.9/5

Advanced Microsoft Excel 2019/Office 365 (Self-Paced Tutorial)

Bestseller
4.9/5

Managing Web Design Projects

Bestseller
4.9/5

Administrative Assistant Applications (Self-Paced Tutorial)

Bestseller
4.9/5

Visual Basic Series

Bestseller
4.9/5

CompTIA&reg; Network+ Certification Prep

High Rated
4.9/5

Microsoft Office Specialist 2016 (MOS) Certification Training

Top Rated
4.7/5

Certified Six Sigma Yellow Belt and Green Belt (Exam Cost Included)

Bestseller
4.9/5

## Premium Courses on Coursera

Data Analysis and Visualization

Bestseller
4.9/5

Excel Fundamentals for Data Analysis

Bestseller
4.9/5

Data Visualization in Excel

Bestseller
4.9/5

Excel Skills for Business

Bestseller
4.9/5

Advanced Data Science with IBM

Bestseller
4.9/5

Applied AI with Deep Learning

Bestseller
4.9/5

Introduction to Spreadsheets and Models

Bestseller
4.9/5

Accounting Analytics

Bestseller
4.9/5

Accounting Data Analytics

Bestseller
4.9/5

## Premium Courses on Udemy

Excel Power Query, Power Pivot, Power Map & DAX Masterclass (Learn Excel Power Query, PowerPivot, DAX, Power View & Power BI Tools. Build Excel Data Analyst Models with Excel 2019)

Bestseller
4.8/5

Beginners to Expert Excel and Excel VBA 38 Hours Mega Course (Learn Excel formulas, Pivot Tables, Excel VBA macros, charts and the basics with our Microsoft Excel 38+ hours tutorial)

Top rated
4.6/5

Microsoft Power BI Masterclass – Expand Excellence (achieve the next Level of Business Intelligence with Microsoft Power BI Desktop. How to master Power BI Desktop)

Top Rated
4.7/5

The Ultimate Excel Programmer Course (Learn Excel VBA from Scratch with Dan Strong, Bestselling Excel Expert with Over 180K Students Worldwide!)

Bestseller
4.8/5

Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (Ace the Excel MO-201 Exam. Learn advanced data analysis & earn the Excel Expert Certification (MS Excel 2019/Office 365)

Bestseller
4.8/5

Excel Charts, Graphs & Data Visualization in Excel (Master 20+ Advanced Dynamic Excel Charts and Create Impressive Excel Graphs & Data Visualization in Microsoft Excel)

High Rated
4.8/5

Master Excel Functions in Office 365 – Excel Dynamic Arrays (Learn to Use Excel’s NEW Functions (FILTER, UNIQUE, SORT, XLOOKUP.) to Dramatically Simplify the Work You Do in Excel.)

High Rated
4.9/5

Excel Essentials for the Real World (Complete Excel Course) [Microsoft Excel Beginner to Professional. Includes Pivot Tables, Power Query, NEW Formulas. (Excel 365, 2019 & 2016)]

Bestseller
4.8/5

Advanced Excel – Top Excel Tips & Formulas (Master Advanced Excel Formulas. Solve Complex Problems. Learn Advanced Excel Skills to Save Time & Impress (Excel 2010)

Bestseller
4.6/5
Join to Our Community
Community Grows With You
Subscription successful!
There was an error, please try again later.

This website uses cookies.