Some cell styles are based on the document theme that is applied to the entire workbook. If needed, you can modify a predefined cell style to create a custom cell style. To prevent anyone from making changes to specific cells, you can also use a cell style that locks cells.Įxcel has several predefined cell styles that you can apply. A cell style is a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading. For charts, you can customize a chart style and save it as a chart template that you can use again.ĭepending on the data that you want to format, you can use the following styles in Excel:Ĭell stylesTo apply several formats in one step, and to ensure that cells have consistent formatting, you can use a cell style. If predefined styles don't meet your needs, you can customize a style. Using styles to quickly format dataĪ style is a predefined, often theme-based format that you can apply to change the look of data, tables, charts, PivotTables, shapes, or diagrams. If needed, you can also create your own document theme by changing any or all of the theme colors, fonts, or effects that a document theme is based on.īefore you format the data on your worksheet, you may want to apply the document theme that you want to use, so that the formatting that you apply to your worksheet data can use the colors, fonts, and effects that are determined by that document theme.įor information on how to work with document themes, see Apply or customize a document theme. Your company may provide a corporate document theme that you can use, or you can choose from a variety of predefined document themes that are available in Excel. For a uniform and professional look, a document theme can be applied to all of your Excel workbooks and other Office release documents. Working with document themesĪ document theme is a predefined set of colors, fonts, and effects (such as line styles and fill effects) that will be available when you format your worksheet data or other items, such as tables, PivotTables, or charts.
For example, you can use document themes for a uniform look throughout all of your Excel spreadsheets, styles to apply predefined formats, and other manual formatting features to highlight important data. You can use several fast and simple ways to create professional-looking worksheets that display your data effectively. In Excel, formatting worksheet (or sheet) data is easier than ever.
0 kommentar(er)
