1、在电脑上用2007版excel软件打开目标表格。
/iknow-pic.cdn.bcebos.com/b7fd5266d0160924b9a82a77db0735fae7cd34c8"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b7fd5266d0160924b9a82a77db0735fae7cd34c8?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/b7fd5266d0160924b9a82a77db0735fae7cd34c8"/>
2、然后在页面布局菜单中，点击“打印标题”选项。
/iknow-pic.cdn.bcebos.com/71cf3bc79f3df8dc27af07fdc211728b461028c8"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/71cf3bc79f3df8dc27af07fdc211728b461028c8?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/71cf3bc79f3df8dc27af07fdc211728b461028c8"/>
3、然后在出现的界面中，点击“顶端标题行”后面的按钮。
/iknow-pic.cdn.bcebos.com/faf2b2119313b07e53aedb6403d7912397dd8c4f"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/faf2b2119313b07e53aedb6403d7912397dd8c4f?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/faf2b2119313b07e53aedb6403d7912397dd8c4f"/>
4、然后选取标题行所在的行，点击图中箭头所指的按钮。
/iknow-pic.cdn.bcebos.com/7aec54e736d12f2e0fe5260c40c2d562843568fe"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/7aec54e736d12f2e0fe5260c40c2d562843568fe?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/7aec54e736d12f2e0fe5260c40c2d562843568fe"/>
5、最后点击界面下方的确定按钮。这样即可在电子表格中设置顶端标题行。
/iknow-pic.cdn.bcebos.com/0dd7912397dda144321ae7debdb7d0a20cf4864f"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/0dd7912397dda144321ae7debdb7d0a20cf4864f?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/0dd7912397dda144321ae7debdb7d0a20cf4864f"/>