Clear cell formatting

Need to quickly remove formatting from an existing cell or range? Use these shortcuts to clear cell formatting while leaving the cell contents unchanged.
Quick Tip

How to clear number formats

To quickly remove number formatting from the selected cells:

ActionShortcut
Remove number formatting (revert to General)Ctrl + Shift + `
This is the same as:Ctrl + ~
Keyboard shortcut to revert number formatting to General


Bonus Tip

Please log in to see the bonus tip.

No login?
Get one for free.

Don’t have a login?

Get a login for free on our standard plan, and get a new tip each week.

Get started >>

All logins also get access to the bonus tip each week.

Get even more

Get even more with one of our reasonably priced paid plans, with access to features like:

  • Quicksheet PDF summaries
  • Example files
  • VBA syntax
  • Additional expert tips each week
  • Advance publication

Get quicker >>

View our plans to see what else you are missing, or join for free on our Standard plan.

 

Expert Tip

Please log in to see the expert tip.

Don’t have a login? Get one.