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!
You should read it
- How to delete styles, delete styles, delete stubborn formating styles in Excel
- How to use underline styles in Excel
- How to delete table format in Excel
- MS Word - Lesson 7: Styles
- How to copy styles between 2 Word files (Import, import styles from the old word file to the new file)
- How to create and use styles in Word 2016
- How to draw charts in Excel
- Microsoft Excel test P5
- Get started with Excel for beginners
- How to fix the insertion block in Excel
- Tips for adding in Excel you need to know
- How to disable Hyperlink in Excel
May be interested
How to hide and show the Ribbon toolbar in Word and Excel
How to align text between cells in Word and Excel
Restore default settings in Word, Excel
How to turn pages quickly in Word
How to turn off spell checking in Word, Powerpoint (remove the red underline in Word)
How to color cells, background colors for tables in Word