logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Clean Up Data and Formatting...

ASAP Utilities  › Text  ›  12. Clean Up Data and Formatting...

This tool helps you quickly clean up data and formatting issues in your selected range. It's useful when working with pasted or imported data, exports from other systems, or spreadsheets with inconsistent formatting and values.  
Instead of manually fixing everything, you can apply multiple cleanup actions in one go, saving time and making your data easier to work with. You can choose to apply any combination of the following actions:
  • Remove all hyperlinks
  • Trim leading and trailing spaces
  • Remove all fill colors
  • Remove all font colors
  • Remove all borders
  • Unmerge cells
  • Apply the standard font
  • Apply the standard font size
  • Turn off wrap text
  • Fix numbers stored as text
  • Autofit column widths
  • Autofit row heights
  • Remove all objects and images from the worksheet Your last used settings are automatically remembered so that you can repeat your preferred cleanup steps quickly. By default, you can launch this tool using the Control+Alt+Shift+C shortcut.

    Screenshots

    Text  ›  12 Clean Up Data and Formatting...
    ASAP Utilities makes YOU rock in Excel!

    Practical tricks on how this can help you

    Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!

    Starting this tool


    Text  ›  12 Clean Up Data and Formatting...
    Additional keywords for this tool:
    Clean up Excel data, Remove extra spaces, Clean formatting in Excel, Fix numbers stored as text, Trim spaces tool, Remove unwanted formatting, Remove hyperlinks, Unmerge cells, Reset Excel formatting, Clean copied data, Prepare data for analysis, Remove fill color, Fix pasted data, Clean data from website, Tidy up spreadsheet, Remove cell borders, Remove font color, Standardize cell formatting, Autofit columns and rows, Bulk clean data, Textnumbers, Convert imported values, Clean dataset, Clean information that is copied from websites



  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.