How to Delete or Remove a Table in Microsoft Excel

You can delete or keep the data inside

After you create a table in Microsoft Excel, you may decide that your spreadsheet looks better without it. You can easily remove tables in Excel.

Here, you’ll find various ways to delete a table in Excel that includes or excludes the data within it.

Delete a Table and Remove the Data

If you want to get rid of both the table and its data, you have a few ways to do so in Excel.

One of the quickest ways to remove a table and its data in Excel is with a simple key press.

You can also use the Clear menu in the ribbon to delete the table and its data.

If you’re using the Excel desktop application on Windows, you can also take advantage of ribbon keyboard shortcuts, referred to as Key Tips by Microsoft. These shortcuts display letter indicators over the tabs and ribbon buttons that let you quickly perform an action with a key press.

To use this method quickly moving forward, simply holdAltand pressH+E+Ato delete your table along with its data.

Delete a Table and Keep the Data

Maybe you want to retain the data in your sheet but simply remove the Excel table structure encasing it. You have two ways to do so.

Because a table is mostly formatting, you can remove it from the data in a few steps.

Another way to remove a table and keep the data in Excel is by converting the table to a normal range of cells.

Delete a Table in the Excel Mobile App

If you use the Excel app on Android or iOS, you can delete a table there as well. Plus, you can choose to remove or keep the data just like in the desktop and web versions of the application. The processes are the same for both platforms.

You’ll see the table and its contents disappear.

Removing Tables in Excel Without Worry

While tables in Excel give you extra features like filtering, formatting, and easy calculations, they aren’t ideal in every worksheet. If you have a table that you want to remove, you can do so while deleting or retaining the data in it.

For more, look at how tocreate and customize a table in Word.

Sandy Writtenhouse is a freelance technology writer and former Project, Department, and Program Manager. She turned her education, job experience, and love of technology into a full-time writing career. With all sorts of gadgets in her home and her hands, she seeks to help others make life easier through technology.Read Sandy’s Full Bio

Welcome to Help Desk Geek- a blog full of tech tips from trusted tech experts. We have thousands of articles and guides to help you troubleshoot any issue. Our articles have been read over 150 million times since we launched in 2008.

HomeAbout UsEditorial StandardsContact UsTerms of Use

Copyright © 2008-2024 Help Desk Geek.com, LLC All Rights Reserved