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.
Related videos
The videos below show how this shortcut can be used.
In this video, we'll look at how to plot average daylight hours per month in a chart, using sunrise and sunset data.
In this video, we explain what number formats are and how they are used in Excel.
In this video, we'll look at how to apply number formats to a chart using special codes.
In this video, we show you how cell borders work in Excel, and how to control which parts of selection have borders.
In this video, we'll look at the shortcuts you can use for find and replace in Excel.
