5 practical Excel tips to easily improve office efficiency!

In daily office work, Excel, as a commonly used office software, can help us process data, create tables and other tasks. This article introduces you to 5 practical Excel tips. Through these tips, you can easily improve office efficiency. There is no need for complicated operations, just master these tips and you will be able to use Excel more easily. Let’s take a look at these tips!

Tip 1: Quickly locate cells with formulas set

Function formulas are often used in Excel. Use the following method to quickly find the cells with formulas set.

Click [Start] → [Find and Select] → [Formula] in the Excel menu option list, and the cursor will automatically locate the cell where the function formula is set.

Tip 2: Print the selected area

To print an Excel table and only want to print the selected area, you can do it as follows.

First select the area that needs to be printed with the mouse, then click the menu tab [File], then click [Print] → [Settings] → [Print Selected Area], and finally click Print.

Tip 3: Split the data

If you have multiple data that need to be filled in Excel cells one by one, you can save a lot of time by using Excel's data splitting function.

First, select the cells where the data needs to be split, and then click the [Column] option in the menu tab [Data];

After the dialog box pops up, select [Delimiter], and then click [Next];

After the step 2 dialog box pops up, check the "Other" option and fill in the delimiter in the right box. For example, if the delimiter for data is a comma, fill in a comma, and if it is a period, fill in a comma, and then Click "Next";

In step 3, click [General] under [Column Data Format], check the "Data Preview" and then click [Finish] to split the data into columns.

Tip 4: Prevent copying tables

If you don’t want to copy the completed form at will, you can do it as follows.

First, click [Review] → [Protect Worksheet] on the menu tab;

After the dialog box pops up, remove the checkmarks in front of [Select locked cells] and [Option to unlock locked cells], and enter the settings you want in the [Password to be used when unprotecting the worksheet] column. Password, finally click [OK] and re-enter the password once, and it is set.

After setting, the Excel table cannot be copied, but it cannot be edited or changed at the same time.

If you want to lift this restriction, click [Revoke Worksheet Protection] in the [Review] list of the menu tab. After the dialog box pops up, enter the originally set password to lift the restriction, and you can copy or Editor changed.

Because a password is required to remove restrictions, remember to remember it or save it. What to do if you accidentally forget it? In this case, it is best to use other tools, such as the Pepsi Niu Excel Password Recovery Tool, which can directly remove the "restrictions" of the Excel table without a password.

Click the [Unrestriction] module in the tool, and then import the Excel table.

Tip 5: Set up Excel drop-down table

If there are certain cells in Excel that require repeated input, you can set them into drop-down tables to improve efficiency and make errors less likely.

For example, if you need to enter the content of "male or female" in the table, select all the cells that need to enter the content, and then click [Data Validation] in the menu tab [Data] list; (Some Excel versions are "Data Validity")

After the dialog box pops up, select [Sequence] in the [Allow] list, enter "Male, Female" in the [Source] column (separate with English commas), and then click [OK] to set it up.

After setting, the selected cells can be filled in directly through the following list.

The above is the detailed content of 5 practical Excel tips to easily improve office efficiency!. For more information, please follow other related articles on the PHP Chinese website!