Do you know how we can convert a number into the fraction format?There are two available methods to set fraction format in WPS Spreadsheet. First, select the range of the table, head to the Home tab, find the setting button in the shortcut menu, and set the Fraction format.Alternatively, we can select the desired range of cells, and right-click Format cells, whose shortcut key is Ctrl+1.Locate Fraction in the category list, and choose from different types of fractions in the Type area....

Do you know how to quickly indent the beginning of a paragraph, or start a numbering list, or select one of the overlapping layers? The Tab key will help you make it.Now I'll introduce you to five common uses of the Tab key.· IndentationWhen writing an article, a novice user usually indents the beginning of a paragraph by 4 characters by pressing the space key, but it's too troublesome.Actually, we only need to press the Tab key, and it will be indented by four characters autom....

This video introduces the basic editing operations of the table, mainly including data input in alternate rows and columns, the insertion, deletion, hiding and unhiding of rows and columns. Many beginners use the mouse to click on a cell and then enter the content when entering data. Here is a quick way to teach you how to do this. After entering the first data, press the Enter key to input data in alternate rows. Press the Tab key to input data in alternate columns. We can also click ....

We often use the automatic numbering function when editing documents, which can enrich the structure of the document and make it easier to read. How can we use this function? Take this catalog as an example. Select the content that needs to be numbered, click the Numbering drop-down button on the Home tab, and choose the style we want. To get more styles, we can click More Numbering on the Numbering drop-down button. A dialog box will pop up at this time. After selecting any of the st....

When printing, in order to make the table meet the expected layout, we need to adjust the margins of the table.Margins are the white space between the contents of the spreadsheet and the edge of the printed page.Get into the Page Layout tab, and click Margins. Then we can see WPS has provided three default styles.Meanwhile, we can also choose Custom margins to adjust the margins more accurately.Click on the text box. Then the sample image in the middle will also provides a correspondin....

The inserted text in a table may be limited by cells. At this time, the text box can become your first choice to beautify your texts. It is rather simple to insert a text box. Click the Insert tab, then select the Text Box drop-down button.You can choose Horizontal Text Box and Vertical Text Box, and the difference lies in the arrangement direction for text. You can benefit from two sides.First, the text box can be dragged at your will. For example, there are multiple paragraphs of tex....

How can users quickly enter information in the table according to standard content? Drop-down list can help us to do that. Take this table as an example. Now we need to perfect the data in the “Gender” column. We can easily do that by using the drop-down list. 1. First, select the C2: C16 cell range.2. Then click the Insert Drop-Down List button in the Data tab. 3. We can select the Add choices drop down manually button in the popup dialog box and enter Male in the text box below. 4. T....

When we edit a long article, we need to adjust the structure of the article. For example, we need to move parts of the content and quickly change the heading level. But, scrolling and searching page by page is time-consuming. At this point, we can switch to the outline view mode.Go to the View tab, and click the Outline button to switch to the outline view mode. First, I will show you what is displayed on the page in this view mode.1. In the ribbon above, we can adjust the level of the....