在Microsoft Excel(Microsoft Excel)中创建表格后,您可能会认为如果没有它,电子表格看起来会更好。您可以轻松删除Excel中的表格。
在这里,您将找到多种方法来删除Excel(Excel)中包含或排除其中数据的
表格。
删除表并删除数据
如果您想删除表格及其数据,可以在Excel中使用几种方法来执行此操作。
使用键盘删除表
在Excel(Excel)中删除表格及其数据的最快方法之一是按简单的按键。
- 通过拖动光标来选择整个表格。

- 然后,按删除(Delete)键,所有内容都会消失。

使用功能区删除表格
您还可以使用功能区中的“清除”菜单来删除表及其数据。
- 选择整个表并转到“主页”(Home)选项卡。
- 打开编辑(Editing)组中的清除菜单。
- (Choose Clear All)选择列表顶部的
全部清除。

(Delete)使用功能区键盘快捷键(Table Using Ribbon Keyboard Shortcuts)删除表格(按键提示(Key Tips))
如果您在Windows(Windows)上使用Excel桌面应用程序,您还可以利用功能区键盘快捷键(keyboard shortcuts)( Microsoft称为“(Microsoft)按键提示”)(Key Tips)。这些快捷方式在选项卡和功能区按钮上显示字母指示符,让您可以通过按键快速执行操作。
- 要查看按键提示(Key Tips),请使用Alt键。然后您将看到如下所示的指示器显示。
- 使用 H 键选择“主页(Home)”选项卡。

- 然后,使用 E 选择“清除”菜单,并使用 A 选择菜单中的
第一项“全部清除”。(Clear All)

要快速使用此方法,只需按住Alt并按 H + E + A 即可删除表及其数据。
由于您目前无法在 macOS 上使用按键提示(Key Tips),因此请查看可用于执行任务的
Mac 上 Excel 的其他键盘快捷键。(keyboard shortcuts for Excel on Mac)
删除表并保留数据
也许您想保留工作表中的数据,但只需删除包围它的Excel表格结构。您有两种方法可以做到这一点。
(Delete)通过清除格式(Format)删除表
由于表格主要是格式化的,因此您可以通过几个步骤将其从数据中删除。
- 选择表并转到“表设计”(Table Design)选项卡。
- 打开“表格样式”(Table Styles)框右下角的“更多”箭头,然后选择“清除”(Clear)。

- 您将看到您的表格消失,留下数据。如果您有表格标题,它们将保留其过滤按钮(箭头)。

- 要删除它们,请转到“主页”(Home)选项卡,打开“排序(Sort)和过滤器”(Filter)下拉菜单,然后取消选择“过滤器”(Filter)按钮。

(Delete)通过将表转换为范围来
删除表
删除表格并将数据保留在Excel中的另一种方法是将表格转换为正常的单元格范围。
- 选择表格,然后转到“表格设计”(Table Design)选项卡,或者右键单击并移至“表格”(Table)。
- 选择转换为范围。

- 在弹出窗口中
选择“是”以确认此操作。(Yes)

- 然后您将只有数据而没有表格。但是,您可能仍然会看到表格格式,例如带状行或列,具体取决于您最初设置表格的方式。

- 要删除表格格式,请转到“主页”(Home)选项卡,打开“清除”(Clear)菜单,然后选择“清除(Clear) 格式”(Formats)。

(Delete)在Excel 移动应用程序中(Excel Mobile App)删除表格
如果您在Android或 iOS 上使用(Android)Excel应用程序,也可以删除其中的表格。另外,您可以选择删除或保留数据,就像在应用程序的桌面版和 Web 版中一样。两个平台的流程相同。
删除表并删除数据
- 选择整个表。您可以通过选择一个单元格然后拖动边框上的圆圈来捕获整个表格来完成此操作。
- 当工具栏出现在表格附近时,使用箭头向右移动并选择“删除表格”(Delete Table)。
您将看到该表及其内容消失。

删除表并保留数据
- 如上所述选择整个表。
- 使用右下角的
箭头 ( Android ) 或三个点 (iPhone) 打开编辑选项。(Android)
- 转到“表格”(Table)选项卡并选择“转换(Convert)为范围”(Range)。
- 要删除任何剩余的格式,请转到“主页”(Home)选项卡并选择Clear > Clear Formats。

轻松(Excel Without Worry)删除 Excel 中的表格
虽然Excel中的表格为您提供了过滤、格式化和(Excel)简单计算等(easy calculations)额外功能,但它们并不适合每个工作表。如果您有要删除的表,可以在删除或保留其中的数据的同时执行此操作。
有关更多信息,请查看如何在 Word 中创建和自定义表格(create and customize a table in Word)。
How to Delete or Remove a Table in Microsoft Excel
After you create a table in Microsoft Excel, you may decide that your spreadsheet looks better withoυt it. You can eаsily 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.
Delete a Table Using the Keyboard
One of the quickest ways to remove a table and its data in Excel is with a simple key press.
- Select the entire table by dragging your cursor through it.

- Then, press your Delete key and everything vanishes.

Delete a Table Using the Ribbon
You can also use the Clear menu in the ribbon to delete the table and its data.
- Select the entire table and go to the Home tab.
- Open the Clear menu in the Editing group.
- Choose Clear All at the top of the list.

Delete a Table Using Ribbon Keyboard Shortcuts (Key Tips)
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 view the Key Tips, use your Alt key. You’ll then see the indicators display as shown below.
- Use the H key to select the Home tab.

- Then, use E to select the Clear menu and A to select the first item, Clear All, in the menu.

To use this method quickly moving forward, simply hold Alt and press H + E + A to delete your table along with its data.
Because you can’t currently use Key Tips on macOS, check out these other keyboard shortcuts for Excel on Mac you can use for tasks.
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.
Delete a Table by Clearing the Format
Because a table is mostly formatting, you can remove it from the data in a few steps.
- Select the table and go to the Table Design tab.
- Open the More arrow on the bottom right of the Table Styles box and choose Clear.

- You’ll see your table vanish leaving the data behind. If you have table headers, those will remain with their filter buttons (arrows).

- To remove these, go to the Home tab, open the Sort & Filter drop-down menu, and deselect the Filter button.

Delete a Table by Converting It to a Range
Another way to remove a table and keep the data in Excel is by converting the table to a normal range of cells.
- Select the table and either go to the Table Design tab or right-click and move to Table.
- Choose Convert to Range.

- Confirm this action by selecting Yes in the pop-up window.

- You’ll then have just your data without the table. However, you may still see the table formatting such as banded rows or columns, depending on how you set up your table initially.

- To remove table formatting, go to the Home tab, open the Clear menu, and choose Clear Formats.

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.
Delete a Table and Remove the Data
- Select the entire table. You can do this by choosing a cell and then dragging the circles on the border to capture the whole table.
- When the toolbar appears near the table, use the arrow to move to the right and choose Delete Table.
You’ll see the table and its contents disappear.

Delete a Table and Keep the Data
- Select the entire table as described above.
- Open the editing options using the arrow (Android) or three dots (iPhone) on the bottom right.
- Go to the Table tab and pick Convert to Range.
- To remove any remaining formatting, go to the Home tab and select Clear > Clear Formats.

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 to create and customize a table in Word.