Clear cell formattingNeed to quickly remove formatting from an existing cell or range? Use these shortcuts to clear cell formatting while leaving the cell contents unchanged.
How to clear number formats
To quickly remove number formatting from the selected cells:
|Remove number formatting (revert to General)||Ctrl + Shift + `|
|This is the same as:||Ctrl + ~|
Don’t have a login?
Get a login for free on our standard plan, and get a new tip each week.
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