WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


How to set the cell style

Uploaded time: August 31, 2021 Difficulty Beginner

How to set the cell style

How to set the cell style

When we beautify the spreadsheet, we usually use the Fill Colorfunction 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 waysto 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.

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 optionsIn the pop-up Format Cells dialog box, including font, format, patterns, border, etc.

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.)

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 theHome tab.

2. ChooseMerge 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.


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.