Use the fill handle to quickly enter data

AutoFill can help us quickly enter some regular data, which is an essential skill in using WPS Spreadsheet to deal with different data. It includes Fill Numerical Value, Fills Data, Fill Text, Custom Text Filling, and Fill Formulas.Take this table as an example. If we want to fill in the numbers 1 to 10 in column A, select cell A2 and move the cursor to the lower right corner of cell A2. At this time, the cursor will turn into a small black solid cross. Press and hold the left mouse bu....

How to insert a table in WPS Presentation

When creating a presentation in WPS Office, sometimes we need to insert a table for data demonstration. How can we realize it? Take this PowerPoint as an example. Get into the Insert tab and click the Table dropdown menu. Then drag the cursor to decide the table size. This method allows us to create a table with 10 columns and 10 rows at maximum. If we want to insert a bigger table, choose Insert Table. In the Insert Table dialog, we can decide the numbers of columns and rows. Enter t....

Adjust shape fill in WPS Presentation

When using WPS Presentation to create a presentation, sometimes we need to insert shapes to assist with the presentation and beautify the slides. We will be the amazing reporter with WPS Presentation, which could alternative to Microsoft powerpoint. How can we change the design of shape fill and outline? Left-click the inserted shape, and get into the Drawing Tools tab. Then click the Shape Fill button. There are two options. One is to choose the default style provided by WPS Office,....

How to set up a slideshow in WPS Presentation

Before we preview or make a presentation with slides, we should set up the slideshow in advance. So, how are we going to set it? Take these slides as an example. We first need to click the Slide Show tab at the top and then click the Set Up Show drop-down button. Here, we can set the slideshow as Manual or Auto.If we want to customize the slideshow settings, click the Set Up Show button. In the popup Set Up Show dialog box, we can also set the show type, multiple monitors, etc... In Sh....

How to set header and footer in WPS Presentation

When using WPS Presentation, we sometimes add a header and/or a footer to make the slides look more professional. How can we realize it? In this example, get into the Insert tab, and click the Header and Footer button. Then, we will see the two tabs of Slide and the Notes and Handout in the Header/Footer dialog. · The Slide tabHere we can insert the date and time, footer, and page number in the footer, which are respectively positioned in the bottom-left, -middle, and -right areas of t....

How to extract and replace the page content of a PDF file

When we are editing a PDF file, what should we do if we want to extract and replace several pages of the content?We can use the Extract Page and Replace pages functions of WPS Premium. If we want to extract the third page of this file and save it separately as a PDF file, click the Page tab, click Extract Page. In the Extract Mode box, select Extract selected page to PDF. In Page range, enter 3.We can add a watermark to the file, and we can also name the newly output file and set the s....

Use the ROW function in WPS Spreadsheets for row numbering

When using WPS Spreadsheets to process data, how can we deal with the worksheets without numbering or those with disordered numbers? Are there any convenient ways to number the rows while the numbers are not supposed to get disordered when certain rows are removed? The ROW function can realize it. The complete ROW formula is =ROW([Reference]). Here Reference can refer to a single cell, a cell range, or nothing. Here is the introduction to the two options of using the ROW function. · O....

Layout skill-How can we split columns

When using WPS Writer to create a layout in Word, we sometimes may want to split the content into two columns. So how are we going to make it? First click the upper tab Page Layout and click Columns. At this time, you can directly select whether you want to spilt the content into one column (One), two columns (Two), or three columns (Three).If you need to customize the column settings, just click More Columns to view more detailed options. There are five column styles in Preset, namely....