The most commonly used 25 Excel skills

1, two columns of data to find the corresponding position of the same value

=match (b1,a:a,0)

2. The result of a known formula

Define Name =evaluate (sheet1! C1)

Formula for known results

Define name =get. CELL (6,sheet1! C1)

3, forced line wrapping

With Alt+enter

4, more than 15 digits input

This question asks too many people, also put up. First, the cell is set to text, and two, enter the number before entering '

5. If you hide column B, if you let it show up?

Select a to C column, right-click and unhide

Select a to C column, double-click to select any column wide line or change any column width

Move the mouse over the AC column, and drag when the mouse changes to a double vertical bar.

6, Excel in the row and column interchange

Copy, paste selectively, select transfer, OK

7, how Excel is encrypted

(1), save can be saved as >> the upper right corner of the "Tools" >> general >> settings

(2), Tools >> options >> Security

8. About COUNTIF

The COUNTIF function can have only one condition, such as greater than 90, =countif (a1:a10, ">=90")

A reduction is required between 80 and 90 for =countif (A1:A10, ">80")-countif (a1:a10, ">90")