lfdb.github.com/Excel.html at master · lfdb/lfdb.github.com · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<link rel="Stylesheet" type="text/css" href="style.css">
<title>Excel</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>

<h1 id="toc_1">Excel 学习笔记</h1>
<h2 id="toc_1.1">书籍</h2>
<p>
   《Excel实战技巧精粹》
</p>
<h2 id="toc_1.2">小技巧</h2>
<table>
<tr>
<th>
按键/函数
</th>
<th>
用途
</th>
</tr>
<tr>
<td>
ALT+41420
</td>
<td>
√
</td>
</tr>
<tr>
<td>
ALT+41409
</td>
<td>
×
</td>
</tr>
<tr>
<td>
0"."0,"万"
</td>
<td>
按万位缩放
</td>
</tr>
<tr>
<td>
=IF(ISNA(VLOOKUP(A:A,'01'!A:B,2,)),"0.00",VLOOKUP(A:A,'01'!A:B,2,))
</td>
<td>
错误数据显示为0
</td>
</tr>
<tr>
<td>
4 1 / 4
</td>
<td>
4 1/4
</td>
</tr>
<tr>
<td>
0 1 / 4
</td>
<td>
1/4
</td>
</tr>
<tr>
<td>
M 按 alt 178
</td>
<td>
M<sup><small>2</small></sup>
</td>
</tr>
<tr>
<td>
M 按 alt 179
</td>
<td>
M<sup><small>3</small></sup>
</td>
</tr>
<tr>
<td>
ALT + 10
</td>
<td>
换行符
</td>
</tr>
<tr>
<td>
Ctrl+1
</td>
<td>
单元格格式
</td>
</tr>
<tr>
<td>
Ctrl+F3
</td>
<td>
定义名称
</td>
</tr>
<tr>
<td>
F5
</td>
<td>
定位
</td>
</tr>
<tr>
<td>
=WEEKDAY(A2,A)&gt;5
</td>
<td>
工作日历中凸显周末
</td>
</tr>
</table>

</body>
</html>