Excel中套用表格样式sumifs和vlookup的使用方式
1
分步阅读
Excel中套用表格样式,sumifs,和vlookup的使用方式
工具/原料
Excel
方法/步骤
首先打开Excel,没有的话可以自己去网上找office的破解版,百度可以找到很多。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a2cc7cd98d1001e9c4354f70a80e7bec54e79740?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
请点击输入图片描述
在套用表格样式的时候注意不要把合并的单元格也选进去。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/2fdda3cc7cd98d10fddd574e313fb80e7bec9040?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
请点击输入图片描述
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7dd98d1001e93901df0bd6416bec54e736d19640?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
请点击输入图片描述
使用公式的打开步骤是通用的。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4a36acaf2edda3cc86ede35f11e93901213f9240?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
请点击输入图片描述
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/77094b36acaf2edd5af812969d1001e939019340?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
请点击输入图片描述
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/adaf2edda3cc7cd976246fa62901213fb80e9140?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
请点击输入图片描述