Excel Guides

Undoing an AutoFormat in Excel

If you have accidentally applied an AutoFormat to your data in Excel, there is a way to undo it.

  1. First, select the cells that you want to undo the AutoFormat on.
  2. Then, go to the Home tab and click Clear.
  3. From the drop-down menu, select Clear Formats. This will remove all formatting from the selected cells, including the AutoFormat.

Move beyond 


Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.