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.
- [Instructor] Excel comes with quite a few tools that you can use to format your worksheet. It also comes with 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 formatic patterns as cell styles, too. I'll demonstrate how to perform these tasks in this movie. My sample file is the cell style workbook, and you can find it in the chapter six folder of your exercise files collection.
Let's say that I want to apply an existing style to the label in cell E1, Total Sales. To do that, I select the cell, and then on the Home tab of the ribbon, I will click the Cell Styles button to display the gallery. And here I have a listing of all of the predefined formats available to me. In this case, I will click Heading 2, which applies that format to my cell. I can also create my own style, although this isn't bad.
But let's say that I want to select a new style. For that, I will go to the Cell Styles gallery, and at the bottom, next to last item, click New Cell Style. In the dialogue box that appears, I can type a style name. In this case I will call it TotalHeader. And I will leave all of the properties selected. If I didn't want to have something changed, for example, protection or the border, then I can change it.
In this case I do want to be able to change everything. So I will click the Format button. And I'm in the Format Cells dialog box. I don't need to worry about number, because this is text, so I will go to the alignment tab, and my horizontal alignment, instead of general, which allows Excel to determine which type of variable it is. I will click the control's down arrow and click Center. Vertical alignment I will change to Center as well.
So the text will be centered both vertically and horizontally within a cell. I won't worry about anything else. No indentation, won't wrap or shrink to fit, okay. I'll click the font, and rather than going with Calibri, which is the body font that is used here, I will click Cambria for headings. And instead of size 12, I'll make it size 14. And for the font style, I'll make it Bold.
I won't work with any underline, or strikethrough, superscript, or subscript, but I will change the coloring. So instead of black, I'll click the color control's down arrow, and I'll make it a bright blue. I don't want to put any border on it, although I could, changing the borders as you see here. And if I change the background color, which is the fill, then I can make a background color, although in this case I think I'll just stay with no color. With all of my changes in place, I can click OK.
And click OK again to save my work. And now, when I click cell E1, and click the Cell Styles button, I see my custom style, TotalHeader, at the top, so I'll click that. And it's applied. If I want to edit a style, I can do that by selecting the Cell Styles button. And then if I want to edit or delete a style, I can ctrl click it, so hold the ctrl key, and click my TotalHeader style.
And I can either apply it to the current cell, which I've already done. If I click modify, then I get essentially the new cell style dialog box back, except that I'm working with the style I had before. I'll click cancel. And then go back in. Control-clicking my style, I can also duplicate it, which allows me to create a style based on the one I've just created, only selecting a few items. Or I can delete. In this case, I don't want to delete the style I've just created, so I'll click away.
One final thing to note is that you can modify or delete a built-in style, but I don't recommend you do it. It can be very difficult to maintain compatibility across different computer systems if you delete or modify built-in styles.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.