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 › Shortcuts for selecting cells in Excel

Shortcuts for selecting cells in Excel

Transcript 

Excel has many useful shortcuts for selecting cells. This includes shortcuts for selecting rows, columns, groups of cells, and even the entire worksheet.

Let's take a look.

When you're selecting individual cells, you can use the arrow keys to move the selection around.

If you hold down the shift key and then press an arrow key, you can extend this selection in any direction without using the mouse.

To select an entire column, press control + spacebar. Once you have the column selected, you can press shift and extend the selection to the right or the left using the arrow keys.

To select an entire row, press shift + spacebar. As with columns, you can then hold the shift key down and use the arrow keys to extend the selection.

When you are inside a group of cells, control + A will select the entire group. If you type control-A again, you'll select the entire worksheet.

If you want to select a row inside a group of cells, select the first cell, then hold down the shift key and the control key and press an arrow key. Excel will extend the selection to the first empty cell.

This works for columns as well. Select a cell, then, holding down both the control key and the shift key, press an arrow key in the direction you would like to select.

Keeping the shift and control key held down, you can type an arrow key to select the remaining cells in the group.

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
Just wanted to say "Thank you" and I feel lucky I found your website! I work with contracts and your link lead me to a concise answer. No other link came close.
Karen
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