In the last few practice videos, we've had a look at some useful tools for adding formatting to our workbooks. The next tool we're going to look at is really exciting. It allows us to very quickly copy formats from one cell to another, and you just call the Format Painter. The format painter is located in the Clipboard group on the home tab of the ribbon. Let's have a look at how it works. So, I've decided that my account managers could stand out a little bit more. I'm going to click on Aanya and make that bold and italics and a dark shade of blue. I'm very happy with that, but now I need my other account managers to look the same. So, rather than doing those three steps manually, I'm going to make sure that I've clicked on the cell that has the formatting I want to copy. I'm going to come up to my Format Painter and click on it, and then, I'm going to click and drag to paste the formats onto the other cells. That both guarantees consistency and it's much quicker, but wait, there's more. The format painter can also be used to copy multiple formats simultaneously. So, let's, for example, say I want to get rid of these borders. So, I'm going to click No Borders, and instead what I want is banded rows, that means alternating colored rows. I've selected my second row, and I'm going to make it a pale gray. Now, I want to copy that formatting down to the rest of my data. So, I select both rows, come up to my Format Painter, and then drag it on to the rest of the data. No more borders, lovely banded rows. You can do this on an even larger scale as well. So, having a look at my sales 2015, no formatting at all. I want the sheets to look exactly like 2016. So, I'm going to come back to sales 2016, and select all my cells, then I'm going to click on format painter, come to sales 2015, and just single click top left-hand corner, all formatted. So, really powerful tool for speeding up copying of formats. Now, what about if we wanted to remove these formats quickly? Again, coming to each cell and changing it back to not be bold and not be blue would be very slow. So, the other option we have is the option to clear our formats. The clear tool is located on the right-hand side of the ribbon. If I were to choose clear all, that will actually remove the contents of the cell as well. So, we're just going to focus on the clear formats. Again, start by selecting the cells that you want to clear the formatting from, come up to your clear, and click clear formats. So, a very quick way of getting rid of formatting that you don't want. So, we've looked at two tools, the Format Painter which allows us to copy formatting, and the Clear Formats which allows us to remove formatting. Don't forget to practice it, and make it part of your everyday use of Excel.