推荐阅读
如何解决 Viso Professional 2016 “无法找到此应用程序的许可证”的问题
很奇怪，通过在线方式安装 Visio 2016 Professional 之后，启动应用程序提示“无法找到此应用程序的许可证。修复尝试失败或者已被取消。”的问题：运行 cscript ospp.vbs /dstatusall 也的确显示 Visio Professional 2016 相关的许可证并没有被安装。尝试安装相应的产品密钥也显示失败：所以接下来就介绍下如何解决这个问题：为什么正常安装的 Office 软件，许可证丢失，还需要进一步研究。但根据目前的现象，我们可以尝试安装一下该产品的数字许可证。Office 2016 的所有版本的数字许可证都被保存在以下文件夹中：使用 ospp.vbs /inslic 命令来安装相应版本的许可证（这里以 Visio Professional 2016 MSDN 版本为例，其他版本的许可证文件名不同）：不过，这一方法似乎并没有成功，仍然提示上述错误。于是，尝试重新从官网下载Visio软件进行安装。对于个人正版用户，可以访问：https://stores.office.com/myaccount ：点击“安装”，并运行下载到的安装文件安装即可。再次安装之后，打开Visio软件，正常提示了激活界面，并可以正常激活：
如何在Word 2007中使用超级查找命令？
如何在Word 2007中使用超级查找命令？您可以使用“查找”命令来查找与键入内容完全相同的文本，无法键入的文本，设置命令的格式以及Word 2007文档中的几乎所有内容。寻找确切的文字要找到Curt而不是curt，请在Search Options下选择Match Case选项。这样，Curt仅匹配以大写C开头且包含小写urt的单词。找到一个完整的词“仅查找整个单词”选项使您可以查找诸如right和set之类的单词，而无需查找诸如allright和upset之类的单词。使用通配符查找文本您可以使用通配符来查找只知道一部分或一组字母相似的单词。两个基本的通配符是？和*，在哪里？代表任何单个字母，*代表一组字母。查找听起来像其他东西的文字“听起来像（英语）”选项使您可以搜索同音异义词或听起来与搜索词相同的词。
COLUMNS函数
REPT函数根据指定次数重复文本字符串。REPT函数根据指定次数重复文本字符串。REPT函数根据指定次数重复文本字符串。注：使用REPT函数很容易创建上述效果。什么情况下使用REPT函数?REPT函数能用于使用字符或者以创新的方式来填充单元格，例如：创建单元格条形图或者点图保持快速的统计记录找到列中最后的文本条目REPT函数语法REPT函数语法如下：
excel2013怎么插入图片批注
在使用excel文档的时候，我们经常会给单元格添加批注。但是有时候为了让批注显得更加个性，更加美观一点。我们通常会给批注添加图片，那么excel怎么插入图片批注?小编来告诉你吧。 excel2013插入图片批注的步骤： 首先我们先打开我们的excel文档，打开之后我们单击需要添加批注的单元格，然后单击右键，在弹出的选项里我们选择“插入批注”按钮。 选择插入批注按钮后显示如图所示，此时会弹出一个输入框，我们在输入框里面输入我们要填写的批注。 3批注输入完成之后我们将鼠标移到批注边框上，然后单击右键，在下拉的选项里单击“设置批注格式”。这里要注意的是，单击右键的时鼠标一定要移到批注边框外侧单击才可以。 单击设置批注格式之后会弹出一个对话框，此时我们单击对话框上方的“颜色与线条”选项卡。 选择之后会进入到如图所示，此时我们单击“颜色”后方的小三角形。 单击下三角形之后会下来颜色，在下拉的选项里我们选择“填充效果”选项。 选择填充效果之后会再次打开一个对话框，此时我们单击选项上方的“图片”按钮。因为我们是要插入图片批注，所以此时选择“图片”选项。 选择图片选项之后会让我们选择插入图片，此时我们单击“选择图片”按钮。
最新发布
如何在Word2007中制作书法字帖
下文是小编带来的Word 2007中制作书法字帖的方法，希望可以帮到你，欢迎大家阅读。 中国的书法艺术与京剧、武术、针灸是国际社会公认的四大国粹。书法艺术从古至今，时刻散发着古老艺术的魅力，为一代又一代人们所喜爱。 但在现实生活中，每个人性格的不同使得爱好各异。同样一本字帖，也许有的人临摹起来得心应手，而有的人临摹起来却寸步难行。目前各种风格类型的字帖非常多，怎么知道哪个是最符合自己使用的呢?使用Microsoft Office Word 2007提供的“书法字帖”功能，可以灵活地创建字帖文档，自定义字帖中的字体颜色、网格样式、文字方向等，然后将它们打印出来，这样就可以获得符合自己的书法字帖，从而提高自己的书法造诣。 (1)在Word 2007应用程序中，单击【Office按钮】，执行【新建】命令，在打开的“新建文档”对话框中，选择“书法字帖”。 (2)单击【创建】按钮，打开“增减字符”对话框。在“书法字体”或“系统字体”下拉列表中，选择要使用的字体类型。 提示：在Word 2007*包含了11种书法字体类型，每一种书法字体所提供的字符数量是有限的，因此用户也可以使用系统字符生成各种古诗词或文章的书法字帖加以练习，从而有效地避免了某些字符找不到的麻烦。 (3)在“排列顺序”下拉列表中选择字符排序的顺序。若选择“根据发音”排序，则可以按照汉语拼音去查找字符;若选择“根据形状”排序，则可以选择特定偏旁部首的字符，有规则和针对性地练习某些偏旁部首。 (4)在“可用字符”列表框中，选择要制作字帖的文字内容，单击【添加】按钮，可以将其添加到“已用字符”中。若要删除已添加的字符，只需要在“已用字符”列表框中选中该字符，单击【删除】按钮或者【全部删除】按钮即可。 (5)单击【关闭】按钮，将选择的字符添加到文档中，同时系统将自动打开“书法”选项卡。 (6)在“书法”功能组中单击【网格样式】按钮，在其下拉列表中显示了Word 2007提供的“米字格”、“田字格”、“田回格”、“九宫格”和“口字格”5种不同的网格样式。用户可以根据个人的喜好，选择适合自己的网格样式。
对编辑公式功能的改进Part 4_名称
polFormula building improvements Part 4: Defined Names对编辑公式功能的改进 Part 4：名称Defined names are a very useful tool for authoring formulas. Defined names allow users to name cell ranges, formulas, and values and refer to those names in their formulas. Used in formulas, defined names make formulas easier to read and more robust. Additionally, when writing formulas, names are less likely to get mis-typed than cell references, and they are easier to remember than cell references (“Tax_Rate” as opposed to “G36”). In this article, I would like to discuss some of the work we’ve done to defined names in Excel 12 – specifically, how we have added new management and creation UI, and how we have added comments to names.在公式书写时，名称是一个很实用的工具。用户可将单元格引用、公式和常量定义成名称，并在创建公式时引用它们。应用名称可使公式变得比较容易理解和维护。此外，相对引用单元格区域而言，在写公式的时候使用名称比较不会出错，而且方便记忆（例如，用“Tax_Rate（税率）” 而不用“G36”）。本文讨论名称的改进——重点介绍新增的创建和管理名称的界面以及如何给名称添加注释。The new Manage Names Dialog新的名称管理对话框Probably the most common piece of feedback we receive about defined names is that the user interface we provide to manage names is inadequate. When we visit customers on site, we often see workbooks with dozens or hundreds and even thousands of defined names, which makes tasks like deleting multiple names, renaming names, and finding broken ones challenging. Enter the new Manage Names dialog, which is designed specifically for viewing and managing the defined names in a workbook.最常见的关于名称的抱怨可能是名称管理界面的缺陷带来的。我们拜访客户时，常会见到客户的工作簿的名称达到成百上千之多。在执行删除名称（多个），重命名和查找错误结果值名称等任务时，这会带来许多麻烦。新的名称管理对话框，正是专门设计用来查看和管理工作簿中的名称的。The entry point to the Manage Names dialog is in the centre of the new Formulas tab. Here is a shot of the Formulas tab in current builds – you can see a big button titled "Name Manager".
对编辑公式功能的改进Part 3_Excel 2007新知
Formula editing improvements Part 3: new functions对编辑公式功能的改进 Part 3：新增函数In addition to improving the formula editing UI in Excel 12, the team has spent some time adding to Excel’s function library. Over the years, customers have found new ways to combine and leverage the functions in Excel to build all sorts of things, but there remain many areas where our customers would like to see need new capability. This release, we have targeted three areas in which to improve our function library – the Analysis ToolPak, SQL Server Analysis Services, and the most common requests we hear from customers.除了改进编辑公式的界面外，我们还在Excel 12的内置函数库上花了些功夫。多年以来，用户挖掘出许多新方法，整合和发挥Excel函数的功能，创建各式各样的公式。虽然如此，用户还是期望拥有更多新的函数。此版本中，我们瞄准了三个方面来扩充Excel内置函数库，它们是——分析工具库，SQL Server Analysis Services和用户提出的最具代表性的需求。First, we have fully integrated the Analysis ToolPak functions into the Excel function library, making these functions first-class citizens and eliminating issues relating to the fact that they had been delivered as an add-in in the past. Users already find a great deal of value in these functions and, from Excel 12 on, they can rely on them to simply work the way the rest of the Excel function library works. This means users no longer have to run the add-in to use the functions, the functions will show up in Formula Autocomplete (see previous post), the functions will offer the same tooltips as other native Excel functions, etc.首先，我们把分析工具库函数整合到Excel内置函数库中，使其成为“一等公民”，并取消了原来的加载宏。这些函数对用户十分有价值。从Excel 12起，它们就可以和其它Excel内置函数一样方便地使用。这意味着，用户不需要加载宏，可以直接使用这些函数。它们会出现在Formula AutoComplete功能提供的下拉列表中（见前面的帖子），且和其他内置函数一样也有相应的功能提示。Second, we have added a new set of functions that allow users to extract information from SQL Server Analysis Services. For the benefit of readers that are not familiar with SQL Server Analysis Services, let me give you a really high-level overview. In addition to its relational database product, SQL Server includes a feature named Analysis Services which provides business intelligence and data mining capabilities (for those interested, more information can be found here). In Excel 12, we have added a set of functions that give users the ability to retrieve SQL Server Analysis Services data directly into cells. There is a fair bit to cover in this area, so I will write a few posts on these formulas in a few weeks.第二，我们还新增了一套函数，允许用户从SQL Server Analysis Services中获取数据。考虑到一些读者并不熟悉SQL Server Analysis Services，我先简单地概括一下。除了相关数据库产品外，SQL Server 还包括一个称为Analysis Services 的功能，提供商业智能和数据挖掘能力（有兴趣的读者可以在这里找到更多信息）。在Excel 12 中，这些新增的函数可从SQL Server Analysis Services 直接获取数据，存放到单元格里。由于涉及面较广，接下来的几周里，我会再写些帖子介绍这些函数。Third, we’ve added five commonly requested functions to the Excel function library:
精美实用的Excel列表格式，唾手可得
Tables Part 7: Good-looking, well-behaved table formatting made easy …列表(第7部分)：精美实用的列表格式，唾手可得If you’ve been reading the last few posts on tables, you may have noticed that the screenshots all had tables with formatting applied to the entire table. You may have thought I spent lots of time manually formatting the tables to look nice for this blog but in fact I hardly lifted a finger – I was using a brand new table feature in Excel 12 called “table styles” which made it possible to add formatting with one click. Table styles is a feature that provides a way to quickly format my entire table using a preset style definition. It is similar in concept to the AutoFormat feature Excel had in the past, with a couple key differences:如果你已经读过上篇介绍列表的文章，你可能已注意到了应用于整个表格的所有列表格式的截：Before Filter筛选前… and I filter out all even-numbered rows, here is what my table will look like after I filer it:筛选掉所有的偶数行后的列表如下图：After Filter
数据透视表IV——任务向导用户界面，或“为我们
PivotTables part 4: Task-oriented UI, or “improvements the Ribbon affords us”, and some bonus talk about dialogs数据透视表4：任务向导用户界面，或“为我们提供改进的 Ribbon”，及对话框的一些其它优点。As I mentioned a few posts back, one of the key goals for PivotTables in Excel 12 was to use the Ribbon and new dialogs to expose PivotTables’ capabilities to a much broader range of users. Today I want to take a closer look at the new user interface – especially the ribbon – and how we have tried to make commonly-used features and functions much more visible and available with very few clicks of the mouse. I am also going to briefly cover some changes and additions to the PivotTable Options and Field Settings dialogs.正如我在前面的文章中提到的，Excel12中数据透视表的一个主要目标就是通过使用RIBBON和新的对话框来提高性能，使更多的用户易于使用它。今天我想更进一步介绍新的用户界面——特别是RIBBON——以及我们如何使常用的特性和功能更容易被发现和利用，并只需点几下鼠标就能实现。首先，我简要的介绍一下数据透视表选项和字段设置对话框的一些改变和新增功能。PivotTable tab I – the Options tabWhen a PivotTable is active (meaning the active cell is inside a PivotTable), you will see two extra PivotTable tabs in the ribbon: Options and Styles. Here is what the PivotTable Options tab looks like in the beta build (note, there is a fair bit not done in this tab, so it is definitely not what you will see in the next beta or when we release Office 12). 数据透视表标签I：选项标签当数据透视表激活时（意味着活动单元格在数据透视表中），在RIBBON上你会看到两个额外的数据透视表标签：选项和样式。如下图是透视表选项标签在测试版中所看到的样子（注：其中有相当一部分未完成，所以你在下一个测试版或最终版的Office12中看到的会不一样）。This tab is designed to hold all the commands you would commonly use when working with a PivotTable. In addition to giving us more room to expose all the functionality that already exists in Excel PivotTables, it also provides space to advertise new features we have added in Excel 12. In our testing, we have found that it allows all users (both beginning and power users) to take advantage of a wider range of features than in previous versions of Excel. We are pretty excited to see this sort of improvement.
IX 对SQL服务器分析服务的更强大支持（二）
All that said, let’s return to Excel 12, and take a look at what the PivotTable Field List looks like when connected to an Analysis Services 2005 model.我们说了那么多，让我们回到Excel 12，看看当连接到Analysis Services 2005模型时数据透视表的字段清单长什么样。Measure groupsWhen connected to Analysis Services, a PivotTable exposes three types of fields – “measures”, or the numbers (like “sales” and “profit”) that appear on your PivotTables, as well as “KPIs” and “dimensions” (both discussed below). Measures can be grouped together in Analysis Services (by the person that designs the model) into something called “measure groups”. In the Excel 12 field list, each measure group has a “sigma” icon to communicate to the user that the fields in the group are numerical and that they belong in the Values area of the PivotTable. Measure groups essentially represent different sets of business metrics available for analysis; typically a measure group contains related measures from the same business application. In the image below, the Exchange Rates measure group folder is open and there are two measures listed which can be added to the PivotTable – Average Rate and End of Day Rate.衡量组合当连接到Analysis Services时，数据透视表会显示三类字段——“衡量”，或者数字（如“销售”和“利润”），还有“KPIs”和“维度”（下面都会讨论）。衡量可以在Analysis Services里组合（由设计该模型的人）为名叫“衡量组合”的东西。在Excel 12字段清单里，每个衡量都有一个“西格马”图标，告诉用户该组合里的字段是数字型的，并且它们都属于数据透视表中的数值区域。衡量组合本质上代表不同的分析可用的业务方法（译者：作者经常提到Business Metrics，不明所以，暂且译为业务方法）；衡量组合通常包含来自相同业务软件的相关衡量。在下面的图像上，Exchange Rates衡量组合是开启的，有两个衡量，它们可以添加到数据透视表——Average Rate和End of Day Rate。Key Performance Indicators (KPIs)Below the measure group folders are is a KPI folder (assuming KPIs have been defined in an Analysis Services model). This folder contains Key Performance Indicators defined on the Analysis Services server. (Key Performance Indicators are a big subject unto themselves – for the sake of this article, suffice to say that they track key business metrics and that they are defined in Analysis Services). The different components of a KPI (Value, Goal, Status and Trend) can be added to the Values area of the PivotTable so you can track the latest values of your key business metrics. Here is a screenshot of the KPIs folder … in the image, the Product Gross Margins KPI is open and all you have to do to add the Value, Goal, Status or Trend of the KPI to the PivotTable is to check the checkbox next to it.关键性能指标（KPIs）
数据透视表IV——任务向导用户界面
Field Settings and PivotTable Options dialogsThe goal of the ribbon is to provide all the functionality needed for most users. More advanced options are available in the Field Settings dialog and the PivotTable Options dialog. While both of these dialogs existed in previous versions of Excel, we have updated them to achieve two things. First, to group the options more intuitively together, and second, to include settings for new features as well as some features previously only available through the object model. We have used tabs to group options logically. Let’s take a brief look. (Note, this is more detailed than the rest of the post, but since I am feeling productive today, and since many of the changes we made were in direct response to places where we had received a bunch of customer feedback, I decided to walk through the dialogs and highlight some of the changes we made.)字段设置和数据透视表选项对话框RIBBON的目的是为绝大多数用户提供所有的功能。更高级的选项可利用在字段设置对话框和数据透视表选项对话框。这两个对话框在以前的Excel版本中就存在了，现在我们已经将其升级以实现两个功能：第一是将各种选项更直观地归类，第二是包含新功能的设置和以前只能通过对象模型才能实现的那些功能的设置。我们已经使用标签将选项逻辑地分组。让我们大致来看一下。（注：这比本文其余部分更详细，但由于我觉得今天比较能写，而且我们所做的许多更改是对我们收到的一连串用户反馈的直接回应，所以我决定详细讲一下这些对话框并重点说明我们所做的一些改变。）Here is a screenshot of the first tab of the new Field Settings dialog for a field on rows or columns – this allows users to set a number of options on a field-by-field basis.这是一个行或列字段新的字段设置对话框的第一个标签的截图——在这里允许用户设置各个字段的基本选项。On this tab there is a checkbox for “Display items from the next field in the same column”. With this you can control on an individual field basis whether to display items of that field in the new compact form or not (see my previous post for an explanation of the three forms – Compact Form, Tabular Form and Outline Form). And here is the second tab of the Field Settings dialog.在此标签中有一个复选框，在同一列中显示下一个字段的项目。这里你可以控制每一个单独字段的基本要素，即是否在新的紧凑形式下显示该字段项目（详见我以前的文章 previous post，那里讲明了三种形式：紧凑形式、平板形式、大纲形式）。下面是字段设置对话框的第二个标签。The new “Include New Items in Filter” checkbox allows you to control whether new items appearing in the source data will automatically show up in the PivotTable when the field is manually filtered ("manually filtered" meaning not all items are checked in the filter UI).
最终界面以及更多的行与列
最终界面我曾经在以前的文章中不断的展示给大家Excel 2007 Beta1的界面截图，并且注明“这不是最终的界面”。今天，这个界面已经向最终界面跨出一大步。在今天早上的德国CeBIT中，微软公司向公众展示了即将成为最终界面的Office 2007，以下是Excel的截图：下面是可用的另一个风格：你所看到的Beta 1的界面发生了许多改变，其中包括更具美感的颜色和背景——以及其他更多的细节。比如，“快捷工具栏”放到了标题栏，群组（原名“chunk”）标题放到了上面，新加了一个大大的Office按钮，一个包含视图和窗口管理的“视图”标签，等等。Jensen Harris’ UI blog 中有其他Office组件的截图，以及相关的说明。“Beta1” 的测试者们需要升级到以上截图的出处—— “Beta1 technical refresh”，后者马上就会向大家提供。我们仍将继续对界面做出一些调整，比如改换一个图标，移动一个按钮，直到最终版本发布。但整体上来讲，现在的版本已经非常接近最终版本了。更多的行与列许多人问我在最终版中是否会增加单个工作表的容量，我想我有必要再次声明一下：“是的，我们已经增加了工作表的容量。Excel 2007的工作表将有1,048,576 行，16,384 列，那是Excel 2003工作表行数的1,500% 和列数的 6,300%。现在最后一个列标将从原来的IV变成XFD”。
数据透视表III—更多可选择、更简洁精美的样式
PivotTables part 3: More clickable, more compact, and nicely styled数据透视表3：更多可选择、更简洁精美的样式Today, I would like to cover some of the improvements we made in Excel 12 to make PivotTables easier to read and explore.今天，我介绍一下Excel 12的一些改进，这些改进使得数据透视表更易于阅读与理解。Expand CollapseOne of the nice exploration features of PivotTables is the ability to expand and collapse items in order to view values at different levels of detail. In Excel 12, we have added expand/collapse indicators to the PivotTable to make it easy to discover when there are more details to explore (and to make it obvious that this feature even exists!). The expand indicator is a “+” and the collapse indicator is a “-”.展开折叠数据透视表中一个值得探索的特征就是展开和折叠项目的功能，使用户能够按照不同的明细等级察看数据。在Excel 12 里，我们给数据透视表增加了展开/折叠指示器，让用户很容易就能看出是否含有隐藏的明细数据。这个展开指示器是一个“+”，折叠指示器是一个“-”。Let’s look at an example. In the PivotTable below, I have added three fields to the row area and the sales amount field to the values area. Currently only items of the first field, year, are showing. To display the details below 2001, all I have to do is to click the expand indicator:
VII －条件格式与数据透视表（二）
Let me briefly explain the three options. (Note, we are still working on the wording of the last option. It’s also worth noting that these options are also exposed in the conditional formatting creation and management UI, so you don’t have to rely on the on-object UI.)我简单解释一下这三个选项。（注意，我们还在考虑最后一个选项的措辞。同样，值得注意的是这些选项同样会出现在条件格式创建和管理的用户界面上，因此你不必依赖于该对象上的用户界面。）• Selected cells – this will leave the conditional formatting applied to just the selected cells• All “Sum of Sales Amount” cells – this will apply the conditional formatting to all Sum of Sales Amount cells in the PivotTable, regardless of level, and including subtotals. This will be useful in cases for measures that aren’t sums – if you have an “Average Retention” measure, for instance, all values (including subtotals and grandtotals) will be between 0 and 1 and can be sensibly formatted using a single rule.• All “Sum of Sales Amount” cells with the same fields – this will apply conditional formatting to all Sum of Sales Amount cells at this level in the PivotTable, which excludes subtotals. I suspect this will be the most commonly used.• 所选单元格——仅所选单元格会保留条件格式• 所有“Sum of Sales Amount”单元格——这将应用条件格式到数据透视表里所有的Sum of Sales Amount单元格，不管其层次，并包括小计在内。当这些衡量标准没有加和时，这会很有用——例如，如果你有一个“Average Retention”衡量的话，那么所有的数值（包括小计和总计）都会在0和1之间，并且可以敏感地使用单一规则设置格式。• 所有“Sum of Sales Amount”中具有相同字段的单元格——这将应用条件格式到数据透视表该层次中所有的Sum of Sales Amount单元格上，不包括小计。我觉得这将会最常用的使用In this case, I want to apply the rule to all cells displaying sales for individual bike models and individual years. To do this, I’ll pick: All “Sum of Sales Amount” cells with the same fields. After I have made this selection, the PivotTable will now show the conditional formatting in all cells showing sales for an individual product category and an individual year.