WPS Spreadsheet basic editing

This video introduces the basic editing operations of the table, mainly including data input in alternate rows and columns, the insertion, deletion, hiding and unhiding of rows and columns. Many beginners use the mouse to click on a cell and then enter the content when entering data. Here is a quick way to teach you how to do this. After entering the first data, press the Enter key to input data in alternate rows. Press the Tab key to input data in alternate columns. We can also click ....

Basic settings on footer and header

When we are editing documents, we sometimes need to add additional information such as company name, logo, date, etc. in the header and footer. The additional information ensures the integrity of the document. This video of Basic settings on footer and header could be also used in Microsoft Office Word and Openoffice. Steps:Take this document as an example. 1. Click the Insert tab, and then the Header and Footer button in turn. 2. Click the header text box, and enter “Kingsoft Office”....

Get to Know the PDF Print Interface

We often need to print PDF files at work, so let's get to know the PDF Print Interface.Take this PDF file as an example. Click Menu and then click Print to get a dialog.The interface is divided into five sections: Basic Setting, Page Range, Print Handling, Page Setup and Content Settings. · Basic Setting In the Basic Setting area, we can select a printer, enter copies and check Print in Grayscale.Print in Grayscale refers to the technical process of printing color contents into dif....

How to insert shapes in WPS Presentation

Shapes inserted in slides could make a presentation more attractive. How can we insert shapes in a presentation document? First, click the Insert tab, and click the Shapes button. In the selection list, we can see that there are different categories, namely Lines, Rectangles, and Basic Shapes, Block Arrows, Equation Shapes, Flowchart, Stars and Banners, Callouts, and an Action button. Here we take the shape of Heart, which could be found in the Basic Shapes drop-down list. Insert it by....

Create a countdown calendar & Insert current time and date

WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently. Today, we are going to introduce basic usages of three commonly used date functions. They are namely the TODAY function, NOW function, and DATEDIF function. We can use the date function to insert the current date and time quickly. Also, we can use this function to update it in real-time. We can also make a countdown calendar with it. · ....

How can we crop pictures in WPS Writer

We often insert pictures when editing documents, If we want to crop the picture, what should we do? After clicking the picture in the document, we can click the Crop drop-down button under the Picture Tools tab. We can choose Crop by Shape or Crop by Scale in the selection list.If we want to crop the picture into an oval, click Oval in the Basic Shapes selection list, and an oval will appear in the picture. The shaded part is the part that is cropped. There are four small black lines i....

More features in Document Encryption

Both WPS Spreadsheets and Microsoft Excel have the function of document encryption. For users' actual needs, WPS Spreadsheets additionally provide two practical features: Encryption at different levels and Password hints. In Microsoft, two methods are available for document encryption.Method 1Click the "Protect Workbook" drop-down button in the "Info" interface and select "Encrypt with Password." We can only set a password for the excel document in the pop-up dialog but not make it....

Content layout basics

After we have entered the data, we need to make some basic content layout adjustments to make our table look clearer and more beautiful.How should we do it? Next, I'm going to do this in five steps. · 1. Add serial numberThe first column of a table usually adds a serial number to make the contents of the table easier to see. Take this table as an example. Select column A, right-click, choose the Insert option to insert a new column in front of the selected column and enter Serial n....