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.
(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
|Shift+Navigation Key (⬆,⬇, ⬅ or ➡)||Extends the selection by one cell in the direction indicated.|
|Ctrl+Shift+Navigation Key (⬆,⬇, ⬅ or ➡)||Extends the selection to the last nonblank cell in the same column or row as the active cell.|
|Ctr+Shit+*||Selects the current region around the active cell.|
|Ctrl+A / Ctrl+Shift+Spacebar||
i) Selects the current region around the active cell and press again to select the entire worksheet.
ii) If the active cell is within a table, selects the table without the head tow and totals row. Further pressing Ctrl+Shift+Spacebar, selects the entire table. Again pressing Ctrl+Shift+Spacebar, selects the entire worksheet.
|Shift+Home||Extends the selection to the beginning of the current row.|
|Ctrl+ Shift+Home||Extends the selection to the beginning of the worksheet.|
|Ctrl+ Shift+End||Extends the selection to the last used cell on the worksheet|
|Ctrl+Spacebar||Selects the entire column(s).|
|Shift+Spacebar||Selects the entire row(s).|
|Shift+Page Down||Extends the selection down one screen.|
|Shift+Page Up||Extends the selection up one screen.|
|Shift+Backspace||Cancels a range selection and selects only the active cell.|
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
Introduction to Database Development (Self-Paced Tutorial)
Advanced Microsoft Excel 2019/Office 365 (Self-Paced Tutorial)
Managing Web Design Projects
Administrative Assistant Applications (Self-Paced Tutorial)
Visual Basic Series
CompTIA® Network+ Certification Prep
Microsoft Office Specialist 2016 (MOS) Certification Training
Certified Six Sigma Yellow Belt and Green Belt (Exam Cost Included)
Premium Courses on Coursera
Data Analysis and Visualization
Excel Fundamentals for Data Analysis
Data Visualization in Excel
Excel Skills for Business
Advanced Data Science with IBM
Applied AI with Deep Learning
Introduction to Spreadsheets and Models
Accounting Data Analytics
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)
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)
Microsoft Power BI Masterclass – Expand Excellence (achieve the next Level of Business Intelligence with Microsoft Power BI Desktop. How to master Power BI Desktop)
The Ultimate Excel Programmer Course (Learn Excel VBA from Scratch with Dan Strong, Bestselling Excel Expert with Over 180K Students Worldwide!)
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)
Excel Charts, Graphs & Data Visualization in Excel (Master 20+ Advanced Dynamic Excel Charts and Create Impressive Excel Graphs & Data Visualization in Microsoft Excel)
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.)
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)]
Advanced Excel – Top Excel Tips & Formulas (Master Advanced Excel Formulas. Solve Complex Problems. Learn Advanced Excel Skills to Save Time & Impress (Excel 2010)
06 Easy Steps How to Insert Delta Symbol in Excel?
How To Use Excel Symbol (Degree Symbol, Check Mark Symbol)
How to Entering and Editing Data in Excel?
14 Points Must on Fingertips: How to Manage Excel Worksheet?
12 Examples || How to Use Excel Go To Special?
07 Points Guided You How to Find And Replace in Excel?
05 Points Should Learn How to Freeze Panes in Excel?
12 Things Guided You How to Manage An Excel Workbook
03 Useful Methods : Add Numbers With AutoSum Excel
04 Simple to Advanced Methods: How to Filter in Excel?