“Cell Styles”

The formatting of cells can take quite some time.
We can save a lot of time by using the “Cell Styles” command, which we find in the “Home” tab of the “Ribbon”.

A “Cell Style” is a set of formatting characteristics, such as background color, fonttype, fontsize, cell borders, etc.
Click the “Cell Styles” button to open the menu.
This command also has the option to Live Preview the “Cell Styles”.

Excel provides several predefined “Cell styles”, which are divided into 5 different groups from which we can choose a style.
To preview a style, select a range af cells, move your mouse pointer over a style.
To apply a style, slide your mouse pointer over the “Cell style” and click.

Custom cell style

To make a new “Cell style” click the “New Cell Style” button at the bottom of the “Cell styles” menu.

This opens the “Style” dialog window:

At the top of the dialog, in the field “Style name:” we give our style a name.

Under the name box we see the style applied to the selected cell in the worksheet.

 

Because I had a blank cell selected before I clicked the button “New Style”, all my formatting options are checked as default.

If you have already added certain style, this would be listed in the dialog.
Click the “Format” button to set them.
This opens the “Format Cells” dialog window.
In this dialog window we find 6 tabs, in which we can enter all our formatting options that we want to apply on our own cell style.
Enter your settings, click OK and OK again.

In the “Cell styles”, we see that this adds a new group: “Custom”.

Remove Custom cell

To remove a custom cell style, open “Cell styles” menu, right click the custom cell style that you wish to remove, and click “Delete” in the drop-down menu.

Modify Custom cell

To modify a custom cell style, open “Cell styles” menu, right click the custom cell style that you wish to change and select “Modify” from the drop-down menu.
This opens the “Style” dialog window, where you can change the settings.

Use Custom cell in another workbook

To use a custom cell style in another “Workbook”, we have to group them together.
Open the workbook containing the custom cell style.
Open or select the workbook where you want to use the custom cell style.
Open the “Cell styles” menu, and click the “Merge Styles…” button at the bottom.
Select “Merge Styles from” from the dialog box and it opens the workbook containing the custom cell style and click OK.
Now the custom cell style will be available in the “Cell Styles” in the new workbook .

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats