Where is format painter in excel for mac

This Excel tutorial explains how to use the Format Painter in Excel for Mac with screenshots and step-by-step instructions. The Format Painter allows you to copy formatting from a cell or group of cells to another section of the Excel spreadsheet. It is a quick and easy way to apply your existing formatting without having to manually set up the the number formatting, alignment, font, border, and patterns for the cells.

First, select the cell that has the formatting that you wish to copy. In this example, we have selected cell A3. Then select the Format Painter button in the standard toolbar at the top of the screen. In all Excel versions, the Format Painter button is located on the Home tab, in the Clipboard group, right next to the Paste button:. The new formatting is copied to your target cell. If you need to change formatting of more than one cell, clicking each cell individually would be tedious and time consuming.

The following tips will speed things up. To copy formatting to several adjacent cells, select the sample cell with the desired format, click the Format Painter button, and then drag the brush cursor across the cells that you want to format.

To copy formatting to non-contiguous cells, double-click the Format Painter button instead of single-clicking it. To quickly copy the format of the entire column, select the heading of the column whose formatting you want to copy, click Format Painter , and then click the heading of the target column. As demonstrated in the following screenshot, the new formatting is applied to the target column row-by-row, including the column width :.

In a similar manner, you can copy the format of the entire row , column-by-column. For this, click the sample row heading, click Format Painter , and then click the heading of the target row.

As you have just seen, the Format Painter makes copying format as easy as it can possibly be. However, as is often the case with Microsoft Excel, there is more than one way to do the same thing. Below, you will find two more methods to copy formats in Excel. We often use the fill handle to copy formulas or auto fill cells with data. But did you know that it can also copy Excel formats with just a few clicks?

Here's how:. That's it! The cell values revert to the original values, and the desired format is applied to other cells in the column:. But you can customize a shortcut. Select "Edit" from categories. On the right hand side select "Formatting". Go to "Press new shortcut key" and type in a new shortcut.

And , click on "Add". Close the window. All set. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. What is Format Painter shortcut in Excel for Mac?