ikkhksvu 发表于 2024-10-2 16:31:33

天天做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>的效果呢？当然<span style="color: black;">能够</span>，<span style="color: black;">然则</span><span style="color: black;">欠好</span>看。我从事财务工作20<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-axegupay5k/cb814e87f3f5400ba4b129629f6900bb~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988712&amp;x-signature=SelXOMTWdzo7vJZnrZGDtdUxvBQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1，单元格格式——数字</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;">第1</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>，需要勾选“千分位”，大部分<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/d661248fe98945b682c637d5a1dc2c41~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988712&amp;x-signature=pvubEnpkkaZGBgd5fRFrfxJUsC0%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2，单位元格格式——对齐</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>”的界面操作这个功能。长段的重要的文字内容，<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/c7c7000d5e694c29a9c4008f5cee954e~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988712&amp;x-signature=R4trdp3RYwO0K9Ivk3eMngH32bI%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3，单元格格式——边框</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/56bc9158e6ee46968120c35317cd67fd~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988712&amp;x-signature=yww8lzhyanaCou0YG7FCHb8Y9vY%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">4，字体、<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>”界面</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>仿宋，有些人<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/28d903082f124091806d0e70ee20fde4~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988712&amp;x-signature=8Am7gEWO%2Bim3bSz9RQvyLfUlH8I%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>呈现出来<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>，需要<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>需要提醒他人<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>是自己平时看<span style="color: black;">亦</span>就罢了，<span style="color: black;">倘若</span>是要给领导看，肯定是不行的，一张报表打开的一刹那，要在<span style="color: black;">不消</span>解说与指引的前提下，让领导5秒钟内就能看到重点与关键点。<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;">5，行宽与列宽</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>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/681ef5c1940a41138b2328ed7e6fe5e2~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988712&amp;x-signature=xkKkJba2SLjCei1Oroa2E74cIHQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">6，界面<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>表格较小，A列的列宽<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/d09314289c4242199c642b1e20ca2ddd~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988712&amp;x-signature=S8ecZbd6jT9uKr8jKEwXSMDg0tU%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>在一页屏幕，展示给其他同事看的时候，<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>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">7，冻结窗口</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/e8dbabaef24448acbd6d44e9e34ddde5~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988712&amp;x-signature=7OujiBB5JjKMw8r8VDQGLK39mqQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">8，表格组合</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>叫它“夹子”。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中行或列，点击菜单栏里的“数据”界面里的“组合”选项。</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/2d28efe39a9d4f5cbb9cadb2367e31d4~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988712&amp;x-signature=FTmkrZaFpgcvNPbEe0M2Jh%2Fxu0w%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 style="color: black;">最后，我把<span style="color: black;">调节</span>好的较为美观的格式呈现给<span style="color: black;">大众</span>，<span style="color: black;">大众</span><span style="color: black;">能够</span>与<span style="color: black;">第1</span>页的表格对比起来看。是不是效果更好<span style="color: black;">有些</span>呢？</span></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/7f8263dc9b2f4fe99b600ec52e59ab53~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727988712&amp;x-signature=ARTTuDQpWDzA0j1fhsoQx8yoY8M%3D" style="width: 50%; margin-bottom: 20px;"></div>




b1gc8v 发表于 2024-10-20 18:51:40

一看到楼主的气势，我就觉得楼主同在社区里灌水。

j8typz 发表于 2024-10-26 04:56:09

我完全同意你的看法，期待我们能深入探讨这个问题。
页: [1]
查看完整版本: 天天做EXCEL表格，怎么实现既美观又实用呢？