3 forbidden functions of Excel

php Xiaobian Yuzai tells you that Excel, as a powerful office software, has many practical functions, but there are also some functions that require special attention when using them. Today we will introduce three prohibited functions in Excel to prevent users from encountering unnecessary trouble when using them. We hope that through this article, users can become more proficient in using Excel and improve work efficiency.

Function 1: Prohibit editing

Set "restrict editing" in the Excel table to prevent Excel from being modified at will. The table can only be edited after the restriction is lifted through the password.

First, open the Excel table and click [Protect Worksheet] in the [Review] list of the menu tab.

After the dialog box pops up, enter the password you want to set in the blank column, click [Confirm] and enter it again. Excel's "Restricted Editing" will be set.

After setting, the contents in the Excel table cannot be modified, edited, deleted, etc., and most of the options are also gray and cannot be selected.

Function 2: Disable copying

According to the setting method of "Function 1", although the Excel table cannot be edited, you can still copy the content and paste it into other Excel tables. If you want To disable copying, you can also click the menu tab [Review]-[Protect Worksheet], then remove the checkmarks in front of [Select locked cells] and [Select unlocked cells], and then enter in the blank column The password you want to set.

In this way, after the settings are completed, you will not be able to select any cells in Excel, and you will not be able to copy them.

If you later want to cancel the above two "prohibited" functions, you can click [Undo Worksheet Protection] in the [Review] list of the menu tab, and then in the pop-up dialog box, enter the originally set password and save the file. Afterwards, Excel's "Prohibit editing" and "Prohibit copying" will be lifted.

It should be noted that if you forget your password, you cannot lift these two "restrictions" in Excel, because Excel does not have a "forgot password" option, and even the author himself cannot lift the restrictions without a password.

But don’t worry, we can use other tools to solve this problem.

The above is the detailed content of 3 forbidden functions of Excel. For more information, please follow other related articles on the PHP Chinese website!