Your browser version is outdated.
To browse WPS Academy normally, we recommend you to upgrade to the latest version of Internet Explorer or try other browsers.
chrome
Chrome
firefox
Firefox
WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
      • Home
      • Popular
      • how do i add dropbox folder to my computer

      13 results for how do i add dropbox folder to my computer

      • All Tutorials
      • Video Tutorials
      • Quick Tutorials
      • All
      • Spreadsheet
      • Presentation
      • Writer
      • PDF

      13 results for how do i add dropbox folder to my computer

      How to download pictures in batches in WPS Writer

      How to download pictures in batches in WPS Writer

      01:04

      How to download pictures in batches in WPS Writer

      When editing a document, we sometimes insert a lot of pictures. We usually back up images in case they get lost.Then, do you know how to download an package of images at a time? For example, in this document, many pictures are inserted into the document, and it is a waste of time to save them one by one. Here I'm going to introduce you a very simple skill. Click the Menu button in the upper left corner, and click the Save as the button to pop up the dialog box.In File Type, select ....

      Writer 5 views
      Set Allow Users to Edit Ranges in a protected sheet

      Set Allow Users to Edit Ranges in a protected sheet

      02:04

      Set Allow Users to Edit Ranges in a protected sheet

      As we all know, we can protect the sheet by setting a password. So, can we divide this table into several ranges and set up separate passwords for each range? The answer is yes. Take this table as an example. This is a student grade table, and we need to set different passwords for each of the three ranges in the table so that the three ranges do not affect each other. Next, I will show you how to do that.Click the Review tab and the Allow Users to Edit Ranges button, and click New. In....

      Spreadsheet 62 views
      Page setup and print-out for spreadsheets

      Page setup and print-out for spreadsheets

      02:07

      Page setup and print-out for spreadsheets

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

      Spreadsheet 126 views
      How to set the line numbers in WPS Writer

      How to set the line numbers in WPS Writer

      01:56

      How to set the line numbers in WPS Writer

      The usage of Line Numbers in long documents can help readers quickly find specific lines. So, how can we add line numbers? Next, I will show you the effects of setting different line number types: 1. Click the Page Layout tab and the Line Numbers drop-down button. We can see that there are different settings in the list. We can choose the Continuous Reading option to add line numbers to the entire document. 2. Choose Restart Each Page to start with number 1 on each page. 3. Choose Res....

      Writer 782 views
      Content layout basics

      Content layout basics

      02:20

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

      Spreadsheet 79 views
      Why error message #NULL! occurs and how to solve it

      Why error message #NULL! occurs and how to solve it

      01:51

      Why error message #NULL! occurs and how to solve it

      You may not know what to do if the error message "#NULL!" occurs when carrying out calculations in a table. Today, I'll talk about why the error message #NULL! occurs and how to solve it. In general, the error message "#NULL!" is caused by the lack of the reference operator in references, resulting in an empty range of references. · The formula references continuous cell range without the correct reference operator.Take this table as an example. If we want to sum up the company'....

      Spreadsheet 4 views
      Set the Table Header and Footer

      Set the Table Header and Footer

      02:10

      Set the Table Header and Footer

      In our actual work, we sometimes need to add information such as time, page number and logo in the header and footer of each page to make it more normative. So how do we set the table header and footer? In this table, we have set up the table print area. Click the Print Header and Footer button on the Print Preview tab, and in the pop-up dialog, we can set the header and footer. WPS Office has built in some basic styles, but if we need more, click the Custom Header button.There are thr....

      Spreadsheet 85 views
      How to create a scatter chart in WPS Spreadsheet

      How to create a scatter chart in WPS Spreadsheet

      02:53

      How to create a scatter chart in WPS Spreadsheet

      A scatter chart in WPS Spreadsheet is normally called an X-Y graph. It presents all the data as points on rectangular coordinates, showing the relationships between variables. The scatter plot is a great graphical tool that we often use for statistical modelling. Take this table as an example. This is a set of height and weight data of boys and girls. If we want to observe the relationship between the two variables: height and weight, with the help of a scatter chart, how can we do tha....

      Spreadsheet 235 views
      Prev 12 Next
      WPS Academy