• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Delete Table Rows in Excel

February 9, 2022 by Andrew Childress
How to fill Excel cells

As your table evolves, you'll need to manage how many rows it includes. Let's learn how to delete table rows in Excel in this tutorial.

Data tables in Excel help you to organize important information. Instead of scattering your data throughout the workbook, turning on tables will give you lots of options to work with – like named ranges, easy subtotals and more.

As your table evolves, you’ll need to manage how many rows it includes. Let’s learn how to delete table rows in Excel in this tutorial.

Delete a Table Row in Excel

First, it helps to know if you’re working in an Excel data table. By default, your data in a worksheet isn’t in a table. You’ll need to use the Insert > Table option to convert data into a true table format. You’ll know that you’re working in a data table if you see the Table Tools > Design option on the ribbon when you click inside the table.

Table tools design Excel

For more information on how Excel data tables work, make sure to check out our helpful intro tutorial Table in Excel.

To delete a table row, right click on the row you wish to remove. Then choose Delete > Table Rows. That’s all you have to do!

Delete table row

You’ll watch the table update in realtime with one fewer row. Every other row will consequently move up in the table.

Delete Multiple Table Rows in Excel

Need to remove more than one row from the table? No worries, we’ve got you covered.

In this case, start by highlighting at least two cells in a table. Then, just follow the same instructions with a right-click Delete > Table Rows. Again, this is all it takes to remove rows. You’ll watch the table update with fewer rows and every remaining row will move accordingly.

Delete multiple rows Excel

Remember: your Excel spreadsheet will definitely involve in shape over time. Use the right-click > Delete menu inside of a data table to manage your data efficiently.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « How to use Clear all in Excel Clear All in Excel
Next Post: MIN in Excel Minute formula in Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top