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

The videos below demonstrate this shortcut.
How to build a simple pivot chart dashboard
In this video, we'll build a simple dashboard by setting up a slicer to control to more than one pivot chart.
Shortcuts for formatting
In this lesson, we cover shortcuts you can use to format cells and other objects.
Selecting chart elements
In this video, we'll look at how to select and customize chart elements.
How to build a stacked column chart
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.
How to use VLOOKUP
In this video, learn how to use VLOOKUP to build a simple form to extract employee information from a table, in about 3 minutes. VLOOKUP is a key Excel function.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.