Learn these 11 Excel operation skills and your work and ministry will be doubled!

In the previous article "Practical Excel Tips Sharing: Adding Switches to Conditional Formatting" we introduced the method of adding switches to conditional formatting to achieve Excel data strips with switches. Today I will share with you 11 Excel operation skills that will make your work and ministry half doubled. Except for the last one, the others are used every day. Come and collect them and learn them!

1. Quick summation

To sum and summarize data in multiple rows and columns, How do you do it?

It’s actually very simple: just select the data area and then press the key combination , and you’re done.

2. Split data by specific symbols

Copied from web pages or other programs Content, tends to be crowded together. Use the sorting function to deal with "messy" data.

Click "Sort" under the "Data" option and separate the data as required. Note that when there is information such as ID number and bank card number, the column data format must be set to text in the third step of column separation.

3. Name alignment

#When entering a name, there are not only three-character names but also two-character names. Are you still using spaces to align your names?

4. Date alignment

The date data usually entered often looks inconsistent. , how to make date data neat and beautiful?

5. Alignment of subject codes

Still using spaces to indent text Effective?

This problem is very simple:

6. Forced line breaks in cells

In the salary table in the picture below, the column withholding pension will appear very wide because of the large amount of text, which is inconsistent with the overall column width of the table.

You can use forced line wrapping to solve this problem. The method is to click the cell you want to wrap, then place the cursor in the edit bar, click the position you want to wrap, and press Alt and press Enter:

7. Quickly copy formulas

After setting the formula in a column, select the formula area and press Ctrl C to copy.

Then hold down the Ctrl key, click the starting cells of other columns where you want to use the same formula, and then press the Enter key to quickly apply the formula to other columns:

8. Enter multiple cells at the same time

Select all cells, enter data in the edit bar, and press the Ctrl key At the same time, press the Enter key.

9. Quickly hide columns

To hide data in a column in the worksheet, do not right-click That’s it. Just select a column and quickly drag it to the left. The selected column will be hidden:

10. The date is displayed as day of the week

Well, this is often used in duty schedules.

11. Quickly adjust the display ratio

Hold down the ctrl key and scroll the mouse wheel. You can enlarge or reduce the display ratio of the Excel workspace at will.

You can also select the data area and quickly zoom to the selected area, so you can show off your skills when making reports.

Related learning recommendations: excel tutorial

The above is the detailed content of Learn these 11 Excel operation skills and your work and ministry will be doubled!. For more information, please follow other related articles on the PHP Chinese website!