Jinshan WPS table cell format how to set

Source: Internet
Author: User
Tags word wrap

In today's Jinshan WPS table using the tutorial, we will share the format of the cell formatting methods. In general, we will center the cell, word wrap, and other commonly used settings, but in addition, we can also change the color of the cell text, in the cell to add a slash table first. Want to know more about the Jinshan WPS table cell format to set the way, let's take a look at today's tutorial!

Jinshan WPS table cell Format Setup Tutorial content Introduction:

1. The setting of multiple colors of the cell.

2. The setting of the cell slash header.

3. How to insert special symbols.

How to set the color of a cell

The following is an example of a cell in Figure 1 that shows how to make multiple color settings on its contents. The specific steps are as follows:

Cell source data

Step 1: Select the WPS Office 2005 text in cell A1, select the format | Set cell Format menu item, and in the Format Cells dialog box, set the value in the Color option to blue.

Step 2: Click "OK" button to complete the setup. Use the same method to set the "knowledge point" in cell A1 to red. A1 the cell multiple color settings are complete, as shown in Figure 2.

Multi-color Setting results

setting of cell Slash header

Users often need to make a slash header in a wps table, and it's always a hassle for users to make such a table head before.

WPS Table currently offers 2 ways to set Slash headers:

Method 1: Set the slash header by the "Up and down" way.

Method 2: Set the slash header by using the key-line wrapping method.

Up and down standard way

Step 1: First, the "Knowledge point" to the superscript set. Select "Knowledge points", select the format | Set cell Format menu item, and in the Format Cells dialog box, tick the Superscript check box in the featured Effects option. As shown in Figure 4.

Click "OK" button, "Knowledge point" text set to superscript format.

Step 2: Use the same method for subscript setting for "ordinal". The data in the A1 cell becomes the effect shown in Figure 5.

Step 3: Select A1 cell, select the Format | cell menu item, select the Borders tab in the Format Cells dialog box, and slash the border formatting.

Manual line-Wrapping Input Method

Step 1: Implement the effect of a branch in a cell. First enter the "Knowledge point" in the cell, press the key combination, the cursor goes to the next line, then enter "serial number", and then add the appropriate space before the "knowledge point".

Step 2: Step 3 of the same way 1.

Step 3: Click on the "OK" button, slash head set to complete, the effect is shown in Figure 3.

How do i insert a special symbol

In the actual work, the user needs to enter some special symbols in the cell, the WPS table provides the very practical special symbolic input function. The following is an example of entering "√" in a cell.

Step 1: Position the cursor in brackets in front of "wonderful", select the Insert | symbol menu item, select the Symbol tab in the Symbol dialog box, set the value in the Subset Drop-down list to mathematical operator, and then select the √ symbol in the list of symbols. As shown in Figure 7.

Selection of special symbols

Step 2: Click the "Insert" button, and then click the "Close" button to close the Symbol dialog box, the symbol has been inserted in the desired location. As shown in Figure 8.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.