How to set the cell style

Uploaded time: 2021-08-31 Difficulty: Primary

How to set the cell style

How to set the cell style

Graphic skills

When we beautify the spreadsheet, we usually use the Fill Color function to color the cells in a spreadsheet before setting the typeface, font size for the text, etc. However, it is not efficient. Is there any better ways to realize it?

1. Select the cell area that needs to be beautified.
2. Click Cell Style in the Home tab.

By doing so, a variety of predefined styles for cells has been provided by WPS Spreadsheet. Then we can choose one of the styles.

GIF.gif

 

If you don't like any of these styles, you can also customize the spreadsheet style.

1. Click New Cell Style, and the Style dialog box will pop up.

2. Click Format. Then you can set options In the pop-up Format Cells dialog box, including font, format, patterns, border, etc.

GIF_1.gif


Name the style, and click Confirm to generate a customized style. (Tips: If you want to modify the predefined style, right-click on the corresponding style, and choose Modify from the popup menu.)

GIF_2.gif


If you want to use the new cell style in other workbooks, you can use the Merge Styles function in this new created worksheet.

1. Click Cell Style in the Home tab.

2. Choose Merge Styles.

3. In the pop-up Merge Styles dialog box, choose the workbook that you want to copy styles into the Merge style from box

4. Click OK.

In this way, we can copy the custom styles of other workbooks. For all, easy our work with WPS Spreadsheet like Microsoft Excel.

GIF_3.gif