How to Clear Formatting in Excel Sheet

This is a quick article to walk you through how to clear formatting on excel sheets in case your part list errors out during import.

First launch the excel sheet. Once that's open, look for the home tab (1). Once that is selected, highlight the entire excel sheet (2)

**Hint** If you click CTRL + Shift + the arrow key in the direction you want to go, it will automatically highlight all text. So for this example, I hit CTRL + Shift + Right and than CTRL + Shift + Down

Once everything is highlighted, click on the "Clear"  tab (3) and select "Clear Formats" (4).

This will clear formatting from the excel sheet.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request



Please sign in to leave a comment.