Exceljet

Quick, clean, and to the point

Format (almost) anything

Windows shortcut 
Ctrl1
Mac shortcut 
⌘1

This shortcut is the gateway to many formatting options, even when the ribbon is collapsed.

When regular cells are selected, it displays the Format Cells dialog box with the "last tab used" selected. This is a very fast way to access font controls, borders and fills, alignment options, and number formats from anywhere in Excel. When you're working with a chart, the same shortcut will open various formatting dialogs, depending on what you have selected. For example, if you have the chart area selected, it will open the Format Chart Area dialog. If you have data bars selected, it will open the Format Data Series dialog. And so on. You can also use this shortcut when working with shapes and smart art.

222 Excel Shortcuts for Windows and Mac

Related videos

Tip: Calculate due dates with the WORKDAY function
Calculate due dates with the WORKDAY function
This video show how to calculate due dates with the WORKDAY and WORKDAY.INTL functions. You can use WORKDAY to calculate intelligent ship dates, delivery dates, and completion dates that take into account non-working days.
Tip: How to highlight exact match lookups
How to highlight exact match lookups
In this video, we show you how to use conditional formatting to highlight rows and columns associated with exact match lookups. This is a sleek, interactive way to show users matching values.
Tip: How to use SUMIFS with a table
How to use SUMIFS with a table
In the video, we build one set of SUMIFS formulas with a table, and one set without. This makes it really easy to see the nice benefits you get when you combine tables and formulas.