Ask a question »

Excel - Remove all cell formatting

July 2015


Microsoft Office is the most widely used office software, comprising many applications. It is compatible with the Mac OS and the Windows operating systems. One of the applications in Office is Excel, which allows users to store, organize, and calculate data with formulae using a spreadsheet. Excel also enables users to remove all formatting from cells. To remove all formatting, select all the cells and select 'Clear formats' from the button present in the editing section of the Home tab. This will convert your data in the cells of worksheet into plain text and allows you to use it for storing or calculating other information.

[Excel] Remove all cell formatting


To clear out all formatting from all cells in a worksheet:
  • Press CTRL + A to select all the cells
  • Click on the Home tab > Editing Section > Clear button
  • Select the "Clear Formats" option.
  • From now on all the data in your cells will be in plain text.
For unlimited offline reading, you can download this article for free in PDF format:
Excel-remove-all-cell-formatting.pdf

See also

In the same category

Excel 2010 - Borrar el formato de las celdas
By Carlos-vialfa on November 26, 2010
Jak usun?? formatowanie komórek w Excel 2007
By technomix on July 23, 2015
Published by jad05.
This document entitled « Excel - Remove all cell formatting » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.