This article was co-authored by How.com.vn staff writer, Rain Kengly. Rain Kengly is a How.com.vn Technology Writer. As a storytelling enthusiast with a penchant for technology, they hope to create long-lasting connections with readers from all around the globe. Rain graduated from San Francisco State University with a BA in Cinema.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 10,435 times.
Learn more...
Do you want to remove a table in Microsoft Excel? If you have any unwanted formatting, you can easily clear it with the "Clear" tool. If you want to convert a table back to a range of data, you can use the "Convert to Range" tool. This will delete the table while keeping all your important data. This How.com.vn will show you how to remove table formatting in Microsoft Excel using your Windows or Mac computer, iPhone, or Android device.
Things You Should Know
- Highlight the table you want to change. Click "Home" → "Format as Table" → "Clear".
- To remove the table, highlight the table → "Table Design" → "Convert to Range" → "Yes".
- On mobile, highlight the table → "Home" → "Table" → "Convert to Range".
Steps
- Open a project in Microsoft Excel. You can use an existing project or create a new spreadsheet.[1]
- Microsoft Excel is available on Windows and Mac. You can also use the online web version at https://www.office.com/.
- Highlight the table you want to change. Click the top-left corner of the table and drag the cursor to the bottom-right corner. This will select all the cells within the table.
- If needed, you can create a new table.
Advertisement - Click Home. You can find this on the top toolbar, next to Insert. You may already be on this tab.
- Click Format as Table. This will be in the Styles section. A drop-down menu will open.
- Click Clear. This will be at the bottom of the drop-down menu.
- On some devices, you can find the Clear icon in the Editing section. This looks like a pink eraser icon. Tap Clear, and then tap Clear Formats.
- The table's formatting will be removed.
- Remove the table (optional). If you want to remove the entire table rather than just the style, you can convert the table into a range of data.[2] Do the following:
- Highlight the table.
- Click the Table Design tab.
- In the "Tools" section, click Convert to Range.
- Click Yes.
- The table will be converted.
- Open a project in the Microsoft Excel app. The app looks like an x on top of a green rectangle.
- Microsoft Excel is available on iOS and Android.
- Highlight the table you want to change. Tap the cell in the top-left corner of the table, and then drag the right circle to the cell at the bottom-right corner. This will select all the cells within the table.
- Tap Home. If you don't see the menu, tap the icon of the A in front of a pencil.
- Tap Table. This will be at the very bottom of the list.
- Tap Convert to Range. The table will be converted into a range of data. You can now remove the formatting.
- Tap Home. You may have been redirected to this tab.
- Tap Clear. This will be towards the bottom of the Home tab.
Expert Q&A
Tips
References
About This Article
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.