推荐阅读
如何在wps文字中输入带圈字体
在wps文字中，我们可以通过其自带的圆圈字符功能来输入带圈字体，那么，如何操作呢?下面就让小编告诉你 如何在wps文字中输入带圈字体的方法。 在wps文字中输入带圈字体的方法： 选择功能区中的“插入”，选择右上方的“数字”。 输入数字，从下面窗口中选择圆圈数字，确定。 选中输入的带圈数字，按住ctrl键，拖动鼠标到下一个需要输入带圈数字的地方，松开左键，这个带圈数字就被复制到该处。 选中这个数字，按鼠标右键，在弹出的菜单中选择“切换域代码”。 带圈数字变成代码格式，将代码中的数字改成10以内的数字，右键选择“更新域”，这个带圈数字就被改变了。 复制后粘贴这个代码的效果，与复制带圈数字相同。 需要输入大于10的数字或文字，需要选择“带圈字符”功能。
如何在PPT中快速制作3D组织机构图
在前面的文章中，我们教了大家用PPT制作精美3D水晶效果组织机构图的方法，不少朋友看了之后觉得相当的不错，还有一部分朋友也留言咨询水晶效果太过于花哨又制作繁琐，能不能在出个制作普通的组织机构图的教程。那么本文就教大家在制作PPT时，如何快速制作3D组织机构图。首先我们来介绍PPT 2010中自带的。插入“SmartArt”图形，在“层次结构”中选择具体类型，双击即插入。 删除图形中的淡蓝色背景，点击图形透明边框左侧的小三角，为机构图中各级添加项目并编辑文字内容。 通过回车添加项目，右击升级、降级的方式编辑好组织机构图的内容。 调整好图形的大小，通过“设计”菜单下的“更改颜色”，为机构图选择一个合适的颜色。 最后选择 “设计”菜单下的“平面场景”为其添加三维样式。
Excel2013中使用条件格式快速标记排名前十的数据的方法
‘); (window.slotbydup=window.slotbydup || []).push({ id: ‘623618’, container: s, size: ‘360,300’, display: ‘inlay-fix’ });})(); 在使用Excel表格统计分数或对员工绩效进行统计时，有时需要标记出排名靠前的数值。在Excel中，使用条件格式，可以将最大或最小的10个值设置为特殊的格式，使它们从众多的数据中突出显示出来，下面介绍Excel2013中使用条件格式快速标记排名前十的数据的具体操作方法。1、启动Excel 2013并打开工作表，选择需要处理的单元格区域。在“开始”选项卡的“样式”组中单击“条件格式”按钮，在打开的下拉列表中选择“项目选取规则”选项，在级联列表中选择“前10项”选项，。 图1 选择“前10项”选项2、打开“前10项”对话框，在“设置为”下拉列表中选择符合条件的格式，。单击“确定”按钮关闭对话框后，Excel将按照设定的个数标示出最大的10个值所在的单元格，。 图2 “前10项”对话框 图3 标示出最大的10个值
word让标尺显示的方法
Word中“标尺”工具的作用非常大，也许有人经常用它，也许很少有人用到。有了标尺我们可以轻松的调整边距、改变段落的缩进值、设置行距、表格的行高及列宽和进行对齐方式的设置等等。小面小编教你们word怎么显示标尺。 Word2007文档中显示或隐藏标尺的方法： 进入“视图”选项卡，在“显示/隐藏”选项组中将“标尺”钩上就是显示，将钩取消则是隐藏标尺。 Word2007“垂直标尺”不见了，该如何找回来： 单击“Office按钮”进入“Word选项”，选择左边的“高级”，然后在右边的“显示”中将“在页面视图中显示垂直标尺”钩选确定即可。 Word2003文档中显示或隐藏标尺的方法： 在Word2003中则只能自由显示或隐藏“垂直标尺”，貌似“水平标尺”不能控制。单击菜单栏的“工具”–>选项–>在“视图”的“页面视图和 Web 版式视图选项”中将“垂直标尺(仅页面视图)”钩选即可显示标尺，取消钩即可隐藏!
最新发布
图形－Shapes
One More Great-Looking Documents Post – Shapes又一篇关于“精美文档”的文章——图形A few weeks ago I posted a series of articles about great-looking documents. I have had a few questions about shapes since I wrote those posts, so I thought I would write a quick post on changes to shapes in Excel 2007 (and Office 2007 really – anything I write here applies to all the apps).几周前我发布了关于“精美文档”的一系列文章，在那之后，我收到了一些有关图形的提问，所以我想我要尽快撰写有关于Excel 2007里图形的变化(包括Office 2007，所有我在这里写的都能适用于所有的Office应用)的文章。Much the same way that charts were improved (new great-looking visuals, results-oriented ribbon UI), shapes have been improved as well. Here is a summary of the changes, which fall into a number of categories.我们已经知道，2007版本里面的图表在许多方面进行了改进(如新增漂亮的可视化效果，效果生成向导的用户界面)，同样的，图形方面也进行了与此相似的改进。下面是这些变化的总结，可以分为几种类型。1. New graphics effects and options – like charts, shapes will look a lot better in Excel 2007 … in fact, charts are built using shapes in Excel 2007, so the improvements in shapes and charts in this area are identical. Specifically,· Better shadows· Better gradients
非常酷的状态栏和精美图表
Quick detour – cool things on the status bar and great-looking charts快速入门-非常酷的状态栏和精美图表Today I decided to take a quick break from Excel Services totalk about a few small but useful changes that have been made to the status bar andshow off a few chartsFirst, the status barZoom control – we have added a slider that allows the user to adjust the “zoom” of the document without needing to pop up any windows. When you slide the control, the document resizes as you slide, so you can adjust to just the “zoom” you want before you let go of the slider. You can also click on the + and – buttons to increment or decrement “zoom” by 10% per click. Finally, for those of you that like using the zoom dialog, you can just click on the 100% (which is a button) and it will launch the Zoom dialog.我今天要谈Excel2007中质的突破：1. 小巧变化的状态栏
X 服务器格式，翻译和成员属性
PivotTables X: Server formatting, translations, member properties数据透视表 X：服务器格式，翻译，成员属性In this post I’ll walk you through three Analysis Services features that we now support in Excel PivotTables – server formatting, translations, and member properties. One thing to keep in mind as you read is that since all these are defined in Analysis Services (i.e. on a server), every PivotTable created that pulls data from Analysis Services will get the benefit of these features without the PivotTable author or user needing to do anything.在本文里，我将带领你浏览我们现在在Excel 数据透视表里支持的Analysis Services功能——服务器格式，翻译和成员属性。你在阅读的时候请牢记一件事，因此这些都是在Analysis Services（例如在服务器上）上定义的，从Analysis Services获得的数据而创建的每个数据透视表将会从中获益而不需要数据透视表作者或者用户去做任何事情。Server formattingWhen designing a model in Analysis Services, formatting can be associated with values. Excel PivotTables will display this formatting by default (you can control it in the connection properties dialog for the connection being used by the PivotTable, so if you want to turn off the formatting, you can).服务器格式在Analysis Services设计模型时，设计数据的同时也可以设置格式。Excel数据透视表将会默认地显示这些格式（你可以在连接属性对话框里控制它，因此如果你想要关闭格式的话，你可以做到）Here is an example of a PivotTable displaying number formatting as defined on the server – in this case dollars with two decimals. As you add fields to the Values area of the PivotTable, the formatting is done automatically.
IX 对SQL服务器分析服务的更强大支持（一）
PivotTables 9: Great support for SQL Server Analysis Services数据透视表 9：SQL服务器分析服务的强大支持Today, I’ll start a series of articles on the improvements we’ve made to PivotTables connected to OLAP (OnLine Analytical Processing) data sources, specifically Microsoft SQL Server Analysis Services models (in addition to its relational database product, SQL Server includes a feature named Analysis Services which provides business intelligence and data mining capabilities). Excel has worked with SQL Server Analysis Services for several versions now, but we have put a lot of time and effort into Excel 12 in order to make it a great front end to SQL Server Analysis Services, especially Microsoft SQL Server 2005 Analysis Services (Microsoft SQL Server 2005 Analysis Services was recently released as part of Microsoft SQL Server 2005 and introduced many new, powerful features for analyzing data … for more information on Analysis Services, please take a look here and here).今天，我将开始我们在数据透视表和OLAP（OnLine Analytical Processing联机分析处理）数据源，特别是Microsoft SQL Server Analysis Services模式（除了它有关的数据库产品之外，SQL Server还包括了一个名叫Analysis Services的功能，它提供业务情报和数据发掘能力）连接方面所作改进的系列文章。Excel已经有好几个版本能和SQL Server Analysis Services协作了，但是，为了使其作为SQL Server Analysis Services的前端能更好的工作，我们仍花了很多时间和精力在Excel 12上，特别是与Microsoft SQL Server 2005 Analysis Services （Microsoft SQL Server 2005 Analysis Services在前不久，作为Microsoft SQL Server 2005的一部分发布了，并且增加了很多新的，强大的数据分析功能……有关Analysis Services的更多详细信息，请看看这里）的协作上。Before I launch into discussing how Excel 12 works with SQL Server Analysis Services, I wanted to summarize what I see as several key benefits to using Analysis Services as a tool for working with business data.在我进入讨论Excel 12如何和SQL Server Analysis Services协作之前，我想总结一下我所认为的使用Analysis Services作为分析业务数据的注意好处。• Friendliness. Business data is typically stored in relational databases optimized for data input or storage and not analysis of that data. Names of columns etc. are typically not intuitive to end users, there are no clear relationships between fields, etc. Analysis Services provides a user-friendly model where you can provide understandable business names, specify relationships between fields (Product Category – Product Subcategory – Product) so that it is possible for business users to design their own reports without help from IT. • 友好：业务数据通常储存于相关的数据库里，这些数据库适于数据输入或者存储，但是不适于数据分析。诸如列名之类的元素对于终端用户不是很直观，字段之间没有清楚的关系，等等。Analysis Services提供了一个用户友好的模型，你可以提供易于理解的业务名称，明确字段（Product Category – Product Subcategory – Product）之间的关系，这样一来，业务用户就可能设置他们自己的报告，不必求助于IT部门了。• Personalization. Analysis Services offers tools for personalizing individual users’ reporting experience by only showing them the data that they care about and have permissions to see; in addition, Analysis Services can translate data into users’ preferred languages.
XI 关键性能指标，动作和名称集（二）
ActionsAnalysis Services models can have “actions” associated with them. Actions allow users exploring data in Analysis Services to react to what they find in their data … executing an action will take the context of the report (the data the user is looking at) and run a different application with the context as input. For example, the PivotTable below is connected to an Analysis Services model that has an action associated with the product category level. If a user right-clicks any item of that level (here we have picked Accessories for example), there is a Server Actions menu with the option to launch a report for Accessories.动作Analysis Services模型可以有一个随带“动作”。动作允许用户当他们在他们的数据里发现什么时相应在Analysis Services里浏览数据……执行动作会使用报告的上下文（用户正在查看的数据），并且使用该上下文作为输入运行一个不同的应用程序。例如，下面的数据透视表连接到Analysis Services模型，该模型有一个产品类别关联的动作。如果用户在该级上任意地方单击右键（例如我们选择Accessories），就会有个Server Actions菜单，带有一个启动Accessories报告的选项。In the example, the action is launching a sales comparison report for Accessories built using SQL Server 2005 Reporting Services. Here is a screenshot of that report in my web browser.在本例中，该动作是使用SQL Server 2005 Reporting Services（报表服务）创建Accessories的销售比较报表。这是在我网页浏览器上的报表截屏。Note that the action can take a wide variety of forms – running ERP applications, navigating to web pages, etc. Here is a link to a tutorial on MSDN. 注意，该动作可以使用各种形式——运行ERP应用程序，浏览到网页，等等。这里有个连接到MSDN的指南。Named Sets
VII －条件格式与数据透视表（一）
PivotTable VII: – Conditional formatting gets even better, or visualizing your data in PivotTables数据透视表VII －条件格式使数据透视表变得更好，数据更形象化In a series of previous articles I introduced the new conditional formatting capabilities in Excel 12 (see here for the whole series of posts). Today I want to add one more article to the series, which is the work we have done to make conditional formatting work really well in Excel PivotTables. This is an area that I love to show people, because the work we have done reduces a formerly-tricky task down to a few clicks.在我之前一系列的文章中，我介绍了Excel 12里面的条件格式。今天，我想在此系列里再增加一篇文章，那就是我们在Excel数据透视表里使用条件格式所作的努力。这是一个我乐意给人们展示的领域，因为我们所作的工作将以前难以完成的任务简化为非常简单的操作。The first point I want to make is that all the features we added around new types of conditional formatting (data bars, colour scales, icon sets, etc.), new rules (top 10, below average, etc.), and new UI are available for use on PivotTables. However, we did not stop there. To provide a great experience with conditional formatting inside PivotTables, we now associate the conditional formatting rules to the structure of the PivotTable instead of to the cells. What this means is that as users work with PivotTables (adding and removing fields, refreshing the data, expanding and collapsing levels, Pivoting fields between rows and columns, grouping fields, etc.), the formatting tracks the cells in the PivotTable appropriately, so the users don’t need to worry about what is happening to the formatting – things just work, and they can focus on analyzing their data instead. Let’s walk through an example.首先一点我需要说明的是，关于条件格式新格式（数据条，颜色比例，图标，等等），新规则（前10，均值之下，等等），以及新用户界面等方面增加的所有特点，在数据透视表里面都是可用的。然而，我们并没有就此满足。为了在数据透视表里面提供一个强大的条件格式体验，我们现在将条件格式的规则与数据透视表联系起来，而不是与单元格了。这意味着当用户操作数据透视表时（添加和删除字段，刷新数据，展开和折叠层次，在行与列之间透视字段，组合字段，等等），格式将恰当地追踪数据透视表里的单元格，因此用户不必担心格式会发生什么变化——照常运转，他们可以侧重于分析他们的数据。我们来看一个例子吧。In the PivotTable below I’m looking at sales for different bike models, and I have arranged my report so that I have a column with sales data for each year. To make it easier to visually compare the sales of various bike models, I want to apply conditional formatting to the sales values. In the same way as I would when conditionally formatting “ordinary” (i.e. non-PivotTable cells), I select some cells containing sales values …在下面的数据透视表里，我在看不同型号自行车的销售情况，我已经做好了我的报告，其中一列是每年的销售数据。我想要将条件格式应用到这些销售数据上，将不同型号自行车销售情况的比较变得形象化。就象设置“普通”（例如，非数据透视表单元格）的条件格式一样，我选择一些包含销售数据的单元格……… and then I use the ribbon to add a Data Bar format which helps users quickly scan their data to compare values and find outliers.
令人耳目一新的Excel 2007文档
Excel 2007 documents – easy on the eyesOne of the themes we focused on with Office 2007 was “great looking documents”. For the next half-dozen articles, I am going to explain what that means for Excel, and some of the cross-application features that users will see in Office 2007. Office 2007中我们集中研究的主题之一是“精美的文档”，接下来的六篇文章将诠释这对Excel来说这意味着什么，并且用户将在Office 2007中看到office应用程序间交互的特点。Way back when we were starting planning for Excel 2007, we talked to a lot of people about the documents they created using Office, and we looked at many, many examples of people’s work. We asked them about what they found difficult, what they would like to see fixed, and what they thought good-looking output looked like. We also looked at many examples of “professional” output, drawn from textbooks, business journals, scientific journals, and professional design firms. During our planning, it became clear that there was still a lot of additional capability that we could add in this area that would benefit all sorts of users, so we set out to really improve Excel’s capabilities in this area in a number of ways. Specifically, we set out to:早在我们开始设计Excel 2007时，我们和许多用户就他们在使用Office创建文档进行了交谈，并且仔细地研究了大量在实际工作中应用的例子。我们询问他们在使用过程中碰到的困难是什么，他们愿意看到固定的样式是什么，他们认为美观的输出是什么样的。我们也从教科书、商业杂志、科技杂志和专业设计公司中研究了一些“专业”输出的例子。在我们设计过程中，需要改进的思路变得清晰了，在这个方面我们仍然能够添加一些额外的功能，使各类用户都能从中受益。于是，我们通过使用多种方法对Excel在这个方面的功能进行改进。具体地讲，我们着手做了以下工作：Address existing limitations in Excel that made it challenging to create modern-looking documents Make formatting documents much faster and simpler Provide professionally-designed content available out-of-the-box Make it easy to see what your work will look like printed as you create it Make it easier to maintain your spreadsheet and update formatting Address some long-standing print-related customer requests Provide some examples of great-looking documents Make it easier to move your content (i.e. charts) to other Office applications (i.e. PowerPoint) without hassle Do this all in a way that is consistent between Word, PowerPoint, and Excel, so that users can apply features from one application in other applications针对Excel存在的局限性进行改进，使其能够创建现代风格的文档。使格式化文档更简便快捷提供专门设计的可利用的且具有独创性的内容容易看到你的工作成果，就像已经打印出来的一样更容易维护电子表格和进行格式更新满足一些长期从事与打印相关的顾客的需求提供一些美观的文档的示例更容易移动你的内容(例如图表)到其它Office应用程序(例如PowerPoint)在Word，PowerPoint和Excel中的所有操作方法都是一致的，因此，用户能够将某个应用程序的特点应用到另一个应用程序中These goals translated in to the following work:我们为实现这些目标做了以下工作：Changing the number of unique colours allowed a single workbook from 56 to 4.3 billion (32-bit colour) (see post here) as well as adding some new visual effects, like gradient fill. Vastly improved charting. This will be covered in more detail in a later series of posts, but you can check out this post for some visuals that should give you an idea. Improvements to Excel’s existing cell styles feature, and the addition of styles for Tables, PivotTables, and Charts (see here and here for information on Table styles and PivotTable styles) “Galleries” of professionally-designed styles (for all the objects previously listed) A new view – Page Layout View – to supplement Normal and Page Break Preview "Live preview" of formatting Click-and-type headers and footers Some print-related features commonly requested by customers“Document Themes” (colour, font, and effect variations that can be shared between Office applications) Updates to Office shapes (think Drawing toolbar) and WordArt ~25 great-looking templates available out-of-the-box增加在工作薄中可显示的颜色数从(原先的)56色到(现在的)43亿(32位色)(见这里)，也添加了一些新的视觉效果，如渐变填充。极大的改进了图表。这将在后面的一系列文章中详细介绍，也可以先从这篇文章中看出一些端倪。改进了Excel中现有的单元格样式特点，添加了条件格式到列表，数据透视表和图表（详细的表格样式信息和数据透视表样式信息见这里和这里）专业的“图表”样式(以前列出的所有的对象)一个新的视图——页面布局视图——补充到了普通视图和分页预览视图中格式的“现场预览”单击即可输入页眉和页脚顾客普遍需要的一些与打印相关的特点
选项卡和模板
Charting III – Tabs and TemplatesIn the previous two charting posts, I wrote about how you can make a professional chart with four simple choices – chart type, chart layout, chart style, and document theme. As useful as we hope that is, we know that some users will want to tweak and control every aspect of their charts. Today I want to walk through the tabs that are available when you are working with a chart and provide an overview of all the capabilities that are exposed in the ribbon. I am also going to briefly cover templates.图表三：选项卡和模板在前两个贴子里,我写了如何通过4个简单步骤创建专业图表：图表类型、图表版式、图表样式、文档主题。希望对你有益。我们知道有些用户想从各个方面来调节图表。今天我想通过ribbon上的图表选项卡来介绍图表设置。我也会简要介绍一下模板。Design TabWhen you are working with a chart, three additional contextual tabs will be available – Design, Layout, and Format. Here is a shot if the Design Tab.设计选项卡当你制作图表时,有三个选项卡可用：设计、样式、格式。下图是设计选项卡。(Click to enlarge)
文档主题_Excel2007的新特性（一）
Document Themes Part I 文档主题(Document Themes)—第1部分In the last post, I presented an overview of the work we are doing in the area of “great looking documents”. Over the next few posts, I want to walk through a number of the improvements in a bit more detail. Today, I am going to introduce the idea of Document Themes, because a lot of the other features that I am going to discuss are tied into document themes in one way or another. 在上篇文章中，我概述了我们在精美文档方面所做的改进。在接下来的这几篇文章中，我想从更多的细节方面来进一步介绍这些改进。今天，我要介绍Document Themes(文档主题)这个概念，以后将要介绍的许多其他的特点或多或少与Document Themes(文档主题)有关。To put it in the simplest terms, a Document Theme (or “theme” for the remainder of this post) is a new way to specify the colours, fonts, and graphic effects that can be used to format a document. We have integrated themes into the applications (Word, Excel, PowerPoint) wherever it is possible to apply formatting, and we have added a set of features to create new themes, change themes, specify themes for templates, etc. Document Themes(文档主题)(下面简称主题)是一种指定颜色、字体、图形效果的新方法，能用来格式文档。我们已经将文档主题整合到了应用程序中(Word,Excel,PowerPoint)，使它在任何地方都能应用。同时，还可以创建新的主题、改变主题、为模板指定主题等等。There are a couple of goals behind this work. First and foremost, we wanted to give users a better set of tools for building good-looking documents without having to worry about the formatting for each element. For example, in current versions of Office, if a user inserts a table, a chart, and some text into a document, they need to worry about tweaking all the low-level formatting to try and make sure that everything matches and “looks good” (the latter being more subjective). The user interface does not make this easy, and the default out-of-the-box formatting does not help in most cases either. Second, we wanted to make it much easier for users to build Word documents that match PowerPoint documents that match Excel documents. Because the theme architecture is shared between all apps, users will find this much simpler. Third, we wanted to provide “professional design help” out of the box … meaning that we have professional designers creating the themes and the cell, Table, PivotTable, and chart styles that will be shipped in Excel 2007, so that users can take advantage of their work in creating documents. Finally, we wanted to make it easy to change the look of a document without needing to adjust all the element-level formatting. 这项工作的目标是：第一，提供一组更好的创建精美文档的工具，而不需要(逐个地对文档的)每个部分进行格式化。例如，在目前版本的Office中，如果用户插入一张表格、一张图表、和一些文本到文档中，他们需要对这些部分的格式进行逐步调整，并确定每一部分是否协调和“外观精美”(后者是更主观的)。用户界面不会使这样的操作变得容易，并且在大多数例子中这种预设的所见即所得格式也不会有助于更便利的操作。第二，使用户建立的Word文档更容易与PowerPoint文档和Excel文档相互兼容，因为主题架构就是让所有的应用程序间能更方便地共享。第三，提供所见即所得的“专业设计帮助”……这意味着在Excel 2007中将配置由专业的设计者所创建的主题样式和单元格样式、表格样式、数据透视表样式和图形样式，在创建文档时能加以利用。第四，使改变文档的外观变得容易，而不需要调整所有(组成文档的)部分的格式。Let’s take a look at how this is exposed in the Excel user interface in a few places (same goes for Word and PowerPoint for the most part), and then talk through how to create and modify themes, how they related to templates, etc. (Note that a lot of this is primarily exposed through features like styles that I have only touched upon, so things should continue to get clearer after the next several posts.)
列表样式（二）
While I think the thumbnails do a pretty good job at communicating results, I wanted to give you a sample of what is possible out of the box, so here are a few examples of tables with different table styles applied. I have tried to include a few from each category (light, medium, and dark).用一个实例简略地描述如何做一项完美的工作。下面有一些被应用了不同列表样式的表格，是我尝试从每个颜色类别(浅色、中间色和深色)中选择一些而制作的。Just like Cell Styles, Table Styles change when you change the Document Theme. Here is the same spreadsheet as in the previous screenshot with a different Document Theme selected (two mouse clicks). The Table Styles are the same, but the colours have changed, giving me a whole new set of formatting to choose from. We are shipping about 20 Document Themes and 50 Table Styles, so that gives users 1,000 looks to choose from even before they create their own Table Styles and Document Themes.就像单元格样式一样，当你变化文档主题时列表样式跟着变化。下面是前面测试过的同样的电子表格在选择不同的文档主题后的结果(两次单击鼠标)。列表样式是相同的，但是颜色发生了变化，提供一整套新的格式供我们选择。我们配置有约20个文档主题和50个表格样式，因此，可以提供给用户选择约1000种外观去创建他们自已的列表样式和文档主题。One last thing to note is that the styles change as you turn on and off different formatting elements. Specifically, users can turn on and off Table Headers, Total Rows, Row Banding, Column Banding, and First Column and Last Column emphasis. The user interface to turn these elements on and off is located beside the Table Style gallery on the Table Tools tab.不得不提的事情是，列表样式的变化是按照你开启和关闭不同的格式参数来进行。具体地讲，用户能开启和关闭表格标题、汇总行、给行加条纹、给列加条纹、突出第一列和突出最后一列等选项。列表样式参数选项框在用户界面中位于列表工具框中列表样式gallery(。The final thing I want to show you today is some samples of tables that have different elements turned on and off. The 9 tables below are all the same Table with the same Table Style applied, but I have turned on and off various elements of the table. You can see how easy it is to move from a simple matrix without labels to a Table that looks like it belongs in a textbook.最后，展示一些开启和关闭不同参数后所得到的列表的例子。下面9个表格是相同的，并应用了相同的列表样式，只是我开启和关闭不同的参数。正如你所看到的，很容易就将一个没有标签的简单表格转变成看起来像教科书一样的表格。That’s it for today. We would love to hear your feedback. Tomorrow, PivotTable styles.