Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to select cells in Excel

How to select cells in Excel

Transcript 

In this lesson, we're going to take a look at the first step in doing almost anything in Excel—selecting one or more cells. Excel will let you select one cell, a range of cells, or any combination of single and multiple cells.

Let's take a look.

The first thing to understand about selecting cells is that there is always at least one cell already selected in the worksheet. To see what is currently selected, check the name box. The name box will display a reference to the current selection.

To select one cell in Excel, just click anywhere in the worksheet.

Notice that the address shown in the name box is continuously updated.

To select more than one cell, click a cell in the worksheet, hold your mouse down, and drag to expand the selection.

If you watch the name box, you'll see the number of rows and columns currently selected. This will change dynamically as you expand or reduce the selection.

When you let go of your mouse, the name window will display the address of the active cell in the selection.  The active cell is always highlighted.

What if you want to select cells that aren't next to one another? For that, we need to use a modifier key to tell Excel to add to our selection.

Make the first selection normally. Then, while holding down the control key, make your next selection. You can add as many selections as you like.

With multiple selections, notice that the name box will display the address of the active cell which will be highlighted in the last selection made.

Why would you want to make multiple selections? The most common reason is to change the formatting in more than one cell at a time. We'll look at how to do this in a future lesson.

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
Holy cow thank you Dave, your article "VLOOKUP with numbers and text" saved my butt. Many appreciations and happy friday!
Cameron
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page