The next option, I want to take-a-look at it here is going to help streamline your efforts as you formatted document especially really large documents. We are going to talk about the format painter.
Now I want to point out that the format painter is exclusive to Excel, You will find the same option is set in Microsoft Word and PowerPoint.
So, what we are about discuss here is going to benefit you in those other two out Application. So, I hope you are ready for this.
The idea of the format painter is like copy and paste but for formatting only, catch that copy and paste but only for formatting.
I have got these headers up here, they are big and bold, blue background white text. I want to take those headers the formatting of those to be able to apply them to MIN, MAX, AVERAGE and COUNT headers as well.
Now I could do this I could try to remember what I did to this cells and then just go down and format these Cells to match kind of guess.
So I am going to select one cell of my headers up (example B5 cell), that I want to copy the formatting from it, So with that selected I will go to Home tab, I am going to go into the clipboard section and there is something that looks like a little paintbrush, this is the format painter.
You can see I get the little marching ants like I would if I was copying and my cursors got a little paintbrush next to it now.
Now I am going to go click on MIN, MAX, AVERAGE, COUNT hold and drag, and I have copied the formatting from B5 down for B13 to B16.
This is highly effective especially you have got larger documents where you need to go through and format, just copy the formatting from one location to a new location.
Try it out, and again this features not only Excel but Word and PowerPoint. An effective way to copy formatting all over the place. And this works across worksheets across workbooks, not just one worksheet but multiple.