How to Remove Table Formatting in Excel

Meet Bhaskar, your friendly neighborhood tech enthusiast-turned-wordsmith. For the past few years, he’s been your go-to guide for demystifying iOS, Android, macOS, and Windows platforms. While he holds a B.Tech degree, he has dedicated himself to simplifying tech complexities for all and has lent his expertise to publications like iGeeksBlog, The Writing Paradigm, and more. His forte lies in crafting easy-to-follow how-to guides and in-depth articles, making the intricate world of technology accessible to all. When not immersed in the tech world, you’ll find him enjoying music or sports.

Afam has been a content writer with Guiding Tech Media since August 2023. However, his experience in tech writing dates back to 2018, when he worked as a freelance writer for Make Tech Easier. Over the years, he has grown a reputation for publishing quality guides, reviews, tips, and explainer articles. His work is featured on top websites, including Technical Ustad, Windows Report, and Next of Windows. He has training as a Microsoft Certified Professional and has covered more Microsoft-related guides on these platforms.

Method 1: Clear Table Style

When working with data tables, Excel often applies predefined styles that include various formatting elements such as colors, borders, and fonts. TheClear Table Stylefunction is one of the most straightforward ways to restore a table to its default appearance or remove any applied styles.

Step 1:Open your desired Excel Sheet or Workbook.

Step 2:Click any of the cells in the table and navigate to theTable Designtab. In theTable Stylessection, click the down arrow next to preformatted tables to expand the section.

Step 3:Click theClearbutton to remove the table formatting.

Method 2: Converting to Range and Clearing All Formatting

When you want to remove special formatting and features like colored rows, filter icons, and summary rows from tables, converting to a range, then using the Clear All Formatting function is handy. Follow the steps below.

Step 1:Open the desired Excel Workbook or Sheet.

Step 2:Right-click on any cell in the table. From the options, navigate toTableand selectConvert to Range. ClickYeswhen prompted.

Step 3:Select the table in the workbook. In the Editing section, click the drop-down button next toClearand pressClear Formats.

Method 3: Using VBA

While Excel provides several built-in tools for formatting tables, there may be instances where these options fall short. VBA, a programming language embedded within Excel, allows you to automate tasks and customize functionality. Here’s how to use it:

Step 1:Open the desired Excel Workbook or Sheet.

Step 2:Launch the VBA editor by pressing theAlt+F11keys on your keyboard.

Step 3:Insert a new module by right-clicking on any existing module or the project, selectingInsert, and clickingModule.

Step 4:Enter the below-mentioned VBA code and close the window.

Step 5:Run the script by pressing your keyboard’sAlt+F8keys. SelectRemoveFormatAsTablefrom the pop-up and clickRun.

Note: Save your workbook before running any VBA code, as it cannot be undone.

If changes are not saved, you may follow specific steps tofix it on Microsoft Excel.

Was this helpful?

Last updated on 17 July, 2024

Leave a ReplyCancel reply

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

Name*

Email*

Comment*

Δ

The article above may contain affiliate links which help support Guiding Tech. The content remains unbiased and authentic and will never affect our editorial integrity.

More in Internet and Social

4 Best Free Audiobook Apps for iPhone and Android

How to Disable or Enable Location Permission for Google Chrome

JOIN THE NEWSLETTER

Get Guiding Tech articles delivered to your inbox.

© 2024 Guiding Tech Media. All Rights Reserved.