excel practical skills

Today I will share with you 10 powerful practical Excel skills

1) Quick screening

Don’t ctrl c , don’t use ctrl v. If you don’t want to go to the trouble of creating a filter and then inputting it, just right-click and filter by the value of the selected cell. Isn’t it much faster?

2) Undo the operation shortcut key (Ctrl z)

I don’t want to go all the way to click the undo arrow with my mouse. I just need to press ctrl z on the keyboard to buy the regret medicine and return to the previous step

3 ) Forced line break (Alt enter)

Still using spaces to break lines? Once the width is slightly adjusted, it will break down and you have to re-adjust it.

Use forced line breaks. You can do whatever you want. You can change lines wherever you want.

4) Quickly copy data

It’s amazing, Excel can also copy data in this way. Place the mouse on the edge of the data area, hold down ctrl, and move after the number appears, then you can copy the data to the specified area

5) Centering across columns

Merge cells are very commonly used, but as everyone knows, merging cells has become a target. For the data source, it destroys the data structure of rows and columns, resulting in There will be inaccuracies in formulas, filters, and pivot tables, so people who do sales data analysis can say that they hate merged cells in the source data. How can the effect of merged cells be achieved? It does not affect the structure of the table and is centered across columns. You deserve it

6) Quickly beautify the table

How do other people’s tables beautify? Try selecting data. Press Ctrl T after the area to create a table function

You can apply different formats for beautification

7) Pivot table slicer

Upgraded to the 2013 version Or after the 2016 version, mastering the pivot table slicer is definitely a powerful tool for analyzing data. You will find that viewing data is so fast and you can switch between data instantly

8) Quickly find worksheets

There are too many worksheets, and it’s really slow to find the worksheet labels one by one.

Click on the area to the left of the first worksheet, and you will find that all the worksheets are in Here

9) Quickly generate Excel charts

Alt F1 generates charts in one second. After the column chart is generated by default, it can be modified to other chart types

10) How to put multiple rows of data into one cell

This function is quite amazing. Most people don’t know that the clipboard can be cut like this

You need to press Ctrl C twice in succession to bring up the cutting board

For more Excel-related technical articles, please visit the

Excel Basic Tutorial

column to learn!

The above is the detailed content of excel practical skills. For more information, please follow other related articles on the PHP Chinese website!