415 results for how to make an excel file read only
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
415 results for how to make an excel file read only
Set password to protect privacy in WPS spreadsheet
02:03Set 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....
How to insert attachments in WPS Writer
01:11How 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....
How to use the Review feature
01:38How 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....
Refresh pivotTable and change data source
01:28Refresh 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 ....
How to view two sheets side by side
01:09How 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....
Edit settings in WPS Spreadsheet
03:47Edit 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....
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....
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....