Select Page

10 Awesome Excel Tips: Format Painter

by | Aug 7, 2022 | Excel Tips, Walkthroughs / Tutorials | 0 comments

Let’s pretend you’re working in your Excel spreadsheet and you want to change the formatting of the cells in a column.

You might experiment first with one cell. To see what it looks like, before you spend time copying to all your cells.

Let’s first change the font of this cell in our date column. We’ll try out ‘AR Bonnie’.

That looks good. However, it’s a bit bigger than the other cells. So, we’ll reduce the size.

Let’s say instead of that date format we’ll try Long Date.

We’ll stick with that format.

Now to copy that format to the rest of the cells. Select the cell we formatted, then click on ‘Format Painter’.

Using Format Painter

Next select all the cells in that column. That will automatically copy the formatting from your first cell, into all the cells in your column. 

Format Painter in action

I’m Peter Koebel from Data Sciencing Consultants. If you need assistance overcoming an obstacle or challenge in your Excel spreadsheet, you can contact me at 204-770-6437, email, or fill out the form on our website

Looking for more fun with data? You might enjoy some of our other posts!

US Population Density Map using Tableau Join our founder, Peter Koebel as he demonstrates a population density map using Tableau. You've probably seen population density visualizations everywhere, but how can you use them in your own...

Datasciencing Customer Demographics with Power BI Join our founder, Peter Koebel, as he walks through datasciencing customer demographics with Power BI. Datasciencing can be tough, but does it have to be? Check out this demonstration...