Quick, clean, and to the point

Format (almost) anything

Windows shortcut 
Mac shortcut 

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.

Related videos

The videos below demonstrate this shortcut.
In this video, we'll look at how to create a stacked column chart. In a stacked column chart, data series are displayed as vertical columns, stacked one on top of the other.
In this video, we'll take a look at the tools that Excel provides for creating and managing charts.
In this video, we show you how to quickly remove all borders and fills when you want to start fresh. This is a good idea when you've inherited a messy worksheet.
In this video, we'll look at how to several ways calculate the number of days between dates. To get started, let's first first set up some dates, so we have a visual representation to refer to.
In this video, we'll look at how to apply number formats to a chart using special codes.