Format Excel tables with cell styles

Formatting Excel spreadsheets gives them a more refined look and makes the data easier to read and interpret, making them more suitable for meetings and presentations. Excel has a set of preset formatting styles to add color to a worksheet that can take it to the next level.

These instructions apply to Excel 2019, 2016, 2013, 2010, and Excel for Office 365.

Contents
  1. What is a cell style?
  2. Copy a cell style to another workbook
  3. Remove cell style formatting

What is a cell style?

cell style in Excel, a combination of formatting options, including font sizes and colors, number formats, cell borders, and shading, that can be named and saved as part of a worksheet.

Excel has many built-in cell styles that you can apply as they are to your worksheet or change them to your liking. These built-in styles can also serve as the basis for custom cell styles that can be saved and shared in workbooks.

  1. Select cell range you want to format.

  2. On the tab At home ribbons click icon Cell Styles in section styles to open a gallery of available styles.

  3. Click the desired cell style to apply it.

One of the benefits of using styles is that if you change a cell style after you apply it to a worksheet, all cells that use that style are automatically updated to reflect the changes.

In addition, you can include the Excel Cell Lock function in cell styles to prevent unauthorized changes to certain cells, worksheets or workbooks.

You can also customize cell styles from scratch or use the built-in style as a starting point.

  1. Select leaf cell.

  2. Apply any settings you want for formatting to this cell.

  3. Press At home tab on the adhesive tape

  4. Click Cell Styles on the adhesive tape to open Cell Style Gallery

  5. Click New cell styles at the bottom of the gallery.

  6. enter your name for a new style in the box Style name

  7. For more options, click the button Format in the dialog box Style to open the dialog Format cells

  8. Press tab in the dialog box to view the available options.

  9. Apply any changes you want.

  10. Click Okay to return to the dialog box Style

  11. Below the name is a list of the formatting options you’ve chosen. Clear the boxes for unwanted formatting.

  12. Click Okay to close the dialog box and return to the worksheet.

The name of the new style is now displayed at the top Cell Style Galleries under the title Amended † To apply your style to cells in a worksheet, follow the steps above to use an inline style.

To change the cell formatting, run Cell Style Gallery And right click in cell style and choose Change Format † The right-click menu also contains an option Duplicate

Copy a cell style to another workbook

When you create a custom cell style in a workbook, it is not available in Excel. However, you can easily copy custom styles to other workbooks.

  1. Open first book The containing the custom style you want to copy.

  2. Open second book

  3. In second book go to tab At home on the adhesive tape

  4. Click Cell Styles on the adhesive tape to open gallery Cell Styles

  5. Click Merge Styles at the bottom of the gallery to open the dialog Merge Styles

  6. Click title of the first book

  7. Click Okay to close the dialog box.

will appear warning window asking if you want to merge styles with the same name. If both workbooks do not have custom styles with the same name but different formatting options, click Yes to complete the transfer to the destination workbook.

Remove cell style formatting

Finally, you can remove any formatting applied to a cell without deleting the data or the saved cell style. You can also delete a cell style if you no longer want to use it.

  1. Select cells that use the cell style you want to delete.

  2. On the tab ribbons Click Cell Styles to open gallery Cell styles.

  3. Sections Good Bad And Neutral on the top galleries Click normal remove all applied formatting.

The above steps can also be used to remove formatting manually applied to table cells.

You can remove all built-in and custom cell styles from the Cell Styles gallery, except “Normal”, which is the default. When a style is deleted, any cell in which it was used loses all associated formatting.

  1. On the tab tire click Cell Styles to open cell style gallery

  2. Right click on the cell style to open the context menu and select remove – the cell style will be removed from the gallery immediately.

Leave a Reply

Your email address will not be published.