推荐阅读
如何快速找到 Office 2007 中命令的位置？
Microsoft Office 2003 你能够运用自如，刚开始接触Microsoft Office 2007 时是不是还有些不太适应啊？在 Office 2003 中能够实现的某个功能，你在 Office 2007 中如何找到呢？ 别着急，Office 2007 提供了一个可视的交互式参考指南，它是您熟悉Office 2007操作的得力助手。让你在 Office 2007 中找到Office 2003 中对应的大部分功能。 下面我们以 Excel 2007 为例，演示一下怎么做： 1、这个功能需要联网，所以确保你连上了互联网。 2、在 Excel 2007 里点右上角的帮助按钮。 3、如果帮助窗口的右下角显示“脱机”，就点开它，选择显示来自 Office Online 的内容。 4、在浏览 Excel 帮助目录中，点获取帮助 -> 在目录中点交互：Excel 2003 到 Excel 2007 命令参考指南。 5、点启动指南。 6、会打开一张网页。点开始。 7、将鼠标指针放在某个 Excel 2003 菜单或按钮上就可以了解其命令在 Excel 2007 中对应的位置。如果你点一下这个命令，就会播放一段动态演示，教你如何在 Excel 2007 中进行操作。 同样的方法也可以用在 Word 2007 和 PowerPoint 2007 及其它 Microsoft Office 程序
excel条件格式、套用表格格式，两种方法实现智能添加单元格边框
我们在EXCEL数据表中录入数据时，新添加数据单元格是默认不加边框，而为吧保持表格的完整与美观，我们经常手工添加边框，如下动图：这样在某种程度上降低了我们数据处理的效率。今天，韩老师讲两种方法，实现添加数据，自动智能添加边框。方法一：条件格式条件格式设置，效果如下动图：设置过程：1、单击工作表行列交叉点，选定整个工作表;2、【开始】——【条件格式】——【新建规则】;
Excel查找函数三剑客（Vlookup/Index/Match）之“Match函数”的
在物流行业，Vlookup函数无疑是老大哥，使用最频繁，用处最大。但是，还有两个查找引用函数，其用途也很大，那就是Index函数和Match函数。个人觉得，Excel函数虽然博大精深，但只要你真正掌握了Vlookup、Index及Match函数的用法，会对自己的工作效率有极大的提升。因此，这三个函数，我称之为“Excel超找函数三剑客”。这三剑客在物流数据分析和财务分析中有着广阔的用途。言归正传。本篇先介绍Match函数的含义吧。请先看下官方的解释- Match：返回在指定方式下与指定数值匹配的数组中元素的相应位置。如果需要找出匹配元素的位置而不是匹配元素本身，则应该使用MATCH函数。语法是：MATCH(lookup_value，lookup_array，match_type)。参数：Lookup_value为需要在数据表中查找的数值，它可以是数值(或数字、文本或逻辑值)、对数字、文本或逻辑值的单元格引用。Lookup_array是可能包含所要查找的数值的连续单元格区域，Lookup_array可以是数组或数组引用。从官方严谨晦涩的解释中，我们可以这样简化理解：Match(目标值，查找区域，0)– 返回的是目标值对应在查找区域中的位置索引号（一般是行数），也就是match函数最终得到的结果是目标值所在的行号或者列号，第三个参数一般为0。举个例子：见下面的截图，在B5单元格中输入=MATCH($A$3,A2:A10,0)，返回的结果是2。意思是A3在A2:A10中的位置是第2行，所以返回是2。当找不到时，就返回#N/A。Excel查找函数三剑客（Vlookup/Index/Match）之“Match函数”的介绍可以看出，Match函数其实非常简单，很容易理解，我就不多说了。注意的是，Match函数往往是和Index函数一起使用的，很少单独使用。下一篇讲重点讲解Index函数的用法、以及Index与Match函数相结合的物流用法案例。
打开word弹出宏的错误提示对话框怎么办
打开word提示“您试图运行的函数包含宏或需要宏语言支持的内容。而在安装此软件时，您选择了不安装宏或控件的支持功能”的错误信息。下面小编教你教解决这个问题的方法。 打开word弹出宏的错误提示对话框的解决方法： 单击左下角的“开始”菜单，单击“控制面板” 在控制面板里双击“程序和功能”选项 卸载或更改程序列表中右击Microsoft office，单击“更改”按钮 弹出的更改Microsoft Office的安装对话框选中“添加或删除功能”，点击“继续” 在安装选项下展开“Office 共享功能” 点击“VBA 工程的数字证书”和“Visual Basic for Applications”前面的按钮，选择“从本机运行”,点击“继续”，最后等待安装完成即可打开word弹出宏的错误提示对话框怎么办
最新发布
非常酷的状态栏和精美图表
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.
巧用Excel图标集标识项目完成状态
“，在“完成情况”一列中会通过文字来标识项目完成情况。如果前面六个阶段全部打勾，则标识“已完成”，否则标识“进行中”。要实现这个功能，使用公式可以很容易实现，但是考虑到要用条件格式的“。为了增强表格可读性，H列的显示内容还是可以设置为中文字符“已完成”或“进行中”,并同时保持单元格数值仍旧为1或0，其方法就是通过自定义数字格式来实现。选中H列中需要设置的单元格区域，按<Ctrl+1>组合键打开【设置单元格格式】对话框，在【数字】选项卡的【分类】类型中选择【自定义】，然后在右侧的【类型】编辑栏中输入已完成;;进行中注意代码中包含两个半角的分号。如下：上述代码是自定义数字格式的一种表示方式，自定义数字格式的常用代码格式为【大于零】;【小于零】;【等于零】