Excel these 10 practical skills, each is very powerful, absolutely can't miss
Wind chimes on trees 2020-11-25 23:22:54
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 .

Excel this 10 A practical skill , Every one of them is amazing , Never miss


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 】.

Excel this 10 A practical skill , Every one of them is amazing , Never miss


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 】.

Excel this 10 A practical skill , Every one of them is amazing , Never miss


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 】.

Excel this 10 A practical skill , Every one of them is amazing , Never miss


Highlight duplicate values


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

Excel this 10 A practical skill , Every one of them is amazing , Never miss


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 ;;;.

Excel this 10 A practical skill , Every one of them is amazing , Never miss


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 .

Excel this 10 A practical skill , Every one of them is amazing , Never miss


Enter the score


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

Excel this 10 A practical skill , Every one of them is amazing , Never miss


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 .

Excel this 10 A practical skill , Every one of them is amazing , Never miss


Delete blank lines in batch


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

Excel this 10 A practical skill , Every one of them is amazing , Never miss


This paper is written by Office Wonderful office original , Welcome to your attention , Grow knowledge with you !
( The circle card has been added here , Please check the toutiao client )

版权声明
本文为[Wind chimes on trees]所创,转载请带上原文链接,感谢
https://fheadline.com/2020/11/20201125232027171h.html
相似文章

2021-08-09