前言:日常工作中经常需要用到表格,梳理下简单好用的功能
一.快速填充日期
1.输入今天的星期和日期
![img_3accb6bf7ae446147991cf6ba60f4e0d.png](https://yqfile.alicdn.com/img_3accb6bf7ae446147991cf6ba60f4e0d.png?x-oss-process=image/resize,w_1400/format,webp)
image.png
2.鼠标挪到日期单元格,会出现一个黑色的"+"
![img_ef7c3b7656447c17521fa9c0f12a33d1.png](https://yqfile.alicdn.com/img_ef7c3b7656447c17521fa9c0f12a33d1.png?x-oss-process=image/resize,w_1400/format,webp)
image.png
3.此时按住左键不放,往下拖
![img_1d6f30593038ccd91fa90b8494e4b4ef.png](https://yqfile.alicdn.com/img_1d6f30593038ccd91fa90b8494e4b4ef.png?x-oss-process=image/resize,w_1400/format,webp)
image.png
填充选项可选择以什么方式填充
![img_302c643922ff0ff8ec485346164efc16.png](https://yqfile.alicdn.com/img_302c643922ff0ff8ec485346164efc16.png?x-oss-process=image/resize,w_1400/format,webp)
image.png
有了左边的日期,星期几的填充就方便多了,
在上述第二步的时候双击黑色"+",星期几就被自动填充了
![img_4e0e47052cec26eeec6bdf223bed9780.png](https://yqfile.alicdn.com/img_4e0e47052cec26eeec6bdf223bed9780.png?x-oss-process=image/resize,w_1400/format,webp)
image.png
![img_d197e7b9c7c25e9d6f7412c9ce4e9592.png](https://yqfile.alicdn.com/img_d197e7b9c7c25e9d6f7412c9ce4e9592.png?x-oss-process=image/resize,w_1400/format,webp)
image.png