- excel快捷键
Ctrl + Shift + L 筛选
Ctrl + "+" 加列
Ctrl + "-" 减列
Ctrl + D 向下填充
- excel随机填充汉字
=CHOOSE(RANDBETWEEN(1,4),"男性","未知","女性","")
- excel随机填充数字
=RANDBETWEEN(60,100)
- excel设置如果vlookup不到就置为空值
=IFERROR(VLOOKUP(C9,S:W,5,FALSE),"")
- excel单元格内所有单词首字母大写
=PROPER(E71)
- excel计算两个时间之间的小时数
Hour ()
- 时间加若干小时
E5+time(1,0,0)