If we know how to format cells by using the ribbon up at the top here. So we could go and select font, color fill, color border, but is there a quicker way to do it? And the answer is absolutely yes. There are a couple of ways that we could now, once we formatted one cell, we could copy and paste the formatting. And this is not just for advanced users of Excel at all, every single user of Excel is going to benefit from this. What we need to do is we start by selecting a cell that already has some formatting and we then need to copy it. You can copy by pressing control C, or we could go up to the ribbon, the home ribbon. So it might look a little different to yours, but in the clipboard section, I've got these two pieces of paper and if I hover over them, it says, copy. I'm going to copy that. Or I could press control C, and then I go to another cell where I want to paste the formatting. And I could use my ribbon here, click on the paste dropdown and it's the bottom left in the other paste option section if I hover over it, it now says formatting. That's fantastic, and I could do that a couple of times if I wanted to to paste the formatting much quicker. There's another way that we could have done this. Let's go back to that initial 15,000. I press escape, go back to that initial 15,000 and I could click on Format Painter. So again, up in the home ribbon in the clipboard section, I'm going to click on that twice and that allows me to click and paste and paste and all I'm doing is clicking with my mouse, I could even click and drag. And that applies the formatting again and again and again. Once I'm done, I just press escape. I'm going to undo that. I want to show just one more way to do this.

Let's imagine that we've copied gone to another cell and I have pasted my formatting.

So if the last thing I did was to paste some formatting, I'd now like to repeat that and we can do that using a couple of shortcuts. I could go to the 150 here and I compress F4 on your keyboard. It might be function F4 or the FN key and then F4. Alternatively, if that's not working, you can press control Y and what it does, control Y or FN, it repeats the last thing you did. Super useful for formatting, but you can use it for loads of things in Excel. So if you have formatted a cell and want to copy paste that formatting, there's a couple of ways you can do it.