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 !
( The circle card has been added here , Please check the toutiao client )