All this work with table styles brings up a question. Does Excel have other kinds of styles, like Word has character and paragraph styles. Yes, indeed! Excel uses cell styles instead of character or paragraph styles. They make it easy to format different cells alike when you don't need a whole table.
A cell style, or just style, can include any formatting that can be set for a cell. This includes all of the font characteristics, number formats, alignments, fills, and borders. Excel provides some pre-defined styles in the Styles gallery on the Home tab. You can also create your own custom cell styles.
What is a cell style good for?
Step-by-Step: Cell Styles
|What you will learn:|| to open an existing workbook
to create a cell style
to apply a cell style
to check what style a cell has
to modify a cell style
to merge cell styles from another workbook
to wrap text
Start with: trips12-Firstname-Lastname.xlsx (saved in a previous lesson)
There are many ways to open an existing file.
The first cell style you will create will duplicate the formatting in the header row, row 4. You could apply the same table style to the bottom section of data, but that pulls is a lot of features that are just not needed for such a small table. Besides, this lesson is on cell styles!
the Home tab in the Styles tab group, click the More button to show the gallery of cell styles.
Styles are in groups: Good, Bad, and Neutral; Data and Mode; Titles and Headings; Number Format.
When you have
created custom styles, they are at the top in a new section, Custom.
The dialog shows the formatting for the current cell, A4.
The dialog includes a list of how the selected cell is styled. It is
nicely detailed, except for Fill, which does name the color. An odd
Click the Format... button.
The Format Cells dialog appears, where you can view or modify all of the settings.
You don't need to modify anything right now.
Click on each tab in this dialog and notice what the choices are and what the current choice is.
By the way, on the Font tab, the Preview box looks like it has no sample text. The font color is White, so the text is there, as white text on a white background. Invisible!
Click on OK again to close the Style dialog.
The new style appears in the gallery on the Home ribbon tab, listed first.
You cannot tell by looking whether or not a cell has a cell style applied to it. The Style gallery comes to the rescue!
Click on OK to close the Format Cells dialog.
The Style dialog now shows the new Font settings.
Live Preview does NOT show what effect this change
Click on OK to close the Style dialog.
The Style gallery shows the new formatting. All cells in row 27 to which you applied the Header Row cell style are using the new formatting. Sweet!
What about the cells in row 4 from which we got the
No, they stayed the same! You never applied the cell style to them.
Your new custom style is not seen by other workbooks. You can use the Merge Styles command at the bottom of the Styles menu to import styles from another workbook. Both workbooks must be open before you use that command. You can merge styles even if they have the same name.
Click on OK to close the dialog.
The Styles gallery now shows two new styles in the Custom section, Dates and Totals.
Notice that your custom cell styles are listed first, in
When your text is too long to fit in the cell's width, you can force the text to wrap inside the cell. This is often better than just widening the column enough for the text to fit.