Format Anything

Using the Format Anything Shortcut

Windows keyboard shortcut

Mac keyboard shortcut

This Excel shortcut displays the Format Cells dialog box when regular cells are selected, even if the ribbon is collapsed.

This shortcut is very useful to format just about anything in Excel. With a normal cell selected the Format Cells dialog box is opened and provides access to font, border, alignment, and number formatting options. If you are in a chart the same shortcut will open various formatting dialog boxes depending on what you have selected.

This shortcut also works when you are working with Smart Art and shapes.
Other useful Formatting keyboard shortcuts