How to enter the square and cubic symbols in a wps table

Source: Internet
Author: User

We often enter the square (superscript 2) and the cubic (superscript 3) when entering the area and volume. In Excel can be quickly entered (square: alt+178, Cubic: ALT + 179), but this method is currently in the WPS table can not be implemented, then love with WPS Friend is not able to input the square (superscript 2) and cubic (superscript 3)? Don't worry, there are ways to do it, and there are more than one.

Below, I take square meters and cubic meters as an example, these two methods are introduced to you.

I. Borrowing method

The stone of his mountain can attack Jade. We can use the Formula Editor to implement the Formula Editor online, after downloading installation, open the Formula editor, enter "M", click Superscript and Subscript template, select the right superscript, enter "2", so that the square meter symbol came out, and then copied to the WPS form (Figure 1)

Figure 1

Note that different formula editor actions may be different, and you can refer to the help instructions for the action, so the copied symbol is a graphic, which is edited with a drawing tool.

Second, Format setting method

In the cell, enter the square, cubic symbol, is actually a cell multiple format set. Cell multiple formatting means that you can set multiple formats for text in the same cell, including fonts, glyphs, font sizes, color, underline, special effects, and so on. It is worth mentioning that this feature is added to the WPS Form version 1151 (Professional Edition), version 1150 (Personal Edition). The specific actions are as follows:

When you enter "M" in cell A1, double-click Cell A1, at which point after "M", right-click, pop-up menu, and select Format cell (Figure 2)

Figure 2

Bring up the Cell Formatting Font dialog box, tick the superscript option under special effects, click OK (Figure 3)

Figure 3

Enter "2" after the cursor so that the square meter symbol is complete (Figure 4).

Figure 4 Finding the "0" value cell

Friendly reminder:

Format cells, select the text you want to format, or press the shortcut key ctrl+1 (press CTRL and 1 simultaneously), or click the Drop-down menu in the Format menu to format cell. This is the same name as "format cells" in the right-click menu after clicking the cell. However, unlike functions, the former can be formatted for text in the same cell, which can only be set to the same format; The first action is to double-click the cell or select the text you want to format. The latter clicks the cell. Multi-format cell can not only square, cubic symbol, but also to achieve a rich and colorful effect.

The second method is particularly recommended, and you only need to upgrade the WPS table to the appropriate version.

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.