Excel There are so many skills , But there are only a few practical ones in daily work , This paper has sorted out 10 A practical excel skill , Every one of them is really cool , It must be helpful to your study and work , Never miss .

Use version as excel2016, Other versions may be different , But it's the same , The operation is almost the same .

# The story of how to become a professional person ## The professional said ## Have a word to say #

Add, subtract, multiply, and divide a column of data at the same time 100

Blank cell input 100 And copy it , Select the data area , And then click 【 Paste special 】, Then choose the appropriate addition 、 reduce 、 ride 、 except .

Freeze the first row, the first column

Freeze the first row or the first column, as we all know , Then freeze the first row and the first column at the same time ？

Select the first 1 Column and the first 1 The lower right corner of the intersection B2 Cell , And then click 【 View 】→【 Freeze the panes 】→【 Freeze the panes 】.

The formula converts the value

Select cells with formulas and copy , Then right click and select the keep only values button . Or click on 【 Paste special 】→【 The number 】.

Delete duplicate values in batch

excel Some of the duplicate data in the table is redundant , How to delete these duplicate values in batch ？

Select the data area →【 data 】→【 Data Tools Panel 】→【 Delete duplicate values 】.

Highlight duplicate values

Select the data area →【 Start 】→【 Conditional format 】→【 Highlight cell rules 】 →【 duplicate value 】.

Hide cell content

Select the data area to hide , Press shortcut key ctrl+1 Key or right key ,【 Format cell 】→【 Numbers 】→【 Customize 】, Enter three English semicolons ;;;.

Merging multiple cell contents into a single cell

Copy multiple cell ranges →【 clipboard 】→ 【 Select a cell 】, Then in the edit bar, click the contents copied from the clipboard .

Enter the score

For example, to input 1/4, Type in 0 , Then enter the space , Input again 1/4 that will do .

Forced wrapping within cells

The cursor is positioned after the text that needs to wrap , Press shortcut key alt+ Enter key , You can switch to the next line .

Delete blank lines in batch

Press shortcut key Ctrl+G, Open the positioning window →【 Location condition 】→【 Null value 】→【 Delete 】→【 The whole line 】.

This paper is written by Office Wonderful office original , Welcome to your attention , Grow knowledge with you ！