Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Excel comes with quite a few tools you can use to format your worksheet. One of those tools is a set of predefined formats called cell styles that you can apply to your worksheet. If you find that you consistently create your own formats for headers, text, and other worksheet elements, you can save those formatting patterns as cell styles too. You can find the built-in styles on the Home tab of the Ribbon, in the Format group, and that's here, and you can see that you have an in-Ribbon gallery, which, if I hover over the styles that are visible, I can click the expand arrow and see all of the styles that are available for this workbook.
If you want to apply a style, you can click the cell to which you want to apply it and then expand the gallery and click the one you want. In this case, I'll apply Heading number 1, and when I do, Excel applies that formatting. And I will drag the column to the side so that it will put this underlining all the way along the bottom of the cell. If you want to create a new style, you can click the expand arrow, and then at the bottom, you can click New Cell Style. I'll go back a bit and you see that I have existing formatting here in cell E1.
When I start to create a new style, Excel will take the formatting from this cell and use it as the basis for the new style. So, I'll expand the gallery again, click the Expand arrow, click New Cell Style, and when I do, Excel creates a new style called Style 1, and you can see that it's previewed here. If I were to type Bright Blue Header as the Style name and then click Format, Excel displays the Format Cells dialog box, and if I click Font, you'll see that my selection, 18 point Cambria in bold with the blue color, has already been applied.
I can use controls in the Format Cells dialog to make any changes I want. I can add Borders, I can add Fill to the cell; anything that you want to do to create your new cell style. When I click OK, I'm back in the New cell style dialog, and I click OK again, and Excel has created the Style. And you can see that it's here in the Gallery, and if I click the Expand button, you'll see that my style appears at the very top in the new Custom category. If you want to modify an existing style, you can do so by Ctrl+Clicking it, so I'll hold down the Ctrl key and click my new style, and then from the menu of items that appears, I'll click Modify.
When I do, Excel displays the Modify Cell Style dialog, and it's exactly the same as the New Style dialog; it's just that now, you're making a change. So if I wanted to, I can click the Format button, and let's say that I changed the background color to a very light blue. When I click OK, the Preview appears here; click OK again, and there is the Style. When I click it, Excel applies it to the active cell. If you want to delete a style, this is something you can do from within the Ribbon Gallery as well. All you need to do is Ctrl+Click the style that you want to get rid of and then click Delete.
When you do, Excel removes the style from any cells to which it had been applied. Cell styles help you format your worksheets quickly and consistently. If your company has a set of graphics guidelines you have to use when you create your documents, saving those settings in a cell style will save you lots of time and effort.
Get unlimited access to all courses for just $25/month.Become a member
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.