1. Learned the basic operation interface of WPS Spreadsheet.2. What is the difference between a workbook and a worksheet?3. know the table rows and columns, how to correctly adjust the row height column width?4. What is a cell, what is the cell area, how do we quickly locate the specified cell or cell area?

WPS is an Office Software developed by Kingsoft. This video is going to introduce WPS to you. Before you start watching, remember to download the latest WPS Office Suite from our official website. After we download, open WPS. Then we will come to the workbench interface. Click the + icon in the upper left corner. We can choose to create a new document, table, slides, or PDF in the menu bar. Here, we want to create a spreadsheet, so we select Spreadsheet. Then we can see a Blank button ....

The function of action settings in WPS Presentation allows us to set actions for graphic images and content text in slides. We will be the amazing reporter with WPS Presentation, which could alternative to Microsoft powerpoint. So, how can we use this function? Take the slides as an example. First, select the picture, click the Insert tab above, and then click Action Settings. There are two ways to trigger the action, namely mouse click and mouse over, we can choose an option according....

When using WPS Office to print various files, we often encounter different small problems. This video will briefly explain the function of each small feature of the printing interface, and it could be compatible with Microsoft Office powerpoint. If you want to learn more printing skills, you can search printing in our WPS Academy to enjoy more related videos. Take this slide as an example. First, we need to determine that the printer hardware can work properly and is now running. We al....

Arrange tools in WPS Presentation allow users to adjust the object layout, group objects, and rotate objects. The Arrange tools make it easier to manipulate images, shapes, and other elements. Usually, the latest created object is placed at the front of a slide.If we want to change the object layouts, here are the steps.1. Choose an object.2. Go to Home and click Arrange. 3. Choose Bring to Front in the drop-down menu. Another option to realize it is shown below.1. Select the object.2.....

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. Today, we will learn Editing settings in WPS Spreadsheet. A personalized editing style will make the table easier to edit and read. First, click Menu in the upper left corner of the table, select Options, and click Edit in the pop-up dialog box to get into the Edit Settings interface. Here I will elaborate on how the functions of Edit Settings can be put int....

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

Do you want to layout your articles more efficiently? WPS Office provides us with a useful and practical function: the Word Typesetting function. Navigate to the Home tab, and click the Word Typesetting drop-down button. Then we can see a lot of text typesetting functions.Tips: you can turn on the Show/Hide Paragraph Marks button for subsequent operations.l Insert blank paragraphs In this document, for example, there is no space between paragraphs, which looks dense and does not fit th....