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

COUNTIF is a statistical function. It is often used to count the number of cells that meet the criteria. This function can not only count numbers and text but also can count expressions. So how can we use this function? The grammatical structure of the COUNTIF function is: COUNTIF(Range, Criteria)Range is the cell range that meets the criteria.Criteria are the conditions that need to be counted.Now we have a table that records everyone's afternoon tea order information. Column B co....

Do you know how to virtualize data with the Conditional Formatting function? The worksheet presents the data of 'Likes to views ratios'. Today's tutorial will take this sheet as an example for data virtualising. Select the cell range B2:B10. Go to Home and click Conditional Formatting. Next, choose Data Bars and then the red Gradient Fill option. After that, we can see the data virtualized with red bars.Although the data in cell B13 is 66.42%, as we can see, the data bar fi....

When using WPS Spreadsheet to create tables, we may want some of the cells in the table to have borders and some without borders. To do this, we can use the Draw Border functions to customize the drawing of cell borders, which could be also used in Microsoft Office Excel and Openoffice. Take this table as an example. 1. Click the Home tab. 2. Click the Draw Border drop-down button. 3. Select the Draw Border option in the drop-down menu. The mouse cursor will turn into a brush style. 4.....

When using WPS Spreadsheets to process data, it is convenient to use the SUMPRODUCT function to multiply data and then sum the results that we get. The spreadsheet for demonstration records sales amounts and prices of clothes in different cities. What can we do for a quick calculation of the total sales in all cities? The SUMPRODUCT function can realize it. This video could be also used in Microsoft Office Excel and Openoffice. Place the cursor in cell F5. Then, click Insert Formula i....

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

How can we change the paper orientation for printing in WPS Writer? This video can help us and it can be also used in Microsoft Office Word and Openoffice. Take this word document as an example. 1. Get into the Page Layout tab, where we can find the Orientation and Size buttons.2. Click the Orientation button. Then, we can choose either Portrait or Landscape as the page orientation.3. Click the Size button. Then we can see several default styles of paper sizes provided by WPS Office. I....

WPS Spreadsheet could be an alternative to Microsoft Office Excel. Includes 100's of built-in formulas, pivot tables and more. Includes advanced animation, slide transitions, and support for video, images, audio and even Flash.In the last chapter, we focus on the contents related to the page setting and printout of spreadsheets, and we often encounter various problems when printing, among which four FAQs will be introduced here. · 1: My form is incomplete. What can I do?Click the ....