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
  • Home
  • Video Tutorials
    WPS Spreadsheet Data Entry and Editing Data Analysis Data Visualization Page Layout Review and Security More Functions and Formulas
    WPS Writer Text Writing Insert and Edit Page Layout Review and Security References More
    WPS Presentation View Insert and Edit Animation and Slide Show More Review and Security
    WPS PDF Multiple Editing Tools Insert More Add Comments Page Management File Format Conversion Print
  • Graphic Tutorials
    WPS Spreadsheet Data Entry and Editing Data Analysis Functions and Formulas Page Layout Review and Security More
    WPS Writer Text Writing Insert and Edit References Page Layout Review and Comments Security More
    WPS Presentation Insert and Edit Animation and Slide Show Premium Benefits More
    PDF Edit View Review and Comments Security Premium Benefits More
    WPS Basics Home Page Settings and Account Premium Benefits More
    Beginner Tutorial Preferences Settings Get Started Common Uses
  • Download
    WPS Office for Windows
    WPS Office for Mac
    WPS Office for Android
    WPS Office for iOS
    WPS Office for Linux
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

      • Home
      • Video Tutorials
      • Graphic Tutorials
      • Home
      • Popular
      • how to make an excel file read only

      415 results for how to make an excel file read only

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

      415 results for how to make an excel file read only

      Set password to protect privacy in WPS spreadsheet

      Set password to protect privacy in WPS spreadsheet

      02:03

      Set password to protect privacy in WPS spreadsheet

      WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Our spreadsheet can be encrypted to protect privacy. Security in the Options allows us to do so. Take this table as an example. We click Menu and select Options in the drop-down list. A dialogue box will pop up. Click Security, where we can find File encryption options for this workbook" and File sharing options for this workbook. If we want to encrypt....

      Spreadsheet 215 views
      How to insert attachments in WPS Writer

      How to insert attachments in WPS Writer

      01:11

      How to insert attachments in WPS Writer

      When editing a document, we sometimes need to add related attachments to explain more detail. At this time, we can use the Insert Attachment function to open the attachment in the original file directly. It can greatly improve our work efficiency. So how can we do that? Take this document on introduction to Monet's as an example. We can insert his work as an attachment at the end of the document. It can make it easier for people who read this document to understand Monet.1. Click t....

      Writer 392 views
      How to use the Review feature

      How to use the Review feature

      01:38

      How to use the Review feature

      If other people revise a document, we can use the review feature to view the revisions. Take this paper as an example. It is revised by two people.If we only want to read Miss Chan's comments, here are the steps. In the Review tab, click the Review drop-down button and click Reviewers. Check your desired reviewer.Then Miss Chan's comments are displayed on the right. Sometimes, a paper may go through multiple revisions and comments.If we only want to read the latest comments, we....

      Writer 71 views
      Refresh pivotTable and change data source

      Refresh pivotTable and change data source

      01:28

      Refresh pivotTable and change data source

      If we modified the data source after creating a PivotTable, how can we make the contents of the PivotTable change with the data source? Take this table as an example. We select cell F15 in Sheet1, and change Violin's Total sales to 800. Then we go back to Sheet2 only to find no change in the values of the PivotTable. At this time, we click the Option tab and click the Refresh button to refresh the PivotTable. If we are afraid of forgetting to refresh the data, click Options in the ....

      Spreadsheet 203 views
      How to view two sheets side by side

      How to view two sheets side by side

      01:09

      How to view two sheets side by side

      When checking data in WPS Spreadsheet, we frequently need to check and edit multiple sheets at the same time. We'll learn how to see two pages on the same screen today.· Step one: Create and view two sheets side by sideFirst, let's open an Excel file containing multiple worksheets. Click New window in the View tab. At this time, another identical Excel document window will appear. These two windows are presenting the same file. No matter which one is edited, the changes can be....

      Spreadsheet 68 views
      Edit settings in WPS Spreadsheet

      Edit settings in WPS Spreadsheet

      03:47

      Edit settings in WPS Spreadsheet

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

      Spreadsheet 257 views

      How to make an animated video in WPS Office PowerPoint

      Are you ready to master how to make an animated video in PowerPoint? After learning this WPS free tutorial, you will be advanced from a beginner in WPS Presentation. It would be very difficult for a novice to make videos with professional editing software. Don’t worry! WPS Presentation provides the Video Exporting function to help you make an animated video quickly and easily! Without further ado, let’s have a try step by step. · Step 1: Prepare for the animated video in WPS OfficeTo m....

      Presentation 430 views

      How to make an excellent student resume in WPS Office

      Are you stepping out into the professional world? Are you fretting about how to prepare your first resume? It seems a tough job for a fresh graduate to make a student resume, but fear not! WPS Office is here to offer the methods of sprucing up your resume. Designing and creating a student resume from scratch requires a series of professional skills, but WPS Office provides diverse resume templates for quick use.· Steps to make an excellent resume with templates for all students1. Ope....

      Writer 195 views
      Prev 123...5152 Next
      WPS Academy
      Products
      WPS Office for Windows
      WPS Office for Mac
      WPS Office for Android
      WPS Office for iOS
      WPS Office for Linux
      Affiliate Program
      Links
      OEM Partners
      Strategic partners
      Enterprise Sales
      Popular Searches
      Partners
      WPS Office for Windows
      WPS Office for Mac
      WPS Office for Android
      WPS Office for iOS
      WPS Office for Linux
      Affiliate Program
      Links
      OEM Partners
      Strategic partners
      Enterprise Sales
      Popular Searches