- All Tutorials
- Video Tutorials
- Quick Tutorials
423 Search results
Format painter: tips for unifying format01:11
Format painter: tips for unifying format
In the process of making a WPS Presentation slide, we will unify the format of the text content for aesthetic purposes. Today, let's learn some tips for unifying the format quickly. Take this slide as an example. We can see that the font, font size, and color are different between each text. We can simply select the text box in the first line, and click the Home tab, then click the Format Painter button. Move the cursor to the second text box that needs a unified format, and click ....
Cell formatting is very important in data processing. We often need to set a proper cell format when entering data in WPS Spreadsheet. Let's talk about the differences between each format. Take this table as an example. Most of the cells in column B of the table are in general format. General format cells have no specific number format, which are simply displayed as numbers. In this table, most of the Column B cells are in general format. The format of cell C2 is a numeric format.....
General format and special format01:27
General format and special format
When we use WPS Spreadsheet to enter data, we often need to convert between the general and the special format. So let's take a look at what is the general format of cells, what is the difference between them, and how we can convert them. Take this table as an example. The cell contents in the first row of this table are all in the General format. The General format means that the contents of the cells are simply expressed in numerical form. The second row of the table is in a spec....
Split the screen for data comparison01:21
Split the screen for data comparison
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. When we meet a situation where a large amount of data in the table can not be completely displayed in the window, we still want to see the contents from different positions at the same time. To solve this, using the Split window is probably the best idea. If you want to connect the total sales with Branch in a spreadsheet with massive data, dragging the....
Set the date format cells00:57
Set the date format cells
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....
Different methods of format painter02:12
Different methods of format painter
When we use WPS Spreadsheet at work, if we want to quickly copy the formatting of a cell to another cell, we can use the Format Painter function in WPS Spreadsheet. Take this table as an example. We now want to copy and paste the formatting of cell A1 to cell D1. 1. Select cell A1.2. Click the Home tab first and then click the Format Painter button.3. Now select cell D1. There you can copy and paste the formatting of cell A1 to cell D1. But how can we use Format Painter to copy and pa....
How can we insert endnotes for Documents01:26
How can we insert endnotes for Documents
Endnotes usually appear at the end of the text and are mostly used to cite sources. When writing a paper, we often need to add endnotes to supplement the specific text. Then how can we insert an endnote for documents? · Step 1Place the mouse cursor where you want to insert the endnote. Click the References tab first, then click Settings, and finally click Footnote/(and)Endnote. · Step 2In the Footnote/(and)Endnote dialog box, we can set the Location according to our needs. As for this ....
How to clear content format and comments for cells01:43
How to clear content format and comments for cells
When we use the WPS Spreadsheet to work, we sometimes need to clear the content of the table quickly. How can we realize it? This video could help to solve this problem. Take this transcript as an example. 1. To clear all contents within the table, select the area that needs to be cleared.2. Click the Clear dropdown button in the Home tab, and choose the All option to clear the table as needed. (Notes: We can also use the Clear function in this step. To realize it, select the area, and....