How to Clear All Cell Formatting in Excel 2011

Cell formatting can be a problem when you need data to display in a certain fashion in your Microsoft Excel worksheet. 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. Fortunately Microsoft Excel 2011 for Mac has a function that can remove all of the formatting from your selected cells.

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. Then you can start from scratch and format your cell data as needed for your current project.


Remove All Cell Formatting from a Spreadsheet in Excel 2011

The steps in this article were performed using the Excel 2011 application for the Mac operating system. The method for performing this action in Windows versions of Excel is slightly different. If you are using Microsoft Excel 2013, then you can clear cell formatting using the steps in this article.


  1. Open your worksheet in Excel 2011 for Mac.

  3. Click the cell at the top-left corner of the worksheet, above the row 1 heading, and to the left of the column A heading. This will select every cell in the worksheet. The cell in question is identified in the image below. If you only need to select some cells, however, then you can click and drag your mouse to select individual cells, or you can click a number to the left of a row, or a letter at the top of a column, to select that entire range of cells.
  4. select all worksheet cells



  5. Click the Home tab at the top of the window.
  6. click the Home tab



  7. Click the Clear button in the Edit section of the navigational ribbon, then click the Formats option.

click clear, then formats



All of the formatting that has been applied to the cells in your worksheet will now be removed. This will make it much simpler to format the cells in your worksheet as required for your project.


Are you having difficulty printing the worksheets that you have created, or are editing, in Microsoft Excel 2011 for Mac? You can learn how to print your worksheet on one page if you find that you have extra columns which are causing your spreadsheet to print on more pages than you want.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Newest Guides