推荐阅读
word 2013 段落首行缩进两个字符的设置方法
我们中文排版时，通常首行都缩进两个字符，那么这个简单的设置在最新的Word 2013里面又该如何设置呢？下面Microsoft酋长就来介绍一个Word2013设置段落首行缩进两个字符的方法。首先选中需要设置首行缩进的段落，或者把光标定位在该段落也可以。然后在“开始”功能区的“段落”分组的右下角可以看到一个向右下方倾斜的小箭头按钮。如图： 这就是“段落设置”按钮，点击它，就会打开“段落”设置窗口。如图：在“缩进和间距”选项卡中的“缩进”设置区域你就可以看到熟悉的“特殊格式”设置选项了。在下拉菜单中选择“首先缩进”，右侧的“缩进值”就会自动填充为“2字符”。最后点击“确定”关闭“段落”设置窗口，你会发现选中段落的首行已经缩进两个字符了。
word 2010 掌握中英翻译功能
英文弱弱的同学在写毕业论文时是不是很烦恼，不用着急，Word2010翻译功能帮你快速解决问题。 操作方法 1、选择“审阅”—“翻译”—“翻译屏幕提示”，即开启翻译屏幕提示功能。 2、将鼠标停留在单词上，系统会自动弹出翻译结果的浮动窗口。单击浮动窗口中的“播放按钮”，即可播放该单词读音。 3、若想深入了解和学习此单词，单击浮动窗口上的第一个“文本翻译”按钮，将在Word窗口右侧出现翻译窗口栏，显示单词的详细解释。
PPT2003中如何快速转换成JPG图片
操作步骤如果我们想把PowerPoint演示文稿中相应的幻灯片转换为图片格式，直接另存就可以了。执行“文件另存为”命令，打开“另存为”对话框，单击“保存类型”右侧的下拉按钮，在随后弹出的快捷菜单中，选择一种图片格式（如“GIF可交换的图形格式*.gif”），然后按下“保存”按钮，并在随后弹出的对话框中，选择“每张幻灯片”选项即可。注意：保存为图片格式后，可以用图片浏览软件观看相应的演示文稿（只不过动画功能不能使用了）。
Word中2007版进行插入页码的操作技巧
word2007是一款非常实用并且功能较为齐全的办公软件，我们经常用它编辑文档填写表格等，我们在使用的过程中不可避免的会遇到有很多页的文档，那么就需要我们进行插入页码，那么应该具体怎么操作呢?今天，小编就教大家在Word中2007版进行插入页码的操作技巧。 Word中2007版进行插入页码的操作步骤 打开word2007。 点击“插入”，选择“页码”。 根据实际情况选择页码插入到文档的位置和页码样式。 如果你不想在首页插入页码，在首页不同处打钩即可(当然奇偶页不同也可以选择，具体看实际情况)。Word中2007版进行插入页码的操作技巧
最新发布
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>组合键打开【设置单元格格式】对话框，在【数字】选项卡的【分类】类型中选择【自定义】，然后在右侧的【类型】编辑栏中输入已完成;;进行中注意代码中包含两个半角的分号。如下：上述代码是自定义数字格式的一种表示方式，自定义数字格式的常用代码格式为【大于零】;【小于零】;【等于零】
大片上映_Excel 2007新知
在我向大家深入介绍Excel 12 的各项新特性之前，我希望大家能对我们在新版本中的所作所为有一个好的印象。 我们依据无数次的与各种客户沟通的结果来设计Excel 12，沟通中的一个重要主题无疑是客户希望我们的电子表格能够在哪些核心方面有持续的改善和创新——处理数据，设计格式，打印，编辑公式、图表等。另一个主题是我们了解到客户现在有哪些不能在电子表格中完成的工作（处理更多的数据，在服务器上工作等）。这些意见回馈促使我们重新认真审视电子表格的所有元素——从核心架构到数据处理的体验再到信息分享的体验——最后成为我们不断努力的方向。以下部分是我们已经在Excel 12中取得的成果清单（其中许多关联到其他Office团队），在 Excel 12中，我们可以：增加了行与列（详情请阅读其他文章）改善了“条件格式”的界面以使它更快更容易被使用，同时增加了数据有效性的新类型增加了客户最需要的新的函数，改进了公式的编辑方式，基于当前新硬件优化了计算速度增加了数据表操作的相关功能，使其更方便且不易出错（排序、筛选、格式、删除重复值、引用、编辑）用户能够更加方便的按照自己的想法进行排版和打印新的图表引擎支持在Excel以及Office中制作华丽的图表，这是一项巨大的改进重新设计的图表操作界面下，制作图表更加简单和方便新的格式属性与改进的风格设计使得制作专业文档更加方便数据透视表将更容易被创建、阅读，更加强大，而且可以与SQL Server Analysis Services中的数据协同工作新建一套可以直接从 SQL Server Analysis Services 中取数的函数增加了数据连接管理器，连接外部数据将更加方便全新的 “Excel services” 服务器技术可以在*服务端分享、控制和使用Excel文件全新的用户界面——这一点Excel与其他Office核心组件相同基于XML的文件格式——这一点Excel与其他Office核心组件相同以上并没有列出所有的新特性，我今后会逐一向大家进行详细的讲解，希望能给大家的工作带来好的创意。我们为这项工作感到骄傲和自豪！Published Wednesday, September 28, 2005 1:22 PM by David Gainer
Word2013文字重叠的解决方法步骤图
在日常办公中,我们经常用到Word软件,Word办公软件的使用,为我们工作带来了极大的便利,每位办公人员都了解一些或基本或高级的Word办公技巧。Word用于文字编辑，遇到文字重叠堆在一起的现象，怎么解决呢?下面小编就教你具体怎么做吧。 Word2013中解决文字重叠的方法 ①在Word中，我们看到红字堆叠在一起了，我们要做的是将其分开。Word2013中解决文字重叠的方法图1 ②鼠标左键按住不放，选中文字，在右键菜单中选择字体。Word2013中解决文字重叠的方法图2 ③弹出字体选项界面，我们切换到高级标签。Word2013中解决文字重叠的方法图3 ④将缩放设为100%，间距设为标准。确定之后，基本上能解决问题。Word2013中解决文字重叠的方法图4
word2013中显示修改痕迹的方法步骤
在大学毕业答辩前，毕业论文指导老师通常会将学生的论文收集起来，进行检查，有些错误位置就需要修改，但是也不能直接改了，不然学生都不知道是哪里错了，下面小编就教你怎么在word2013中显示修改痕迹。 word2013中显示修改痕迹的方法 ①我们启动Word，打开需要修订的文档，单击“菜单栏”–“审阅”–“修订”，鼠标左键点击下图中的红色方框标记按钮。word2013中显示修改痕迹的方法图1 ②这时弹出修订选项界面，我们可以自定义设置需要显示的内容，批注、墨迹、图片、格式等等，如要进行更多的设置，点击高级选项。word2013中显示修改痕迹的方法图2 ③在高级选项修订界面，设置颜色、度量单位等等，不同内容的修改使用不同颜色，更加利于学生的查看。word2013中显示修改痕迹的方法图3 ④设置完成，进入修订状态，例如给第一段加个文字说明，直接输入即可，输入之后的文字就是你刚刚设置的颜色。word2013中显示修改痕迹的方法图4