How to fill cells with pure colors, gradient colors, and patterns
Uploaded time: September 27, 2021 Difficulty Beginner
A free Office suite fully compatible with Microsoft Office
How to fill cells with pure colors, gradient colors, and patterns
How to fill cells with pure colors, gradient colors, and patterns
When using WPS Spreadsheet to write a statistical data report, we may want to emphasize the cell data. To do this, we can fill the cell with background color and pattern.
Take this table as an example.
1. If we want to fill the B3:G3 cell with color, select this area first.
2. Click the Home tab above.
3. Then click Settings.
· Pure color
· Gradient effect
In addition, we can also add a gradient effect to a cell selection.
1. Open the Format Cells dialog box and click Fill Effects. In this dialog box, we can set the gradient colors color 1 and color 2.
2. After determining the color, we can set the Shading styles and Variant of the gradient fill.
3. In the Sample area at the lower right corner, we can preview the gradient effect.
· Patterns
1. If we want to fill the cells B4:B15 with patterns.
2. Select this area and use the shortcut key Ctrl+1 to open the Formats Cells dialog box.
3. Then select a needed pattern in Pattern style, and then select Pattern color.
4. We can also preview the filling effect in the Sample area.
What a practical feature! Did you get it?
This skill could be also used in Microsoft Office Excel and Openoffice.
Trending Tutorials
Does this video help you?