必须把握的15个Excel表格操作技巧诠释
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/782d132371754b65abfb257e8370f58d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988891&x-signature=scfDijRTWPOJ3fLYf6NNiYoWpek%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"> 在职场办公中，Excel的<span style="color: black;">运用</span>率还是非常高的，但能正确<span style="color: black;">运用</span>Excel系统的并不是<span style="color: black;">非常多</span>，今天，<span style="color: black;">博主</span>给<span style="color: black;">大众</span>准备了<span style="color: black;">有些</span>Excel表格的基本技巧，<span style="color: black;">期盼</span>对<span style="color: black;">大众</span>的工作有所<span style="color: black;">帮忙</span>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">1、</span>单元格内强制换行</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/33bb6ad7cf1646c29073e51ad9cf3505~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988891&x-signature=MM0M87e%2B%2FD2GkzfK4VUh%2BqynTs4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">将光标<span style="color: black;">插进</span>需要换行<span style="color: black;">表示</span>的字符前，按快捷键Alt+Enter<span style="color: black;">就可</span>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">2、</span>锁定标题行</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/10482f37c0c64580bc1a078a35302756~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988891&x-signature=FdG5cqtrssUkOBObuN%2B9MRytR%2BQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选定标题行下的任意单元格，【视图】-【冻结窗格】。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">3、</span>打印标题行</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/808ff33c5c064982a3d267aecfa2cd10~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988891&x-signature=6bL7y29IBIrVxSjdhbjxGuRIvWw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">选取</span>表格的任意单元格，【页面设置】-【打印标题】，单击【顶端标题行】右侧的箭头，<span style="color: black;">选择</span>需要打印的的标题行，单击箭头返回并【确定】。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">诠释</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">打印标题行<span style="color: black;">重点</span>用于有多页数据时，让每页都<span style="color: black;">表示</span>标题行。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">4、</span>查看重复值</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/1b7eb03028f845c893cfcf62b3585718~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988891&x-signature=6dAb%2FTxCwS2s7w7Pvd4jgE4ycVE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选定<span style="color: black;">目的</span>单元格，【<span style="color: black;">要求</span>格式】-【【<span style="color: black;">明显</span><span style="color: black;">表示</span>单元格规则】-【重复值】，打开【重复值】对话框，设置填充色，并【确定】。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">5、</span>删除重复值</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/79887ceabe214786871dabeaac232d3f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988891&x-signature=nEF866Q%2Fh9T2kjK6n%2BU4nZBXZWc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选定<span style="color: black;">目的</span>单元格，【数据】-【删除重复值】，<span style="color: black;">按照</span><span style="color: black;">实质</span><span style="color: black;">状况</span><span style="color: black;">选取</span>【扩展选定区域】或【以当前选定区域排序】并【删除重复项】- 【确定】-【确定】。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">6、</span>万元<span style="color: black;">表示</span></strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/cac6b37b2ad74a90a131395120d85341~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988891&x-signature=3x8NUpRkMNcUBcIJAEa129baoZ8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在空白单元格中输入10000并复制，<span style="color: black;">选取</span><span style="color: black;">目的</span>单元格，右键-【<span style="color: black;">选取</span>性粘贴】，打开【<span style="color: black;">选取</span>性粘贴】对话框，<span style="color: black;">选取</span>【运算】中的【除】并【确定】。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">7、</span><span style="color: black;">隐匿</span>0值</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/32f59a7d951243a9bac571c8ee0416bc~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988891&x-signature=9VZESEVG0XTvT%2F%2FO3nJK18lcnn4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选定工作表中的任意单元格，【文件】-【选项】-【高级】，取消【<span style="color: black;">这里</span>工作表的选项】中的【在<span style="color: black;">拥有</span>零值的单元格中<span style="color: black;">表示</span>零】并【确定】。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">8、</span><span style="color: black;">隐匿</span>单元格所有值。</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/pgc-image/09b2452ffaa84711856488de74bdbe21~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988891&x-signature=YalSbAaIShvPxOARZv3Cfo9J93Q%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选定工作表中的任意单元格，快捷键Ctrl+1打开【设置单元格格式】对话框，<span style="color: black;">选取</span>【<span style="color: black;">归类</span>】中的【自定义】，并在【类型】中输入：;;;并【确定】。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">9、</span>在单元格中输入“00001”</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/d70f56c772f94eec8909428d2e474d56~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988891&x-signature=w0YM7U5hrQzygc9MlG7BG8oAsCU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选定<span style="color: black;">目的</span>单元格，快捷键Ctrl+1打开【设置单元格格式】对话框，<span style="color: black;">选取</span>【<span style="color: black;">归类</span>】中的【自定义】，并在【类型】中输入：00000并【确定】。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">十、按月填充日期</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/aadc67d0d84c4d2ca81553d6b514c97c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988891&x-signature=3ieJByr1NrydtL2MqqS4SAFGhrg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在<span style="color: black;">第1</span>个<span style="color: black;">目的</span>单元格中输入<span style="color: black;">初始</span>月份，拖动填充柄填充，单击右下角的箭头并<span style="color: black;">选取</span>【按月填充】<span style="color: black;">就可</span>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">十<span style="color: black;">1、</span>快速合并多个单元格的内容</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/42ac0bf6722442f8a1aa8771f957eaf7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988891&x-signature=82F2loMY2Q6Ov3JCayWHCFff994%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选定<span style="color: black;">目的</span>单元格，【填充】-【内容重排】。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">十<span style="color: black;">2、</span>防止重复录入。</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/a2f58a2b1dcb4f8da2037de986521ddc~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988891&x-signature=SCuxi%2BqWUyRcf6SoGz%2F5%2FElFlE8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选定<span style="color: black;">目的</span>单元格，【数据】-【数据验证】，<span style="color: black;">选取</span>【<span style="color: black;">准许</span>】中的【自定义】，在【公式】中输入：=COUNTIF(H$3:H$12,H3)=1并确定。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">十<span style="color: black;">3、</span>公式转值</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/5f764b4e28e840d890066a614997fec1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988891&x-signature=dSAbzxRhSFzR8YuMTiTEVwFDc7o%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选定<span style="color: black;">目的</span>单元格并复制，在粘贴区域的<span style="color: black;">第1</span>个<span style="color: black;">目的</span>单元格处右键，<span style="color: black;">选取</span>【粘贴选项】中的【值】<span style="color: black;">就可</span>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">十<span style="color: black;">4、</span>快速向下取整。</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/c566ef1f61424de38711bac6cad11f20~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988891&x-signature=HmBG1nVi1MtrThyfnrxZ87aSq70%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选定<span style="color: black;">目的</span>单元格，Ctrl+H打开【<span style="color: black;">查询</span>和替换】对话框，在【<span style="color: black;">查询</span>内容】中输入：.*（英文句号和星号），在【替换为】中输入一个空格并【<span style="color: black;">所有</span>替换】，【确定】。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">十<span style="color: black;">5、</span>快速<span style="color: black;">插进</span>多行</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/590cb2a92c044f48b58d09470f41a9b8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988891&x-signature=Y7FiqhpoVEvpPilDRs9XQ2j5MlQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中<span style="color: black;">目的</span>行，按住Shift键并移动鼠标，待鼠标变为“双向箭头”时，向下拖动<span style="color: black;">就可</span>。</p>
我完全赞同你的观点，思考很有深度。
页:
[1]