Office技巧速成：3个让效率翻倍的实用方法

表格操作总出错怎么办

众多人于运用Excel开展数据处理工作之际，时常会被合并单元格以及公式报错等情形搞得疲惫不堪，焦头烂额。实际上，要是认真细细探究一番，便会发觉，大部分这类问题均是起因于对 Excel 基本功能欠缺熟悉了解。以合并单元格此项操作为例，从视觉呈现效果上来讲，它好像颇为美观好看，然而，它却会给后续的筛选以及计算工作带来极大干扰阻碍。

鉴于这种情况，我提议你换用“跨列居中”功能来替换合并单元格。具体的操作步骤是这样的：首先要选中你打算设置的单元格区域，紧接着按下Ctrl + 1调出格式设置窗口，随后在对齐选项卡之中选择“跨列居中”。像这样设置完成之后，从外观方面看起来仿佛是合并了单元格，然而实际上每个单元格的数据都完整无缺地保留着，这样一来在后续开展数据透视表操作的时候就不会出现差错了。

公式报错存在另外一个比较常见的缘由，这就是单元格引用出现了混淆情形。当你针对一个带有公式的单元格做复制动作时，Excel 会按照相对位置默认跟着移动。要是你希望公式里的某一个数值保持固定不变，那就得在行号或者列标之前加上$符号。如同你要计算每个产品的销售占比，这时总销售额所在的单元格就得采用$C$1 这种绝对引用形式。按一下F4键，便能够迅速达成引用方式的切换，这个小窍门，能够帮你省下相当多排查错误所花费的时间。

在复杂表格运算里，存在这样一种状况，公式报错因单元格引用弄混的情形屡屡皆是。当你复制含有公式的单元格之时，Excel会依照相对位置自动进行移动。如果你想要让公式里的某个值一直保持固定，那么要记得在行号或者列标前面添加$符号。比如说在计算各产品销售占比之际，总销售额单元格就得采用$C$1这种绝对引用。借助按F4键能够快速切换引用方式，此技巧能够帮你极大地减少排查错误所花费的时间。

Word排版总也搞不定

要撰写报告之际，最令人头疼不已的便是格式弄乱，尤其是诸如粘贴自网上的内容之后，字体、行距以及缩进全然各不相同。实际上，Word当中存在着一个“清除格式”按钮，它处于开始选项卡的字体区的最右侧位置，犹如一个带有A跟橡皮擦的图标模样。先选中弄乱的文字，而后点击一下这个按钮，所有格式便会消失不见，下一步再统一设置成自己所需要的样式即可。

说起来长文档排版存在着一个被称作“样式“的秘密武器，你并不需要针对每一个段落逐一手动去调整字号以及行距，而是能够直接预先设定好标题1、标题2以及正文各自的格式的，在进行撰写的时候选中相应文字，点击对应的样式名称，如此一来整篇文档的格式便可以维持一致了，要是想要批量修改所有标题的颜色，仅仅需要更改样式的设置，全文便会自动进行更新，这样做不但能够避免逐段调整时的重复劳动，还会让文档看上去显得更加专业。

PPT做图太慢怎么办

众多人制作PPT之际，会耗费大量时间于图形对齐以及配色方面。实际上，PowerPoint自身具备不少能够提升效率的功能。当按住Alt键去拖拽图形时，它便能够自动吸附至其他图形或者页面的边缘，使得对齐变得既快速又精准。在选中多个图形之后，于格式选项卡之中寻找到“对齐”按钮，还能够一键让它们实现上下或者左右居中，而无需再凭借肉眼一点点地调整啦。

配色这块儿可别靠拍脑袋决定。要是你所在的公司存在品牌色，那就先得把这些颜色加进主题色里头。具体的办法是，先去点击“设计”选项卡，然后在“变体”组当中找到“颜色”的下拉菜单，接着从中选择“自定义颜色”。从这之后，你所使用到的形状、图表以及表格都会按照这套颜色来默认显示，如此一来整体风格便会显得统一且专业。通过这样做你就能够把时间用在内容的组织安排上，而不用再去为到底哪个蓝色更好看而犯愁。

https://www.hongxiu.com/booklist/1485187
https://www.hongxiu.com/booklist/1485186
https://www.hongxiu.com/booklist/1485185
https://www.hongxiu.com/booklist/1485184
https://www.hongxiu.com/booklist/1485183
https://www.hongxiu.com/booklist/1485182
https://www.hongxiu.com/booklist/1485181
https://www.hongxiu.com/booklist/1485180
https://www.hongxiu.com/booklist/1485179
https://www.hongxiu.com/booklist/1485178
https://www.hongxiu.com/booklist/1485176
https://www.hongxiu.com/booklist/1485177
https://www.hongxiu.com/booklist/1485175
https://www.hongxiu.com/booklist/1485174
https://www.hongxiu.com/booklist/1485173
https://www.hongxiu.com/booklist/1485172
https://www.hongxiu.com/booklist/1485171
https://www.hongxiu.com/booklist/1485170
https://www.hongxiu.com/booklist/1485169
https://www.hongxiu.com/booklist/1485168
https://www.hongxiu.com/booklist/1485165
https://www.hongxiu.com/booklist/1485167
https://www.hongxiu.com/booklist/1485166
https://www.hongxiu.com/booklist/1485164
https://www.hongxiu.com/booklist/1485163
https://www.hongxiu.com/booklist/1485162
https://www.hongxiu.com/booklist/1485161
https://www.hongxiu.com/booklist/1485160
https://www.hongxiu.com/booklist/1485158
https://www.hongxiu.com/booklist/1485159
https://www.hongxiu.com/booklist/1485156
https://www.hongxiu.com/booklist/1485155
https://www.hongxiu.com/booklist/1485157
https://www.hongxiu.com/booklist/1485154
https://www.hongxiu.com/booklist/1485153
https://www.hongxiu.com/booklist/1485152
https://www.hongxiu.com/booklist/1485151
https://www.hongxiu.com/booklist/1485150
https://www.hongxiu.com/booklist/1485149
https://www.hongxiu.com/booklist/1485148
https://www.hongxiu.com/booklist/1485147
https://www.hongxiu.com/booklist/1485146
https://www.hongxiu.com/booklist/1485145
https://www.hongxiu.com/booklist/1485144
https://www.hongxiu.com/booklist/1485143
https://www.hongxiu.com/booklist/1485142
https://www.hongxiu.com/booklist/1485141
https://www.hongxiu.com/booklist/1485140
https://www.hongxiu.com/booklist/1485139
https://www.hongxiu.com/booklist/1485138
https://www.hongxiu.com/booklist/1485137
https://www.hongxiu.com/booklist/1485136
https://www.hongxiu.com/booklist/1485135
https://www.hongxiu.com/booklist/1485134
https://www.hongxiu.com/booklist/1485133
https://www.hongxiu.com/booklist/1485132
https://www.hongxiu.com/booklist/1485130
https://www.hongxiu.com/booklist/1485129
https://www.hongxiu.com/booklist/1485131
https://www.hongxiu.com/booklist/1485128
https://www.hongxiu.com/booklist/1485127
https://www.hongxiu.com/booklist/1485126
https://www.hongxiu.com/booklist/1485125
https://www.hongxiu.com/booklist/1485124
https://www.hongxiu.com/booklist/1485121
https://www.hongxiu.com/booklist/1485123
https://www.hongxiu.com/booklist/1485122
https://www.hongxiu.com/booklist/1485119
https://www.hongxiu.com/booklist/1485120
https://www.hongxiu.com/booklist/1485116
https://www.hongxiu.com/booklist/1485117
https://www.hongxiu.com/booklist/1485118
https://www.hongxiu.com/booklist/1485115
https://www.hongxiu.com/booklist/1485114
https://www.hongxiu.com/booklist/1485113
https://www.hongxiu.com/booklist/1485112
https://www.hongxiu.com/booklist/1485111
https://www.hongxiu.com/booklist/1485108
https://www.hongxiu.com/booklist/1485107
https://www.hongxiu.com/booklist/1485106
https://www.hongxiu.com/booklist/1485110
https://www.hongxiu.com/booklist/1485109
https://www.hongxiu.com/booklist/1485105
https://www.hongxiu.com/booklist/1485104
https://www.hongxiu.com/booklist/1485103
https://www.hongxiu.com/booklist/1485101
https://www.hongxiu.com/booklist/1485102
https://www.hongxiu.com/booklist/1485099
https://www.hongxiu.com/booklist/1485100
https://www.hongxiu.com/booklist/1485098
https://www.hongxiu.com/booklist/1485097
https://www.hongxiu.com/booklist/1485096
https://www.hongxiu.com/booklist/1485095
https://www.hongxiu.com/booklist/1485094
https://www.hongxiu.com/booklist/1485093
https://www.hongxiu.com/booklist/1485092
https://www.hongxiu.com/booklist/1485091
https://www.hongxiu.com/booklist/1485090
https://www.hongxiu.com/booklist/1485089
https://www.hongxiu.com/booklist/1485088
https://www.hongxiu.com/booklist/1485087
https://www.hongxiu.com/booklist/1485086
https://www.hongxiu.com/booklist/1485085
https://www.hongxiu.com/booklist/1485084
https://www.hongxiu.com/booklist/1485083
https://www.hongxiu.com/booklist/1485082
https://www.hongxiu.com/booklist/1485081
https://www.hongxiu.com/booklist/1485080
https://www.hongxiu.com/booklist/1485079
https://www.hongxiu.com/booklist/1485078
https://www.hongxiu.com/booklist/1485076
https://www.hongxiu.com/booklist/1485077
https://www.hongxiu.com/booklist/1485075
https://www.hongxiu.com/booklist/1485074
https://www.hongxiu.com/booklist/1485073
https://www.hongxiu.com/booklist/1485072
https://www.hongxiu.com/booklist/1485071
https://www.hongxiu.com/booklist/1485070
https://www.hongxiu.com/booklist/1485069
https://www.hongxiu.com/booklist/1485067
https://www.hongxiu.com/booklist/1485068
https://www.hongxiu.com/booklist/1485066
https://www.hongxiu.com/booklist/1485065
https://www.hongxiu.com/booklist/1485064
https://www.hongxiu.com/booklist/1485063
https://www.hongxiu.com/booklist/1485062
https://www.hongxiu.com/booklist/1485061
https://www.hongxiu.com/booklist/1485060
https://www.hongxiu.com/booklist/1485059
https://www.hongxiu.com/booklist/1485058
https://www.hongxiu.com/booklist/1485057
https://www.hongxiu.com/booklist/1485055
https://www.hongxiu.com/booklist/1485056
https://www.hongxiu.com/booklist/1485054
https://www.hongxiu.com/booklist/1485053
https://www.hongxiu.com/booklist/1485052
https://www.hongxiu.com/booklist/1485051
https://www.hongxiu.com/booklist/1485050
https://www.hongxiu.com/booklist/1485049
https://www.hongxiu.com/booklist/1485048
https://www.hongxiu.com/booklist/1485047
https://www.hongxiu.com/booklist/1485046
https://www.hongxiu.com/booklist/1485045
https://www.hongxiu.com/booklist/1485044
https://www.hongxiu.com/booklist/1485043
https://www.hongxiu.com/booklist/1485042
https://www.hongxiu.com/booklist/1485041
https://www.hongxiu.com/booklist/1485040
https://www.hongxiu.com/booklist/1485039
https://www.hongxiu.com/booklist/1485038
https://www.hongxiu.com/booklist/1485037
https://www.hongxiu.com/booklist/1485036
https://www.hongxiu.com/booklist/1485035
https://www.hongxiu.com/booklist/1485034
https://www.hongxiu.com/booklist/1485033
https://www.hongxiu.com/booklist/1485032
https://www.hongxiu.com/booklist/1485031
https://www.hongxiu.com/booklist/1485027
https://www.hongxiu.com/booklist/1485030
https://www.hongxiu.com/booklist/1485029
https://www.hongxiu.com/booklist/1485028
https://www.hongxiu.com/booklist/1485026
https://www.hongxiu.com/booklist/1485025
https://www.hongxiu.com/booklist/1485024
https://www.hongxiu.com/booklist/1485023
https://www.hongxiu.com/booklist/1485014
https://www.hongxiu.com/booklist/1485017
https://www.hongxiu.com/booklist/1485022
https://www.hongxiu.com/booklist/1485021
https://www.hongxiu.com/booklist/1485020
https://www.hongxiu.com/booklist/1485016
https://www.hongxiu.com/booklist/1485019
https://www.hongxiu.com/booklist/1485018
https://www.hongxiu.com/booklist/1485015
https://www.hongxiu.com/booklist/1485013
https://www.hongxiu.com/booklist/1485012
https://www.hongxiu.com/booklist/1485011
https://www.hongxiu.com/booklist/1485010
https://www.hongxiu.com/booklist/1485009
https://www.hongxiu.com/booklist/1485007
https://www.hongxiu.com/booklist/1485008
https://www.hongxiu.com/booklist/1485006
https://www.hongxiu.com/booklist/1485005

https://www.hongxiu.com/booklist/1485004
https://www.hongxiu.com/booklist/1485003
https://www.hongxiu.com/booklist/1485002
https://www.hongxiu.com/booklist/1484999
https://www.hongxiu.com/booklist/1485000
https://www.hongxiu.com/booklist/1485001
https://www.hongxiu.com/booklist/1484998
https://www.hongxiu.com/booklist/1484997
https://www.hongxiu.com/booklist/1484996
https://www.hongxiu.com/booklist/1484995
https://www.hongxiu.com/booklist/1484994
https://www.hongxiu.com/booklist/1484993
https://www.hongxiu.com/booklist/1484992
https://www.hongxiu.com/booklist/1484991
https://www.hongxiu.com/booklist/1484990
https://www.hongxiu.com/booklist/1484989
https://www.hongxiu.com/booklist/1484988
https://www.hongxiu.com/booklist/1484987
https://www.hongxiu.com/booklist/1484986
https://www.hongxiu.com/booklist/1484985
https://www.hongxiu.com/booklist/1484984
https://www.hongxiu.com/booklist/1484983
https://www.hongxiu.com/booklist/1484982
https://www.hongxiu.com/booklist/1484981
https://www.hongxiu.com/booklist/1484980
https://www.hongxiu.com/booklist/1484979
https://www.hongxiu.com/booklist/1484978
https://www.hongxiu.com/booklist/1484977
https://www.hongxiu.com/booklist/1484976