Share via

Keyboard shortcut to clear formatting in Microsoft Excel

Anonymous
2024-03-11T11:32:52+00:00

Hi

  1. What's the keyboard shortcut to clear formatting in Microsoft Excel?
  2. If there isn't one, how can I add it?

Other popular spreadsheet applications allow you to easily clear all formatting with "CTRL + ".

I would like a similar keyboard shortcut in Excel.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2024-03-11T12:11:14+00:00

    Excel doesn't have a built-in shortcut to clear formatting, but you can use the keyboard to click the ribbon options: Alt+H, E, F.

    Alternatively, create a macro in your personal macro workbook PERSONAL.XLSB:

    Sub ClearFormatting()
    On Error Resume Next
    Selection.ClearFormats
End Sub

    You can assign it to Ctrl+\ by executing

    Application.OnKey "^\", "ClearFormatting"

    5 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-03-11T16:50:47+00:00

    Thank you

    0 comments
  2. Anonymous
    2024-03-11T12:40:24+00:00

    Thanks very much for your reply.

    Is there a way to make the macro active for the all spreadsheets by default? (or each spreadsheet be saved as an xlsm and the macro added each time to make it active?)

    0 comments