Excel 简明教程

Using Styles in Excel 2010

Using Styles in MS Excel

使用 MS Excel 2010 Named styles 可以非常轻松地将一组预定义的格式选项应用于单元格或范围。这可以节省时间并确保单元格外观一致。

With MS Excel 2010 Named styles make it very easy to apply a set of predefined formatting options to a cell or range. It saves time as well as make sure that look of the cells are consistent.

样式包含多达六个不同属性的设置−

A Style can consist of settings for up to six different attributes −

  1. Number format

  2. Font (type, size, and color)

  3. Alignment (vertical and horizontal)

  4. Borders

  5. Pattern

  6. Protection (locked and hidden)

现在，让我们看看样式是如何有用的。假设您将特定样式应用于工作表中分散的二十个单元格。之后，您意识到这些单元格的字体大小应为 12 磅，而不是 14 磅。无需更改每个单元格，只需编辑样式即可。具有该特定样式的所有单元格都会自动更改。

Now, let us see how styles are helpful. Suppose that you apply a particular style to some twenty cells scattered throughout your worksheet. Later, you realize that these cells should have a font size of 12 pt. rather than 14 pt. Rather than changing each cell, simply edit the style. All cells with that particular style change automatically.

Applying Styles

选择 Home » Styles » Cell Styles 。请注意，此显示是一个实时预览，也就是说，当您将鼠标移动到样式选项上时，所选单元格或范围将暂时显示该样式。当您看到喜欢的样式时，单击它以将样式应用到选区。

Choose Home » Styles » Cell Styles. Note that this display is a live preview, that is, as you move your mouse over the style choices, the selected cell or range temporarily displays the style. When you see a style you like, click it to apply the style to the selection.

apply style

Creating Custom Style in MS Excel

我们可以在 Excel 2010 中创建新的自定义样式。要创建新样式，请按照以下步骤操作−

We can create new custom style in Excel 2010. To create a new style, follow these steps −

  1. Select a cell and click on Cell styles from Home Tab.

  2. Click on New Cell Style and give style name.

  3. Click on Format to apply formatting to the cell.

creating style

  1. After applying formatting click on OK. This will add new style in the styles. You can view it on Home »; Styles.

added custom styles