Use color scales to make the temperature chart

The table shows the minimum temperature data of each month in a specific area. We can visually display the temperature changes through the color scale feature of the conditional formatting. We select the cell range B2:M2 and get into the Home tab. Click the Conditional Formatting drop-down button, and choose the Color Scales option. In the pop-up menu, we can select Red-White-Bule Color Scale.At this time, the selected table area will be marked with color. The higher the temperature, t....

Insert a table into the text & convert between text and table

When we use WPS Document at work, we often need to create a table in order to make the document more organized. But how are we going to make it? Take this blank document as an example. Click the upper tab Insert-Table. We can choose the corresponding number of rows and columns according to actual needs.For instance, if I want to make a table with 2 rows and 8 columns, just select 2*8 in the table area and click the left mouse button. You can also click Insert-Table-Insert Table. Then ....

Page background: adjust background color and set a picture as background

When we use WPS text, sometimes we need to set colors or backgrounds for the documents. How can we achieve it? To set the background to green, click Page Layout on the taskbar, and select Page Color. Then, choose a theme color as you want. For more color, you can also click on the More Color below to customize the desired color. How can we set the picture background for a document? 1. Click Page Layout on the upper taskbar.2. Find Background, and choose Picture Background.3. Then, you&....

How to convert PDF files into documents

We use powerful PDF in our daily life nearly every day.In our daily work, we often need to edit the file twice. If it involves large-scale changes, we can try the PDF to Word feature of WPS Premium. By using this, we can convert the text and pictures quickly in the PDF file into an editable document file.Take this PDF file as an example. Click the Home tab, and select PDF to Word in the PDF to Office drop-down menu. We can also click Tools. Then click the PDF to Word button to enter th....

Use Date function to convert date format

We may sometimes need to convert the format of the date in the table when using WPS Spreadsheet like Microsoft Excel. At this point, by using the Date function, we can quickly generate a specific date symbol. Take this table as an example. This table contains the information on the date of birth of some students in class. We can see that the information of year, month, and day are separated in this table. So how can we convert the format quickly to know the birthdays of the students? 1....

How to merge and split PDF files

WPS PDF could help edit PDF files and freely convert between PDF and Word, Excel, PowerPoint, and JPG files online. When editing PDF files, we often need to merge multiple PDF files or split a PDF file. So how can we do that?· Merge PagesTake this file as an example. When we need to merge multiple PDF files into one, click the Page tab, then click Merge Page. Now the WPS PDF to Word Converter dialog box will pop up. Click the Add files button in the upper right corner and select other ....

How to lock and unlock cells in WPS Spreadsheet

If you have a worksheet for others to fill in, while you don't want certain important data to be modified, the Protect sheet function in WPS Spreadsheet can help you. To lock the entire sheet, get into the Review tab first. If you see the Lock Cell button grayed out, it means that the entire sheet has been locked by default.Next, click the Protect Sheet button, set the password, and click Confirm the setting. Then the sheet formally enters a locked state, and the sheet cannot be ed....

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....