7个Excel小技巧，每一个都很实用，再忙亦要看一看！
<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;">今天跟<span style="color: black;">大众</span>分享7个Excel个小技巧，<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>
<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;">操作<span style="color: black;">办法</span>：</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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/9e68fc495ec04723af7c77a8fef82daa~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981815&x-signature=hcUBdERsVuCP4%2BdZxWkaRRL0RrI%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;">2、</span>F9快速预览公式结果</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;">操作<span style="color: black;">办法</span>：</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>按F9键<span style="color: black;">就可</span>，<span style="color: black;">倘若</span>想还原之前的公式只需再按组合键【Ctrl+Z】<span style="color: black;">就可</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/f2d7b7b734974d30b6e254117b7306e4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981815&x-signature=TExlg46%2B1AJx8ZcJdmWC%2FiIWyzs%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>
<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 style="color: black;">办法</span>：</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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/bce39f1e36c740aabfe664437712a4c6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981815&x-signature=9CjFGNFToCzYdP7K8W0NgEk9Rv4%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;">4、</span>不改变列宽<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>变成#号的日期呢？<span style="color: black;">或</span>说日期字体<span style="color: black;">体积</span><span style="color: black;">怎样</span>自适应列宽呢？</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/dc118e7968374a409149c183e6225ccf~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981815&x-signature=UIPLcsAHVLZOl2%2FDvfFSJAJuB4c%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 style="color: black;">办法</span>：</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>快捷键【Ctrl+1】调出“单元格格式”窗口→点击【对齐】选项，勾选【文本<span style="color: black;">掌控</span>】版块下的【缩小字体填充】选项，<span style="color: black;">这般</span>日期字体<span style="color: black;">体积</span>就<span style="color: black;">能够</span>自适应列宽了。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/15c90cf5fd934fa7a06c3308d490dceb~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981815&x-signature=0447CTejrCN6JQjpcOdhAx%2FKeWI%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;">5、</span>制作可自动更新数据的下拉菜单</strong></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 style="color: black;">办法</span>：</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>按快捷键【Ctrl+T】把它转换为超级表→接着点击点击【数据】-【有效性】调出“数据有效性”窗口→在弹出的“数据有效性”对话框中“有效<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>想要设置的下拉的数据，→最后点击【确定】<span style="color: black;">就可</span>。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/8b6dfb8b701f4fc9be40d90b613961de~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981815&x-signature=kramjnLqV8co%2BL5gHVYM%2B1azsGA%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;">6、</span>打印表格时自动生成打印日期和时间</strong></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 style="color: black;">办法</span>：</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;">②在弹出的“页面设置”窗口<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;">③在弹出的“页眉”对话框，【左】添加上日期、时间，<span style="color: black;">而后</span>选中添加的日期、时间，并且设置字体和颜色<span style="color: black;">就可</span>。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/bca58d9e22cb42eaa56ab332a0655b16~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981815&x-signature=evr6%2F8cvzzhcOal5av6f5ZUsLQ0%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;">7、</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;">第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;">操作<span style="color: black;">办法</span>：</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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/9a8ff6a691d84b75a1c214d1800aeb86~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981815&x-signature=8nbW1hmD%2BpY07HcMuwSf6xjGffo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>
回顾历史，我们感慨万千；放眼未来，我们信心百倍。
页:
[1]