How to delete table format in Excel

Complete data tables on Excel are often formatted to help users manage scientific data more. We can select many different tables, many different colors for data areas, content in spreadsheets. This just shows the professionalism of the workers, while creating the liveliness of the spreadsheet. But in case we want to use another type of table, or want to return the table to a normal data area, we can delete the format in the Excel table. The following article will guide you how to delete table format in Excel.

  1. A guide to the full Excel 2016 (Part 12): Page formatting and spreadsheet printing
  2. Guide to full Excel 2016 (Part 7): Format spreadsheet data
  3. How to format dates in Excel

1. Delete the table format for normal data areas

This way will help users delete the table and still keep the content in the table.

Step 1:

At the table you want to delete the format we select any cell in the table or select the whole table, right-click and select Table , choose to continue Convert to Range .

How to delete table format in Excel Picture 1

Step 2:

Notice box Do you want to convert the table to a normal range? Ask the user if he wants to convert the table into a normal data area, click Yes to agree.

How to delete table format in Excel Picture 2

The result of the data table will be transferred to the normal data area, no longer formatted in the Excel table.

How to delete table format in Excel Picture 3

2. Delete table style (Table Style) in Excel

In case you still want to keep the table format but want to delete the designed table type, we can do the following.

Method 1: Use the Clear feature in Table Style

Step 1:

In the data table, click the Design tab, and then look down at the Table Styles section, select the More icon .

How to delete table format in Excel Picture 4

Step 2:

In the list we click on the Clear button to delete the table type applied on the data table.

How to delete table format in Excel Picture 5

Immediately the table type has been deleted but the table format remains the same. Table or board colors will completely disappear.

How to delete table format in Excel Picture 6

Method 2: Use Clear Format tool

This way is much faster and suitable when you delete the table type of multiple tables in an Excel file. Select all the tables to delete the table type and select the Home tab , select the Clear section and select Clear Format . Now the whole table style will disappear.

How to delete table format in Excel Picture 7

With the above article the user has many ways to delete the Excel table format, delete the format to retain the table style or delete the table type and retain the table format. Depending on the need to delete the Excel table format you choose to delete accordingly.

See more:

  1. How to convert Excel file to Google Sheets
  2. Word 2013 Complete Guide (Part 16): Image format
  3. Quick formatting of words appears many times on Word

I wish you all success!

5 ★ | 2 Vote

May be interested

  • How to draw a table in ExcelHow to draw a table in Excel
    how to draw a table in excel. excel spreadsheets are great tools for calculating numbers. in this article, you can help excel table guys as quickly as possible.
  • How to create and delete tables in ExcelHow to create and delete tables in Excel
    how to create and delete tables in excel. excel is a great tool for calculating, it supports many calculation functions, logical functions ... but for the numbers to be presented scientifically and beautifully you need to create tables for data. this article helps you to create and delete tables in the table
  • Instructions on 2 simple ways to delete conditional rows in ExcelInstructions on 2 simple ways to delete conditional rows in Excel
    if you want to delete conditional rows in excel, you will have to spend a lot of time selecting and deleting in the data table. that's why this article will show you 2 ways to delete conditional rows in excel very quickly.
  • Trick to quickly delete a table in WordTrick to quickly delete a table in Word
    to delete a table in word is not as simple as you think. if you use the usual delete key to delete, it cannot be deleted. in the article below, network administrator will show you how to delete a table in word.
  • How to add units to cells in ExcelHow to add units to cells in Excel
    in addition to the available units, users can completely add other units in the excel box.
  • How to insert an Excel table into WordHow to insert an Excel table into Word
    instructions on how to insert excel tables into word. there is a small note when you perform inserting excel table into word, you should keep these 2 files in the same root directory, during work you should not move to another location, if so when you update on the table. count will
  • Delete a Table in Word - Delete a Table in WordDelete a Table in Word - Delete a Table in Word
    delete a table in word - delete a table in word. if you have difficulty deleting the table and its contents, see the article below.
  • TEMPORARY TABLE temporary table in SQLTEMPORARY TABLE temporary table in SQL
    temporary table, also known as temporary table, is a special form of table that is temporarily stored and handles intermediate results on sql
  • MS Word - Lesson 8: Creating a tableMS Word - Lesson 8: Creating a table
    table is used to display data in a tabular format. how to create a table in word, how to format word 2007 tables? please follow the instructions below.
  • 8 useful table formatting tips in Microsoft Word8 useful table formatting tips in Microsoft Word
    in microsoft word, tables are necessary formatting tools. microsoft office makes it easy to create and format basic tables in word for office 365, word 2019, word 2016, and word 2013.