Return to General Format

How to quickly return to general format.

June 14, 2001 12:00AM EST

June 14, 2001

This site may earn affiliate commissions from the links on this page. Terms of use.

Although applying formats is an easy task, a complex sheet can require a bit more thought and time. Unformatting a sheet is much quicker. It's not necessary to select each formatted cell or range and remove each format. You can quickly return a cell, a range, or even the entire sheet to the General format. To do so, select the cell or range you want to unformat, then press Ctrl+Shift+~ (tilde). Excel will remove all formats and return the selected cell or range to the General format (the default format for all sheets).