1. 打印预览：

    image.png

    1. 让表格有网格线

      image.pngimage.png

    • 第一种方式：缺点：表格线统一单调

      1.                                                            excel2007<br />               ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22105762/1626707256536-8989fcb7-f35f-424b-8920-773b2763fead.png#align=left&display=inline&height=96&margin=%5Bobject%20Object%5D&name=image.png&originHeight=192&originWidth=1352&size=67612&status=done&style=none&width=676)<br />                                                                               wps <br />   ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22105762/1626707457779-bb5fb84e-8b56-4675-a5bd-3cd46a757a49.png#align=left&display=inline&height=208&margin=%5Bobject%20Object%5D&name=image.png&originHeight=415&originWidth=1880&size=63968&status=done&style=none&width=940)

    • 方法二：绘制框线格线

      1.      ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22105762/1626707871104-edfc8977-a977-482c-8716-b929056b76ee.png#align=left&display=inline&height=446&margin=%5Bobject%20Object%5D&name=image.png&originHeight=891&originWidth=586&size=450731&status=done&style=none&width=293)<br />         清楚框线：按住shift不放 出现橡皮擦 <br />         关闭画笔功能：esc

    • 方法三：选取范围、套用样式

    image.png

    1. 背景设计：
    • image.png
    • 在表格四周插入空白栏列经行版面的间距调整
    1. image.png
    2. 函数：
    • 自动求和：image.png

    • 其他函数：

      image.png