Excel’s Format Painter is one of those key time saving tools for styling your spreadsheets. With the Format Painter, we can quickly apply the styles from one table to another.
How to Use the Excel Format Painter in 60 Seconds
How to Use Format Painter in Excel Quickly
Note: Watch this short tutorial screencast or follow these quick steps that compliment this video:
1. Excel Spreadsheet With Styled and Unstyled Formats
Let’s say that we have a nicely styled list of data and an unstyled one, as you’re seeing me work with here.
2. How to Use Format Painter to Style a Table in Excel
I can highlight the table on top that’s already styled, then click on Format Painter and then click on the unstyled table. You’ll see that the style is applied and the table is looking great.
3. Apply Format Painter to Stye Variable Size Tables
Let’s switch sheets here. If my tables weren’t the same size, I could just grab one of each type of style.I’ll highlight a white row and a blue row here.
Let’s click the Format Painter again. Now, I’ll click and drag over the entire unstyled table and it alternates the row colors, as well.
Excel basically loops over the rows and alternates applying the styles, no matter the size. Then I could Format Paint the header row separately.
I’ll grab the header row in my original table, click Format Painter and then click on the other header row to be styled.
More Quick PowerPoint Videos (60 Second Tutorials)
Find more Excel tutorials on СodeHolder Tuts+ to help you learn how to style and worki with data better in your spreadhseets.
Microsoft ExcelHow to Format Your Spreadsheets in Excel with StylesBob Flisser
Microsoft ExcelHow to Use Excel: 12 Techniques for Power UsersBob Flisser
Microsoft ExcelHow to Find and Remove Duplicates in Excel QuicklyAndrew Childress
Remember: Every Microsoft Excel technique you practice and tool you become familiar with, the better spreadsheets you’ll be able to make.