Select Page

Format Painter – Let’s Have Data Fun with Excel

by | Apr 8, 2022 | Uncategorized | 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!

Survivorship Bias in Business

Survivorship Bias in Business

What is your company doing to not get duped by the survivorship bias trap? I’ll give you a classic example of survivorship bias. You might recognize this picture if you’ve studied survivorship bias, statistics, or data visualization. In World War 2 the U.S. Military...