/iknow-pic.cdn.bcebos.com/b3119313b07eca805e3413409c2397dda1448367"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b3119313b07eca805e3413409c2397dda1448367?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/b3119313b07eca805e3413409c2397dda1448367"/>
2.选择单元格。
/iknow-pic.cdn.bcebos.com/11385343fbf2b211ab59afe9c78065380cd78e25"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/11385343fbf2b211ab59afe9c78065380cd78e25?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/11385343fbf2b211ab59afe9c78065380cd78e25"/>
3.加上边框。
/iknow-pic.cdn.bcebos.com/91529822720e0cf3c35f645c0746f21fbf09aae8"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/91529822720e0cf3c35f645c0746f21fbf09aae8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/91529822720e0cf3c35f645c0746f21fbf09aae8"/>
4.录入序号、日期、摘要、收入、支出、余额、备注等内容。
/iknow-pic.cdn.bcebos.com/e824b899a9014c089d7a0302077b02087af4f4d0"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/e824b899a9014c089d7a0302077b02087af4f4d0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/e824b899a9014c089d7a0302077b02087af4f4d0"/>
5.在第二行录入收入的信息，如收入工资的情况。
/iknow-pic.cdn.bcebos.com/e61190ef76c6a7ef8399af8ff0faaf51f2de66df"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/e61190ef76c6a7ef8399af8ff0faaf51f2de66df?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/e61190ef76c6a7ef8399af8ff0faaf51f2de66df"/>
6.在第三行录入支出的信息，如交房租等。
/iknow-pic.cdn.bcebos.com/267f9e2f07082838f35cc9b3b599a9014d08f1c0"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/267f9e2f07082838f35cc9b3b599a9014d08f1c0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/267f9e2f07082838f35cc9b3b599a9014d08f1c0"/>
7.在第三行单元格余额这一栏设置公式，即上一栏余额加上收入减去支出等于当前余额。
/iknow-pic.cdn.bcebos.com/241f95cad1c8a78644a35fa96a09c93d71cf508f"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/241f95cad1c8a78644a35fa96a09c93d71cf508f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/241f95cad1c8a78644a35fa96a09c93d71cf508f"/>
8.将公式下拉，并添加合计数，就可以反应出时时的收入和支出情况了。
/iknow-pic.cdn.bcebos.com/dbb44aed2e738bd46197b598ac8b87d6267ff9e1"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/dbb44aed2e738bd46197b598ac8b87d6267ff9e1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/dbb44aed2e738bd46197b598ac8b87d6267ff9e1"/>
9.设置一下文字的格式，使表格看起来美观一些。
/iknow-pic.cdn.bcebos.com/4e4a20a4462309f79ed1b9b57f0e0cf3d6cad6de"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/4e4a20a4462309f79ed1b9b57f0e0cf3d6cad6de?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/4e4a20a4462309f79ed1b9b57f0e0cf3d6cad6de"/>
打开Excel表格，在表格第一行中输入标（公司的名称），第二行输入地址（公司的详细地址），第三行输入公司的（电话及传真），第四行输入（对账单），第五行输入（客户、月份、打印日期），如图所示按住键盘中的“Ctrl”键不放，选中区域点击菜单栏中的【合并及居中】按钮键，如图所示
选中区域【A6:H18】，点击菜单栏 中的【边框】按钮键，选择【所有边框】，如图所示
4
在表格中输入【日期、送货单号、名称及规格、单位、数量、单价（元）、金额（元）、备注】，输入完毕后，按住键盘中的“Ctrl”键不放，选中区域【A18:C18,D18:G18】，点击菜单栏中的【合并及居中】按扭键，如图所示
