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
      • excel lock

      377 results for excel lock

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

      377 results for excel lock

      How to lock and unlock cells in WPS Spreadsheet

      How to lock and unlock cells in WPS Spreadsheet

      01:35

      How to lock and unlock cells in WPS Spreadsheet

      If you have a worksheet for others to fill in, while you don't want certain important data to be modified, the Protect sheet function in WPS Spreadsheet can help you. To lock the entire sheet, get into the Review tab first. If you see the Lock Cell button grayed out, it means that the entire sheet has been locked by default.Next, click the Protect Sheet button, set the password, and click Confirm the setting. Then the sheet formally enters a locked state, and the sheet cannot be ed....

      Spreadsheet 2,183 views
      How to convert Excel to PDF

      How to convert Excel to PDF

      02:50

      How to convert Excel to PDF

      PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

      Spreadsheet 287 views

      How to lock cells in Excel

      1. Go to the Review tab.2. The Lock Cell button is grayed out, which means that the entire sheet has been locked by default.3. Click the Protect Sheet button, then a dialog will pop up.4. In the Allow all users of this worksheet to area, Select locked cells and Select unlocked cells these two options have been checked by default. (Note: Other options can be checked as needed.)5. We enter password in the Password (optional) box, and click the OK button.6. In the pop-up Confirm Password ....

      Spreadsheet 569 views
      How can we protect a worksheet in WPS Spreadsheets

      How can we protect a worksheet in WPS Spreadsheets

      01:49

      How can we protect a worksheet in WPS Spreadsheets

      Do you know how to lock cells in WPS Spreadsheet so that they cannot be modified by others? Take this table as an example. 1. Click the Review tab. 2. When finding that the Lock Cell button is gray, it means that the entire table is now locked. At this point, click Protect Sheet. 3. Check the Select Locked cells and Select Unlocked Cells options in the pop-up dialog box. 4. Enter a password and click OK to confirm. Then we will find that the form cannot be edited.What needs to be aware....

      Spreadsheet 449 views

      How to lock columns and rows in a table

      1. Use WPS Office to open the table.2. Click the Review tab → and then click the Lock Cell button.3. Now click the Protect Sheet button, then the Protect Sheet box will pop up. Uncheck Insert Columns and Insert Rows.4. Now we will find it impossible to insert rows and columns in this table.This skill could be also used in Microsoft Office Excel and Openoffice.

      Spreadsheet 1,001 views

      How to lock cells in WPS Spreadsheet

      1. Use WPS Office to open or create a new table, then select the operated cells.2. Click the Review tab → click the Lock Cell button in turn.(Note: Only if the worksheet is protected, the Lock Cell feature can protect data from being modified.) 3. Click Protect Worksheet. Then the Protect Sheet dialog box will pop up.4. Set a password according to our needs in the Protect Worksheet popup box, and check Select locked cells and Select unlocked cells.5. Finally, click OK. (Note: We can al....

      Spreadsheet 2,255 views
      Use Validation to restrict data change

      Use Validation to restrict data change

      02:24

      Use Validation to restrict data change

      We want to lock the cells after checking the table data and prevent it from being further changed. What can we do?In today's tutorial, you will learn how to use the Validation function to restrict data change.Step one, select the E column, and then add a drop-down list named checked.Click Validation at Data, and you can also use the shortcut Alt+D+L.In the Setting tab, select List at Allow, and enter checked at Source. Finally, click OK.By doing so, we can select checked in the dro....

      Spreadsheet 4 views

      How to lock a PDF file from editing?

      1. Open your document in WPS PDF.2. Click the Protect tab > Encrypt.3. Check Set the password of editing and extracting, which protects this document from being edited and extracted. Then input the password, confirm the password and select the functions to encrypt as needed. Then click Confirm. 4. When someone need to edit it, he or she needs to input the password first. To be office specialists, you could learn how to use WPS Office online in WPS Academy.

      PDF 353 views
      Prev 123...4748 Next
      WPS Academy