【 Weak current College 】 controlled common 25 operating skills Excel applies (1)

1, two columns of data to find the location of the same value corresponds

=MATCH(B1,A:A，0)

2. findings known formula

Define title = EVALUATE (Sheet1! C1)

The results of a formula known

Define title = GET.CELL (6, Sheet1! C1)

3, forced line break

Use ALT + Enter

4. beyond the 15-bit digital inputs

The questions asked by too many people are away. First, configure the text cells; second, enter the number before you enter the '

5, assuming that lurk the B column, consider having it show up?

Select columns A to C, right-click to remove potential

Select A to C column, double-click Select any column width line or any of the column width changes

Move your mouse over the column to the AC, etc. between the mouse changes into a double vertical bar, drag them.

6, the ranks of the interchange in Excel

Copy, paste, selection of selected to convey ownership, OK

7, how Excel encrypted

(1), in storage can save as >> corner of the "Tools" >> practices >> configuration

(2), security tool >> >> options

8. about COUNTIF

COUNTIF function had to have a condition, such as greater than 90, = COUNTIF (A1: A10, "> = 90")

Between 80 and 90, with a reduction of between $ = COUNTIF (A1: A10, "> 80")-COUNTIF (A1: A10, "> 90") 9, according to the social security number, date of birth extract

(1) = IF (LEN (A1) = 18 to DATE (MID (A1, 7, 4), MID (A1, 11, 2), MID (A1, 13, 2)); IF (LEN (A1) = 15, DATE (MID (A1, 7, 2), MID (A1, 9, 2), MID (A1, 11, 2)), "error ID number"))

（2）、=TEXT(MID(A2,7,6+(LEN(A2)=18)*2),"#-00-00")*1

10, would like to completely rely on SHEET2 in SHEET1, enter the data

Task group, hold down the Shift or Ctrl key while you select Sheet1, Sheet2

11, column do not enter repeatedly digital

[Data]--[validity]--[custom]--[formula]

Enter = COUNTIF (A:A, A1) = 1

Suppose you want to find a digital input repeatedly

Conditional formatting on the formula "= COUNTIF (A:A, A5) > 1" format selected red

12, direct opened a spreadsheet file in time not open

The "folder options"-"file type" find the .xls file, and in the "Advanced" in the confirmation parameters can have 1%, assuming no, please manually add

13, excel drop-down menu of complete

[Data]-[validity]-[sequence]