How to use Style in Excel

With MS Excel data often has the same format in the same group. Therefore, to save time and ensure consistency in data format helps readers have a better overview of the following article on how to use Style in Excel.

1. Apply the Style formats available in Excel.

For example, you need to format the table header.

How to use Style in Excel Picture 1

Click on the cell you want to format -> Home -> Cell Styles -> choose the format you want:

How to use Style in Excel Picture 2

How to use Style in Excel Picture 3

2. Create your own style as you like.

Step 1: Go to the Home tab -> Cell Styles -> New Cell Style . to create your own Style :

How to use Style in Excel Picture 4

Step 2: The Style dialog box appears and gives the Style name in Style Name -> check  the box for numbers, margins, fonts, borders and colors. In addition, to select other formats, click Format:

How to use Style in Excel Picture 5

Step 3: The Format Cells dialog box appears, select the cards corresponding to the formats -> finally click OK:

How to use Style in Excel Picture 6

Step 4: Finally, click OK to close the Style dialog box :

How to use Style in Excel Picture 7

Step 5: Go back to the Excel file -> Home -> Cell Styles -> select the Style corresponding to the Style just created, the example here is Excel_Fast:

How to use Style in Excel Picture 8

Results after selecting your own custom Style :

How to use Style in Excel Picture 9

Above is a detailed guide on how to use Style in Excel. Good luck!