In practical work, we often need to enter the date in the spreadsheet. There are many data format types, so how do we set the date formats as we need? Take this spreadsheet as an example. Select the spreadsheet area, right-click the mouse, and select Format Cells from the shortcut menu. The shortcut key is Ctrl+1. In the pop-up Format Cells dialog box, select Date. There are many date formats in Type. We can choose the Wednesday date format, its abbreviated format, or the date format o....

We often need use the Split Book function so that we can split a workbook into multiple files at work. Take this workbook as an example, which is a table of goods sales from January to September. Now we want to split it into three workbook files. 1. Head to the Home tab, click the Split Sheet drop-down button，and select Split Book.2. In the pop-up dialog, the current file is checked by default, and you can also split other files by clicking Add more files.3. When finished, click Next t....

When inputting text in WPS Presentation, we find the text is horizontal by default. To make a slide more elegant, we can use the Text Direction function to change its layout. · Text DirectionTake the first slide of this presentation as an example. Here is a horizontal text. 1. Click the text to jump to the Text Tools tab, click the Text Direction drop-down button, and we can select Vertical.For a presentation document, text and text boxes are inseparable and interactional, so we can m....

The INDEX function can look up a value regarding its row and column numbers.There are two forms of the INDEX function, the Array form and the Reference form. · One: Array formWe'll use the Array form to return the value located in the seventh row and the fourth column.First, select cell J6. Next, click Formulas and then Insert Function to insert the INDEX function. The function syntax:INDEX(array,row_num,column_num)The first parameter, 'Array', refers to the array for valu....

Take this table as an example. When creating a table, we often need to use the Slash Header to display the title name, so how can we make a Slash Header?1. Select cell A1, right-click.2. Then select Format Cells in the popup shortcut menu. We can also use the shortcut key Ctrl+1.3. Then select Border in the Format Cells dialog box.4. Now select the slash shape icon in the border preview area, and click OK. 5. Now enter Subject in cell A1.6. Press Alt+Enter to insert a line break, and t....

After inserting the picture in the document, how can we set the text wrapping style? Take the word document as an example. This video could be also used in Microsoft Office Word and Openoffice. After clicking the picture, click the Wrap Text button in the floating toolbar to the right of the picture. We can choose a variety of text wrapping styles here. Click View more, and the Layout dialog box will pop up, which allows us to set the wrapping style more accurately.In the Text Wrapping....