If you are using Microsoft Excel 2013, then you can clear cell formatting using the steps in this article.

The method for performing this action in Windows versions of Excel is slightly different.

The steps in this article were performed using the Excel 2011 application for the Mac operating system. Remove All Cell Formatting from a Spreadsheet in Excel 2011 Then you can start from scratch and format your cell data as needed for your current project. Our tutorial below will show you how to quickly select every cell in your worksheet, then remove all of the formatting that has been applied to those cells. Fortunately Microsoft Excel 2011 for Mac has a function that can remove all of the formatting from your selected cells. There are many ways to change the formatting of a cell, but if you have received a spreadsheet from another person, then finding each of the options that they have modified can be frustrating. Cell formatting can be a problem when you need data to display in a certain fashion in your Microsoft Excel worksheet.