推荐阅读
如何使用手机遥控wps演示文稿播放
为了方便演示，我们可以使用手机来遥控wps演示文稿的播放，那么，这样的效果是如何实现的呢?下面就让小编告诉你如何使用手机遥控wps演示文稿播放。 使用手机遥控wps演示文稿播放的方法 1，我们在电脑上打开WPS PPT文件，可以看到下图中红色圈起的图标，如图所示： 2，点击下图中黑色箭头指向的倒三角图标，有三个选项，如图所示： 3，选择“手机遥控”后，出现如下提示，如图所示： 4，在手机上打开WPS，然后选择“手机遥控”，如图所示： 5，用手机扫描电脑上的二维码之后手机和电脑就连接上了，手机变成遥控器，如图所示：
Excel中subtotal函数的运用方法
subtotal这个函数，大家在Excel中接触的不多。但其功能还是很强大的。具体该怎么去进行操作的呢?今天，小编就教大家在Excel中subtotal函数的运用方法。 Excel中subtotal函数的运用步骤如下： 使用“数据”菜单中的“分类汇总”命令可以做有分类汇总的列表，这个时候我们可以使用subtotal这个函数。 这个函数SUBTOTAL(function_num, ref1, ref2, …)，其实function_num对应的有一些数字，其实数字代表的数字的含义如图所示。 这里需要注意的是：1 到 11(包含隐藏值)或 101 到 111(忽略隐藏值)之间的数字， 我举例说明一下我们要对一部分，数据进行求和，大家平时用得最多是SUM函数。但我们同样可以使用=SUBTOTAL(9,B3:D3)。 这里我们使用的是9，其实就相当于使用SUM函数，但 那这个函数有什么特殊的用途呢，我们今天举一个分类汇总的例子。如图我们对下列数据进行筛选。 我们看一下，如果使用SUM求的话，不因为筛选结果，都会对数据区域进行求和。 我们再看一下SUBTOTAL，我们可以发现他只对筛选数据结果数据进行求和。这个功能对我们的实际工作的作用是很大的。
word怎样设置一级标题
在Word中编辑文件，总会涉及到设置几级标题的问题，一级的又该如何设置呢?下面随小编一起来看看吧。 word设置一级标题的步骤 打开Word，点击“文件”-“打开”。 选择要设置的文档打开。 选中要设置一级标题的文字，点击“样式”组的“标题1”。 点击标题1右边的倒三角形，选择“修改样式”，出现详情页。 在其中设置字体、字号、间距、颜色等，设置好后，点击右下的“确定”即可。 其他的缩进、段前间距等，点击左下的“格式”，选择“段落”进行调整，调整好后点击“确定”即可。word设置一级标题的
word没保存怎么办
有时我们在编辑Word文档的时候，会因为一些突发事情而不能及时保存，有没有办法实现不小心退出了之后还能够自动恢复上一次的保留状态呢?下面让小编为你带来word恢复没保存文件的方法。 word文件恢复步骤如下： 01打开Word，点击office按钮，点击“Word”选项。 02点击“保存”按钮，可在该界面设置自动恢复的保存时间的间隔，自动恢复的保存位置。 03设置时间间隔，越短越好，文档越不易丢失。 04点击如图所示的“修改”，可设置文档恢复后所保存的位置。关于word没保存的相关文章推荐：1.如何恢复没有保存的word文档2.如何恢复word未保存文档3.怎么找回未保存的word文档
最新发布
专业图表轻松做
Charting I – Professional charts, made easy图表一：专业图表轻松做A few posts ago when I described the work we did in the area of “great looking documents”, I mentioned charting. I am going to spend the next week or two covering charting in detail. For this first two posts, I want to cover how we have used the ribbon to make it possible, with no more than 3-4 clicks, to create a wide variety of professional-looking charts.我在以前的几个贴子中描述“精美的文档”时提到过图表。在最近一到二周将详细介绍Excel2007图表。在一开始的二个贴子中，将讲述如何只用3-4步，轻松创建精美的专业图表。When talking to customers about charting in Excel, one of the big pieces of feedback we hear is how hard it is to make a chart that looks ready to publish. Generally, users aren’t graphic designers or experts in information visualization, yet they still want a result that looks professional and communicates their information effectively. With advent of the ribbon, we have a new UI design approach – results-oriented design (which is discussed in a blog post here). In a nutshell, the idea is to give users a couple of reasonable choices for professional designs, then allow them to mix and match those choices into a professional document. While we’ll still give users access to the detailed features that make their documents look good, they should be able to get close to a final result in just a few clicks. To that end, chart creation in Office 2007 can be as simple as making four straightforward choices that give users access to a vast range of possibilities. The four choices are: what type of chart they want, how they want the elements on that chart laid out, how they want their chart formatted, and what document theme they would like to use. I’ll talk about two of these choices in this post, and the other two choices in the next post.用户在使用Excel图表时，首要的问题是利用现成的模板来创建图表。一般，用户不是专业的图形设计师，他们只想得到一个能展示其数据效果的专业图表。在Exce2007中，有一个全新的预览效果向导的用户界面。总之，这项目设计是为用户提供一系列的选择来完成专业设计的工作，然后通过组合和调整创建专业图表。我们将详细介绍这些功能来创建精美的图表，使用户能通过几次点击便能完成图表。在Exce2007中通过简单的四个步骤创建图表，从而引导新用户入门。这四步是：选择图表类型，选择图表版式，设置图表样式，设置文档主题。在本贴我将介绍前面二步，其余二步在下一贴介绍。Chart TypesIn current versions of Excel, when a user creates a chart, the first thing they need to do is select the type of chart – column, line, scatter, pie, surface, and etc. In Excel 2007, we’ve made the variety of chart types available a lot more visible, and we have offered help for users to choose between them. To insert a chart, a user would start with the Insert tab. Excel 2007 has an insert chart type “group” (7 related controls) on the ribbon’s insert tab. This makes it easy to pick a chart type, with large icons and tooltips that describe when to use a particular type.图表类型
数据透视表样式
PivotTable Styles数据透视表样式Yesterday we looked at Table Styles. Today, I wanted to revisit PivotTable Styles (see a post here where I introduced PivotTable styles a few months ago – you might want to re-read that before proceeding). This post will be a bit shorter, because most of what I talked about yesterday with respect to Table Styles is also true for PivotTable Styles.昨天我们关注了列表样式，今天，我想重温数据透视表的样式（单击这里可以看到一篇几个月前我介绍的数据透视表风格的文章——你可能想要在继续阅读本文前重读那篇文章）。本文较短，那是因为昨天我着重谈及列表风格的关系，而列表风格大部分类似于数据透视表风格。PivotTable Styles have the same design goals as Table Styles, and they also have the same user model and customization story. Here is a shot of the PivotTable Design Tab where users can control the look of the PivotTable (the “Banded Col数据透视表与列表不仅在样式上具有相同的设计目标，而且用户模型和自定义过程亦相同。下面的图片是数据透视表“设计标签”的截图，用户可以控制数据透视的面貌（图中的“Banded Columns”（条纹列）复选框是一个bug…它必需低于“Banded Rows”（条纹行）复选框）。The only real difference between the PivotTable and Table Styles is with regards to the number of elements in a PivotTable style. Whereas Table Styles have 13 elements (headers, row banding, total rows, etc.), PivotTable styles have 25 elements. The additional elements are due to the fact that PivotTables are more complex than tables, so there are more table elements available for users to define formatting on. For example, you can define formatting for multiple levels of data, there are multiple levels of subtotals possible in a PivotTable, etc.数据透视表与列表的风格真正的区别仅仅是，可用的元素的数量多少。虽然列表的风格共有13种元素可供利用（标题、行条纹、汇总行等），但是数据透视表风格却有25种元素之多。由于数据透视远较列表复杂，所以数据透视表得增加更多的元素，以便可供用户利用，实现各种格式设置。譬如，你可以在数据透视表中定义多种级别数据的格式，也可以设置尽可能的多种级别的分类汇总。With that said, I wanted to leave you with some examples of PivotTables formatted with different default Styles. Again, I have tried to use a few of each of the Light, Medium, and Dark styles. One thing to note that is quite different when compared to Table Styles is the use of colour and font to identify levels in the data.
Excel2007的自定义工作表函数（第一部分）
Excel 2007 investments in UDFs #1EXCEL 2007的自定义工作表函数（第一部分）For the next few posts, we have a “guest post” from Danny Khen, a program manager on the Excel Services team. Danny is going to talk about UDFs in Excel and Excel Services. Enjoy.在接下来的几个帖子中，Excel Services团队的项目经理Danny Khen将讲述Excel和Excel Services中的自定义工作表函数，希望大家喜欢。UDFs are user-defined worksheet functions – custom functions that you create to supplement Excel’s set of intrinsic worksheet functions. UDFs are used to create calculation libraries, or to import data into Excel sheets in custom ways.UDF就是自定义工作表函数的缩写，就是用户创建的用于满足特定需求的函数，它是Excel内置工作表函数的一个补充，UDF可以用于生成一个计算库或者按照用户定义的方式将数据导入Excel工作表。In Excel 2007, we’ve made a number of key investments around UDFs. They revolve around two main areas: allowing UDFs to take advantage of important Excel improvements, and extending UDF-based Excel solutions to the server side with Excel Services.在Excel 2007中，我们围绕UDF花费了很多精力，主要有两个方面：Excel的重大改进可以应用于UDF和利用Excel Services将基于UDF的Excel解决方案扩展到服务器端。Updated XLLs
单元格样式
Cell Styles – More Usable, better defaults单元格样式—更多可用的且已预设好的样式A few posts ago, 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 we have made to styles. Today, let’s cover Cell Styles.在前面的一些文章中，我概括地讲述了我们在精美文档方面所做的改进。在接下来的文章中，我想谈谈我们在样式方面所做的一些改进。今天，让我们先来谈谈单元格样式。“Cell Styles” were introduced in Excel v3. The basic idea, much like styles in Word (and other products), was to give users the ability to create and apply styles to cells, which accrued a few benefits. First, it gave users a way to create a consistent-looking document without needing to do nearly as much direct formatting. Second, it gave users the ability to quickly change the formatting of all cells that use a particular style … so, for example, if you wanted to change the number format for all your currency cells, you could do that with one quick change and not have to touch every cell. Styles can contain the following formatting: Font, Border, Number format, Alignment, Fills, and Protection. “单元格样式”最初在Excel v3版本中引入。像Word(和其它产品)中的样式一样，其基本的思想是提供对单元格创建和应用样式的功能，这样做有很多优点：第一，创建风格一致的文档而不需要去做大量重复的格式设置；第二，能运用一种特定的样式快速改变所有单元格的格式……等。例如，如果你想改变所有已使用单元格的数字格式，只须应用一种特定的样式而不必逐个地对单元格进行设置。样式包括了下列格式：字体、边框、数字格式、对齐、填充和保护。In Excel 2007, we have made some updates to Cell Styles. What follows is a description of the changes.在Excel 2007中，我们对单元格样式作了一些更新。下面将描述所作的这些变化。Excel 2007 uses the new ribbon UI to make this feature more discoverable and simpler to use. In current versions of Excel, users have to launch a modal dialog to apply Cell Styles, and there is no preview of what a style looks like before the user applies the style. In Excel 2007, we have put a gallery in the Excel ribbon. This has a number of benefits. First, styles are easier to apply – one or two clicks, no dialog involved. Second, styles are more discoverable. Third, users see exactly what the style will look like when applied. Here is what the gallery looks like in the ribbon (note that when we are done, the user will see 10 styles in the gallery by default, not 6).
图表二_专业图表轻松做(续)+Excel2007键盘访问模
Charting II – Professional charts, made easy (continued) + Excel 2007 keyboard access model …图表二: 专业图表轻松做(续)+Excel2007键盘访问模式Keyboard AccessToday I want to start with a link to Jensen Harris' UI blog, where Jensen has put up a post that describes the Office 2007 keyboard model. I am personally a big keyboard user, and I know the same is true for a lot of Excel users, so this is a topic that is near and dear to my heart. You can read the details for yourselves, but I want to summarize the key design points.·Every one of the Office 2003 keyboard shortcuts (i.e. CTRL+B) continues to work the same in Office 2007; there's no relearning necessary.·All of the Office2003 menu accelerators (i.e. ALT+I+R to insert a row) will work just like you were running Office 2003 … no need to activate any sort of legacy keyboard mode or anything like that – your menu accelerators just work (note, for the beta users out there, this is a change from beta1). This is very useful for those of us that have memorized menu accelerators over our lives using the product.·Every single command in the Ribbon receives a letter – a KeyTip – which is used to activate that command via the keyboard. Basically, when you press the Alt key, the keytips show up on the ribbon, and you then simply need to press the appropriate letter to execute the command. Here is a picture of the keytips on the formulas tab.键盘访问今天我将通过Jensen Harris的博客介绍Office 2007键盘模式. 我个人经常使用键盘,我知道有很多Excel的用户也一样，所以这是一个亲切的主题。你可以自已阅读相关的细节,这里我仅说明设计的要点。.
列表样式（一）
But wait, there’s more (styles) … Table Styles in Excel 2007请耐心等待，将有更多的样式……Excel 2007中的列表样式Last post we looked at Cell Styles – both the changes we made to the feature as well as the set of Cell Styles that will ship in the Office public beta. Today, I wanted to revisit another (completely new) set of styles that are part of Excel 2007 – Table Styles.在上篇文章中我们介绍了单元格样式——对单元格样式功能所做的改变将在Office Public Beta中发布。今天，我想再谈谈Excel 2007中另一组(全新)的样式——列表样式。Long-time Excel blog readers will remember I already described Table styles to a large extent. There is a whole category of posts on Tables (new to Excel 2007) here, and there is a post on Table Styles specifically here, so folks might want to read those posts as background. Essentially, Table Styles provide a way to quickly format an 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:Excel博客的读者应该记得我已经深入地讲述过列表样式，点击这里可以看到介绍列表(在Excel 2007中的新特性)文章的完整的目录，其中一篇专门讲述列表样式的文章见这里，你可以先阅读这些文章作为(了解列表样式的)基础。实际上，列表样式提供了一种应用预先设置的样式来快速格式整个表格的方法，与Excel原有的自动套用格式功能相似，主要的不同是：• Table styles are dynamic, not a one-time formatting operation, so the formatting associated with the style behaves intelligently through many table actions – addition or deletion of rows or columns, sort, filter, etc. • 列表样式是动态的，不只是以前的格式化操作。即格式与样式能在列表的操作中协同工作——添加或删除行或列，排序，筛选等等。• The UI for applying styles – galleries in the ribbon, just like Cell Styles – is a big step forward. This is a great example of the kinds of benefit the ribbon brings to Excel.
Word2013怎样搜索文件模板
word 2013更新了模板搜索功能，可以更直观的在word文件内搜索工作、学习、生活中的需要的模板，而不必要去浏览器上搜索下载，很大得提高了效率。下面由小编为您提供在Word2013中搜索需要的word文件模板的技巧，希望能帮助您。 Word2013搜索文件模板步骤1：在打开的word文档中，打开文件选项框，选择新建。 Word2013搜索文件模板步骤2：在右侧搜索框中直接搜索需要的模板关键词，如果在搜索框下提示的关键词有符合的则可直接点击，例如点击简历，等待搜索结果即可。 Word2013搜索文件模板步骤3：在搜索出来的模板中，选择合适的点击去创建。 Word2013搜索文件模板步骤4：点击之后，会弹出改模板的预览窗口和资料简介，确认无误后，可以点击创建按钮，去编辑自己的文档了。 Word2013搜索文件模板步骤5：按格式完成文档的撰写和编辑即可。看了“Word2013怎样搜索文件模板”此文的人还看了：1.怎么在Word2013搜索模板2.怎样能快速找到Word模板文件3.怎么在wrod2013中自定义模板
Word2013中怎么清除文档格式
Word2013中怎么清除文档格式?我们从网页或是其他文档中复制一些文字到自己的Word文档中，有时候会发现复制的不仅有文字的内容还有文档的格式。下面小编就教你Word2013中清除文档格式的方法。 Word2013中清除文档格式的方法： 例如有如下文档，如下图所示。 选中需要清除格式的文本，在“开始”选项卡，单击“样式”组的“其他”按钮，如图所示。 单击“清除格式”按钮。 清除格式后的效果如下图所示。Word2013中怎么清除文档格式
显示Word2013窗口中的审阅的方法步骤图
怎么显示Word2013窗口中的审阅?用户在使用Word2013编辑文档时，有时可能会发现“审阅”选项卡不显示了。其实Word2013功能区中的选项卡可以自定义显示或不显示，下面小编就教你显示Word2013窗口中的审阅的方法。希望对你有帮助！ 显示Word2013窗口中的审阅的方法 第1步，打开Word2013文档窗口，依次单击“文件”→“选项”命令，如图2013041501所示。显示Word2013窗口中的审阅的方法图1 第2步，在打开的“Word选项”对话框中，单击左侧的“自定义功能区”按钮，如图2013041502所示。显示Word2013窗口中的审阅的方法图2 3第3步，打开“自定义功能区”选项卡，在右侧的“自定义功能区”列表“主选项卡”区域选中 “审阅”复选框即可显示“审阅”选项卡。取消“审阅”复选框则不显示“审阅”选项卡。设置完毕单击“确定”按钮即可，如图2013041503所示。显示Word2013窗口中的审阅的方法图3
怎样添加和删除word2013水印
小编今天讲的是分类水印如何添加和删除的方法。其实word 2013 中自带的有一些分类水印。例如：“样本”水印;“紧急”水印;“尽快”水印;“机密”水印等，这些水印可以帮助我们迅速的了解我们的文档的种类特别方便，方法也很简单，快来学习吧。 添加和删除word2013水印步骤1：首先我们要打开word 2013中一篇需要添加水印的文档。然后如图：1所示范，逐个单击“设计”——“水印”——免责声明中“样本1” ( 图 1 ) 添加和删除word2013水印步骤2：这时候本文档的分类水印“样本1”就添加好了，你会发现你这篇文档的每一页都有“样本1”的水印。来看下效果图 ( 添加好分类水印之“样本1”的文档效果图 ) 添加和删除word2013水印步骤3：然后我们再来讲讲如何删除分类水印的方法吧，还拿刚才我们添加过分类水印之“样本1”的文档为例，现在我们把分类水印之“样本1”删除，如图3，逐个单击“设计”——“水印”——“删除水印”就可以了 ( 图 3 删除分类水印步骤 ) 添加和删除word2013水印步骤4：现在可以看到删除水印后的效果了，顺带说一下这个分类水印的添加和删除对文档的本身是没有任何影响的。看了“怎样添加和删除word2013水印”此文的人还看了：1.Word2013怎么删除水印