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 rows and columns in Excel

How to select rows and columns in Excel

Transcript 

In this lesson, we'll look at how to select entire rows and columns. 

Selecting columns and rows is handy when you want to move information around, delete information, or when you want to copy a row or column.

Let's take a look.

To select a column in Excel, just click the letter in the column heading.

You'll see Excel immediately select the entire column.

If you want to select more than one column, and the columns are together, just click a column letter and drag to expand your selection.

If you want to select more than one column, and the columns are not next to one another, hold down the control key before you click. By holding down the control key, you can add as many columns to your selection as you like.

Rows work the same way as columns. To select a row, click the row number.

Like columns, you can click and drag to select more than one row at a time as long as the rows are together.

You can also hold down the control key to add rows that are not together to your selection.

Using the control key, you can even select a combination of rows and columns.

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