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

How to insert and delete rows in Excel

Transcript 

In this lesson, we'll look at how to insert and delete rows in Excel. It's common to insert rows to make room for more information. Deleting rows is an easy way to remove information you no longer want or need.

No matter how many rows you add or delete, the number of rows in the worksheet never changes. When you insert rows, rows are pushed off the worksheet at the bottom. When you delete rows, new rows are added to the bottom.

Let's take a look.

To insert a row in Excel, first select the row below where you want the new row to be.

Then, click the Insert button on the ribbon.

Excel will always insert rows above your selection.

You can also right-click and choose Insert from the menu, which is generally faster.

If you'd like to insert multiple rows, just select more than one row before you insert. Excel will insert as many rows as you have selected.

To delete a row in Excel, first select the row you'd like to delete.

You can then delete the row using the ribbon or by right-clicking. To use the ribbon, click the Delete button.

To use your mouse, right-click and choose Delete from the menu.

You can delete multiple rows in the same way.

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