Windows Mac
Ctrl1 ⌘1

About This Shortcut 

This shortcut is a 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.

Format cells dialog box

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

Excel How to use SUMIFS with an Excel Table

How to use SUMIFS with an Excel Table

In this video, we'll look at how to use the SUMIFS function with an Excel Table. On this worksheet, I have two identical sets of order data. I'm going to walk through the process of constructing a summary of sales by item for both sets of data. With the data on the left, I'll use standard formulas …
Excel How to build a simple pivot chart dashboard

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. Here's the chocolate sales data we looked at earlier. Using the techniques discussed in this section, let's build a simple dashboard to show sales by city and top 5 chocolate flavors. …
Excel The Format Task pane

The Format Task pane

This video takes a look at the Format Task Pane, a formatting control added in Excel 2013 to format and configure chart elements. The Format Task Pane was added in Excel 2013 and provides detailed controls for most chart elements. Previously, this sort of formatting was done with the Format dialog …
Excel Charts and custom number formats

Charts and custom number formats

In this video, we'll look at how to apply number formats to a chart. One of Excel's key features is the ability to apply number formats to change the display of numeric data, without affecting the data itself. For example, these numbers are using the "General" number format. If I switch to …
Excel How to highlight exact match lookups

How to highlight exact match lookups

In this video, we'll look at how to use conditional formatting to highlight rows and columns associated with exact match lookups. Whenever you have a lookup table visible to users, a nice touch is to highlight the rows and columns that match the current lookup. This makes it easy for users to see …
Excel Shortcuts for formatting

Shortcuts for formatting

In this video, we're going to look at tips and techniques for formatting worksheets faster. This worksheet is a simple model that compares the cost of buying coffee at a coffee shop vs. making coffee at home. There's very little formatting, so I'll use a number of shortcuts to clean thing up. First, …
Excel Shortcuts to find and replace

Shortcuts to find and replace

In this video, we'll look at the shortcuts you can use for find and replace in Excel. To find something in Excel, you can use Control + F on Windows and Command + F on a Mac. Control F also works on a Mac. Once you've found something, you can press Return or Enter to "find again". If you hold down …
Excel How to calculate the number of days between dates

How to calculate the number of days between dates

In this video we'll look at how to calculate the number of days between dates. To get started, let's first set up some dates, so we have a visual representation to refer to. In C5, I'll add a start date. Then, I'll add and copy a formula below that simply adds "1" to each date above. The result is …
Excel How to format numbers in a pivot table

How to format numbers in a pivot table

The moment you add numbers to your pivot table, you'll want to adjust the formatting. You could just select the numbers in the pivot table itself, and format normally, but there's a better way. Let's take a look. There are two ways you can format values in a pivot table. The first way is to select …
Excel How to apply a border to cells in Excel

How to apply a border to cells in Excel

Borders build directly on Excel's grid system. They are one of the best ways to visually organize content in Excel, or to call attention to certain information. Let's take a look. Before you apply borders, you may want to turn off the gridlines that appear by default in Excel. This will make it …

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.