Technology

#How to Remove a Table in Microsoft Excel

“#How to Remove a Table in Microsoft Excel”


Microsoft Excel Logo

Do you no longer need a table in your Microsoft Excel spreadsheet? If so, you can use one of two methods to remove a table from your spreadsheet. We’ll show you how.

Note: Keep in mind that removing a table deletes all your table data.

How to Delete a Table in Excel With a Keyboard Key

To quickly delete a table in your spreadsheet, use a key on your keyboard.

First, launch your spreadsheet with Microsoft Excel. In the spreadsheet, select the entire table which you want to remove.

Select a table in Excel.

While your table is selected, press the Delete key on your keyboard. Excel will remove the selected table from your spreadsheet.

Tip: To quickly restore a deleted table, press Ctrl+Z (Windows) or Command+Z (Mac).

A table removed from Excel.

And that’s it.

You can remove just the blank rows and columns, too, if you want.

How to Remove a Table in Excel With a Menu Option

Another way to delete a table in Excel is to use the built-in “Clear” option.

To use this method, first, open your spreadsheet with Microsoft Excel. In the spreadsheet, select the entire table that you want to delete.

Select a table in Excel.

While your table is selected, in Excel’s ribbon at the top, click the “Home” tab.

Click the "Home" tab in Excel.

In the “Home” tab, from the “Editing” section, select the “Clear” option.

Select "Clear" in the "Home" tab.

In the “Clear” menu, click “Clear All.”

Select "Clear All" from the "Clear" menu.

And that’s it. Your table is now gone from your Excel spreadsheet.


Did you know you can remove specific rows or columns if you don’t want to delete an entire table in Excel?

RELATED: How to Add or Delete Columns and Rows in a Table in Microsoft Excel

If you liked the article, do not forget to share it with your friends. Follow us on Google News too, click on the star and choose us from your favorites.

For forums sites go to Forum.BuradaBiliyorum.Com

If you want to read more like this article, you can visit our Technology category.

Source

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button
Close

Please allow ads on our site

Please consider supporting us by disabling your ad blocker!