To apply several formats in one step, and to make sure that cells have consistent formatting, you can use a cell style. A cell style is a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading. To prevent anyone from making changes to specific cells, you can also use a cell style that locks cells.
Microsoft Office Excel has several built-in cell styles that you can apply or modify. You can also modify or duplicate a cell style to create your own, custom cell style.
Important:Cell styles are based on the document theme that is applied to the whole workbook. When you switch to another document theme, the cell styles are updated to match the new document theme.
Newer versionsOffice 2007 – 2013
-
Select the cells that you want to format. For more information, see Select cells, ranges, rows, or columns on a worksheet.
-
On the Home tab, in the Styles group, click the More dropdown arrow in the style gallery, and select the cell style that you want to apply.
-
On the Home tab, in the Styles group, click the More dropdown arrow in the style gallery, and at the bottom of the gallery, click New Cell Style.
-
In the Style name box, type an appropriate name for the new cell style.
-
Click Format.
-
On the various tabs in the Format Cells dialog box, select the formatting that you want, and then click OK.
-
Back in the Style dialog box, under Style Includes (By Example), clear the check boxes for any formatting that you do not want to include in the cell style.
-
Click OK.
-
On the Home tab, in the Styles group, click the More dropdown arrow in the style gallery.
-
Do one of the following:
-
To modify an existing cell style, right-click that cell style, and then click Modify.
-
To create a duplicate of an existing cell style, right-click that cell style, and then click Duplicate.
-
-
In the Style name box, type an appropriate name for the new cell style.
Note:A duplicate cell style and a renamed cell style are added to the list of custom cell styles. If you do not rename a built-in cell style, the built-in cell style will be updated with any changes that you make.
-
To modify the cell style, click Format.
-
On the various tabs in the Format Cells dialog box, select the formatting that you want, and then click OK.
-
In the Style dialog box, under Style Includes, select or clear the check boxes for any formatting that you do or do not want to include in the cell style.
You can remove a cell style from data in selected cells without deleting the cell style.
-
Select the cells that are formatted with the cell style that you want to remove. For more information, see Select cells, ranges, rows, or columns on a worksheet.
-
On the Home tab, in the Styles group, click the More dropdown arrow in the style gallery.
-
Under Good, Bad, and Neutral, click Normal.
You can delete a predefined or custom cell style to remove it from the list of available cell styles. When you delete a cell style, it is also removed from all cells that are formatted with it.
-
On the Home tab, in the Styles group, click the More dropdown arrow in the style gallery.
-
To delete a predefined or custom cell style and remove it from all cells that are formatted with it, right-click the cell style, and then click Delete.
Note:You cannot delete the Normal cell style.
-
Select the cells that you want to format. For more information, see Select cells, ranges, rows, or columns on a worksheet.
See AlsoWhat Does Ctrl+M Do? -
On the Home tab, in the Styles group, click Cell Styles.
Tip:If you do not see the Cell Styles button, click Styles, and then click the More button
next to the cell styles box. -
Click the cell style that you want to apply.
next to the cell styles box.-
On the Home tab, in the Styles group, click Cell Styles.
Tip:If you do not see the Cell Styles button, click Styles, and then click the More button
next to the cell styles box. -
Click New Cell Style.
-
In the Style name box, type an appropriate name for the new cell style.
-
Click Format.
-
On the various tabs in the Format Cells dialog box, select the formatting that you want, and then click OK.
-
In the Style dialog box, under Style Includes (By Example), clear the check boxes for any formatting that you do not want to include in the cell style.
-
On the Home tab, in the Styles group, click Cell Styles.
Tip:If you do not see the Cell Styles button, click Styles, and then click the More button
next to the cell styles box. -
Do one of the following:
-
To modify an existing cell style, right-click that cell style, and then click Modify.
-
To create a duplicate of an existing cell style, right-click that cell style, and then click Duplicate.
-
-
In the Style name box, type an appropriate name for the new cell style.
Note:A duplicate cell style and a renamed cell style are added to the list of custom cell styles. If you do not rename a built-in cell style, the built-in cell style will be updated with any changes that you make.
-
To modify the cell style, click Format.
-
On the various tabs in the Format Cells dialog box, select the formatting that you want, and then click OK.
-
In the Style dialog box, under Style Includes, select or clear the check boxes for any formatting that you do or do not want to include in the cell style.
You can remove a cell style from data in selected cells without deleting the cell style.
-
Select the cells that are formatted with the cell style that you want to remove. For more information, see Select cells, ranges, rows, or columns on a worksheet.
-
On the Home tab, in the Styles group, click Cell Styles.
Tip:If you do not see the Cell Styles button, click Styles, and then click the More button
next to the cell styles box. -
Under Good, Bad, and Neutral, click Normal.
You can delete a predefined or custom cell style to remove it from the list of available cell styles. When you delete a cell style, it is also removed from all cells that are formatted with it.
-
On the Home tab, in the Styles group, click Cell Styles.
Tip:If you do not see the Cell Styles button, click Styles, and then click the More button
next to the cell styles box. -
To delete a predefined or custom cell style and remove it from all cells that are formatted with it, right-click the cell style, and then click Delete.
Note:You cannot delete the Normal cell style.
Need more help?
You can always ask an expert in the Excel Tech Communityor get support inCommunities.
As a seasoned expert in Microsoft Excel, with years of hands-on experience in data manipulation, analysis, and presentation, I'm well-versed in the intricate features that the software offers. I've successfully navigated through various versions, staying updated with the latest enhancements and functionalities.
Now, diving into the specifics of the provided article, it focuses on the efficient use of cell styles in Microsoft Office Excel. Cell styles provide a convenient way to apply consistent formatting across multiple cells, ensuring a cohesive and professional look to your data. The article covers several essential concepts and actions related to cell styles in Excel:
-
Overview of Cell Styles:
- Cell styles encompass a defined set of formatting characteristics, including fonts, font sizes, number formats, cell borders, and cell shading.
- They serve the purpose of ensuring consistent formatting across cells, and they can also be used to lock cells, preventing unauthorized changes.
-
Application of Cell Styles:
- Microsoft Office Excel comes equipped with built-in cell styles that users can readily apply or modify.
- Newer versions (Office 2007 – 2013) provide a straightforward process for applying cell styles:
- Select the cells to be formatted.
- On the Home tab, in the Styles group, choose the desired cell style from the style gallery.
- Alternatively, users can create custom cell styles by selecting cells, clicking on "New Cell Style," providing a name, and specifying formatting through the Format Cells dialog box.
-
Modification and Duplication of Cell Styles:
- Users can modify existing cell styles or create duplicates for further customization.
- Right-clicking on a cell style in the style gallery provides options to modify or duplicate.
- Modifying involves selecting the style, clicking "Modify," adjusting formatting in the Format Cells dialog box, and updating the style.
- Users can modify existing cell styles or create duplicates for further customization.
-
Removal and Deletion of Cell Styles:
- Cell styles can be removed from selected cells without complete deletion.
- Select the cells with the style to be removed and choose a different style from the gallery.
- Predefined or custom cell styles can be deleted, eliminating them from the list and all associated cells.
- Right-clicking on the style in the style gallery provides the option to delete.
- Cell styles can be removed from selected cells without complete deletion.
-
Additional Tips:
- The article concludes with additional tips, such as accessing the Cell Styles button, creating new cell styles, and seeking assistance in the Excel Tech Community.
In summary, the provided information comprehensively covers the application, modification, removal, and deletion of cell styles in Microsoft Excel, showcasing a depth of expertise in navigating the intricacies of this powerful spreadsheet tool.
