![how to clear formatting in excel how to clear formatting in excel](https://cdn.extendoffice.com/images/stories/doc-excel/remove-conditional-formatting/doc-remove-conditional-formatting1.png)
Once you have verified that the data is okay, save the file back to the original name. NOTE: Before running the clean option it is recommended that you save the file with a different name to protect against data loss. Click on Clean Excess Cell Formatting from Inquire menu and follow the prompts. In COM Add-ins window, check Inquire and click OK:Īn Inquire Tab is now available on Ribbon. Select COM Add-ins from Manage dropdown field and click Go: While in your spreadsheet, click on File > Options > Add-Ins: Resolution: Copy the contents of the sheet into a new sheet using the “Paste Values” option when pasting (which strips out all formatting and leaves only data), or use the Microsoft-provided Add-In called Inquire which helps perform this clean-up.
![how to clear formatting in excel how to clear formatting in excel](https://support.content.office.net/en-us/media/886a4e34-ecdd-4313-8e5d-e923effb087f.png)
Select the text with the formatting you want to clear. Select Undo to undo the last formatting change. Reason: The slowness may be caused by old formatting in the spreadsheets. If you change the formatting of text or images and then decide you don't like it, you can undo it. Issue: Basic copy/paste/change actions as well as opening and saving files take a significant amount of time to complete. You can follow the steps below to clean out the formatting in your spreadsheets... The savings in time and frustration is wonderful!” The files now take just 11 – 30 seconds to open and save instead of 3-10 minutes. My macro clears formatting but preserves the. “With the information you shared with me, I was able to remove the excess formatting that brought the workbooks from over 11,500 kb each, to a under 150 kb. You can go to Home->Clear-Clear Formats and that clears all formatting including number formatting. In case you want to completely clear the content (including values as well as the formatting), use the below steps: With the cells (that only have the values) selected, click the Home tab In the Editing group, click on the ‘Clear’ option. That formatting can come with a cost, such as large file sizes and long wait times to launch the spreadsheet.Ī colleague recently helped someone clean out the formatting in their Excel spreadsheet with the following results: Sometimes when working with Excel, you may end up with a spreadsheet that has an excessive amount of formatting.