推荐阅读
怎样保护Excel工作表
一、保护整个工作表 在Excel 2003中，选择某个需要保护的工作表，单击菜单“工具→保护→保护工作表”，打开“保护工作表”对话框。在对话框中根据需要选择某个选项，如选择“插入行”后，即表示允许用户在受保护的工作表中插入行。在文本框中输入密码，单击“确定”按钮完成工作表的保护。也可不设置密码，这样在解除工作表保护时就不必输入密码了。 二、保护工作表的部分区域 如果既要保护工作表，又要允许用户对某个区域进行编辑，这时可以对需要编辑的区域取消锁定。例如仅保护工作表中所有包含公式的单元格，步骤如下。 1. 选择工作表中所有包含数据的区域，或者按Ctrl+A选择工作表中的所有单元格。单击菜单“格式→单元格”，打开“单元格格式”对话框，选择“保护”选项卡，取消选择“锁定”选项，单击“确定”。 2. 单击菜单“编辑→定位”命令，可以按F5或Ctrl+G，打开“定位”对话框，单击“定位条件”按钮，弹出“定位条件”对话框。选择“公式”选项，单击“确定”，即可选择工作表中所有包含公式的单元格。 3. 单击菜单“格式→单元格”，打开“单元格格式”对话框，在“保护”选项卡中勾选“锁定”选项，单击“确定”。如果此处还勾选了“隐藏”选项，则保护工作表后，选择包含公式的单元格时就不会在编辑栏中显示公式。 4. 用前面所述方法对工作表进行保护。这样，所有包含公式的单元格都被设置了保护，用户不能对其进行编辑。而其他单元格则能进行编辑。
WPS excel加粗单个单元格及自定义边框线条的方法
之前我们都是对表格批量进行边框更改，那么如果我们想要单独对某一个单元格进行边框加粗，该如何操作呢，今天我们就来教大家如何在Excel表格当中对单个单元格边框加粗的方法，一起来学习一下吧。 加粗单个单元格及自定义边框线条的方法首先，我们单击工具栏开始下的边框标识，在下拉菜单下选择其他边框。弹出单元格格式的对话框，在分类里单击边框选项，样式里选择加粗线条，然后在预置里选择外边框，单击确定。然后我们看到表格当中的单个单元格就已经加粗显示了。还有一种方法，单击工具栏的绘图边框选项，选择线条样式，在下拉菜单下选择一个边框样式。
Excel2013打开提示" 向程序发送命令时出现问题"怎么办
每次开机第一次打开Excel 2013程序都会“向程序发送命令时出现问题”第二次就不会，已经试过很多方法了都没有解决。目前来说只有Excel属性改为兼容模式，以兼容模式运行Excel 2013这个程序才可以解决。 点击查看图片针对问题有可能是加载项导致的，请先尝试按”Windows+R“输入”excel.exe /safe“回车选择以Excel的安全模式打开，如果正常的话请确认文件—选项—加载项的”转到“禁用或删除不信任的加载项后测试。 如果问题依旧的话，请确认选项的“高级”，然后单击“常规”区域中的“忽略其他使用动态数据交换 (DDE) 的应用程序”复选框，以取消选择。(如果本身就没有勾选的话，请先勾选再确认关闭后重新移除勾选测试) 如果上述的方法都不能解决问题，也就只能把Excel属性改为兼容模式vista打开问题来解决了。
WPS小技巧—未保存的文档怎么恢复
咱们在 操纵WPS办公的 时分 偶然候会 碰到一些突发 状况， 比方Word、Excel或PPT等 各种型文档 尚未 保留时手误 间接 封闭， 大概说 忽然断电，电脑卡死等，这个 时分 咱们 辛劳了 良久的 功效 岂非就 如许 半途而废了？ 实在你不 晓得的是，WPS自带云备份 功用，没有 保留的文档 也可以 经由过程备份 规复找 返来哦~ 究竟没有 保留的文档 该当 怎样找 返来呢？ 一同来 进修一下吧！>> 收费 创立账号 起首我新建一个名为 事情簿2的Excel表格， 输出一些内容，不 保留 间接 封闭>> 收费 创立账号要找回这个表格， 咱们先要 翻开WPS， 而后单击文件， 挑选备份与 规复选项下的备份 中间。>> 收费 创立账号点击 当地文件，在列表中勾选要 规复的文件 事情簿2，单击 翻开 局部， 如许文档就 胜利找回啦~>> 收费 创立账号 别的，为了保险起见， 咱们 最佳 修正下备份 配置，把 主动备份的 工夫 距离改得小一些， 翻开备份 中间，单击左下角的 配置， 修正 工夫 距离，这里我 配置为5分钟， 如许就 不再用 担忧文档 由于未 保留而 丧失了~>> 收费 创立账号
最新发布
Excel服务VI——用Excel Web Services创建应用程
Excel Services part 6: Building applications with Excel Web ServicesExcel Services(第6部分)：用Excel Web Services创建应用程序While talking about scenarios for Excel Services, I mentioned “Reusing the logic encapsulated in Excel spreadsheets in custom applications” – which means accessing spreadsheets and their contents server-side via web services in a way that’s scalable and manageable. I would like to elaborate on this topic over a couple of posts. Today, I will introduce “Excel Web Services”; in a follow-up post I will show how to develop a small sample application using said web services.在介绍Excel Services 中的方案时，我提到过”在用户自定义程序中重复利用Excel电子表格的逻辑封装”——可升级和管理通过网络服务器访问电子表格和存储信息服务器端。我在上面的一些文章中就这个主题作过详细的介绍。今天，我将介绍“Excel Web Services”，接下来的文章展示如何用网络服务器开发小的应用程序示例。In a nutshell…概述Let’s briefly revisit Excel Services’ architecture. The Excel Calculation Service is the “engine” of Excel Services; it is the component that loads and calculates spreadsheets. In the “interact with the spreadsheet in your browser” scenarios covered in previous posts, Excel Calculation Services loads and calculates a spreadsheet and then hands it off to the Excel Web Access, which is the component that produces the HTML that ends up in your browser. The point of today’s post (and the post that will follow) is that developers can also use Excel Calculation Services without needing to interact with the Excel Web Access. Specifically, we have built a web service API directly on top of the Excel Calculation Services so that developers can call server-side spreadsheets directly from their own applications. For example, developers could write code that opens a spreadsheet on a server, sets cells and ranges to specific values, controls external data refresh and workbook calculation, and finally retrieves values from the calculated workbook (or retrieves the workbook in its entirety). Let’s look at some more specific examples.先简单地回顾一下Excel Services架构 。Excel Calculation Service是Excel Services的”引擎”，是装载和计算电子表格的组件。在上篇文章中介绍了”在浏览器中与电子表格相交互”， Excel Calculation Service装载和计算电子表格，并且不需要Excel Web Access(配置在浏览器中生成HTML的组件)。这篇文章接下来介绍开发者不需要Excel Web Access的配合也能运用Excel Calculation Service。具体地讲，我们在Excel Calculation Service中已经直接创建了一个网络服务器API，以便于开发者能在他们自己的应用程序中直接调用网络服务器端的电子表格。例如，开发者能够写用来打开服务器上的电子表格的代码，设置单元格和区域为指定值，控制外部数据更新和工作薄计算，并且最后从已经过计算的工作簿中取回数值(或取回整个工作薄)。下面列举了一些更详细的例子。What sorts of things are these web services good for?
VIII －推迟数据透视表更新
PivotTables VIII: “Defer Layout Update”, or adding multiple fields in one fell swoop数据透视表 VIII：“推迟布局更新”，还是猛然添加很多字段In this article, I’ll cover a small yet very useful PivotTable feature – deferring PivotTable updates. In current versions of Excel, PivotTables are updated each time a field is added, removed, or moved to a different position. For PivotTables based on large data sets, these actions can take some time to complete, meaning, for example, you end up waiting 7 times if you create a new a PivotTable and add 7 fields.在本文中，我将讲述一个很小，但是非常有用的数据透视表功能——推迟数据透视表更新。在Excel的当前版本里，数据透视表每次添加一个字段，删除字段，或者移动字段到一个不同的位置，就会更新一次。有大量数据集的数据透视表，这些动作会花费一些时间，例如，如果你创建一个新数据透视表并添加七个字段，那么结果你就得等七次。To address this scenario, we have added a feature to Excel 12 that allows you to control when the PivotTable is updated. As some of you may have noticed in screenshots in previous blogs, there is a checkbox and a button at the bottom of the field list. 为了实现该方案，我们在Excel 12里添加了一个功能，让你可以控制何时更新数据透视表。你们中有些人可能已经注意到前面日志中的截屏，在字段列表的下面有一个勾选框和一个按钮。"Defer Layout Update" controlsWhen this checkbox is checked, the “Update” button next to it becomes enabled, and now you can add, remove and move fields around without the PivotTable updating itself. When you are done arranging fields, you press the Update button, and the PivotTable does one and only one update.当该复选框被勾选上时，旁边的“Update”按钮就会被激活，现在你就可以添加，删除已经移动字段，而数据透视表不会自己更新了。当你完成字段的安排后，你按下更新按钮，数据透视表就会执行一次，仅仅一次更新。
透视表终曲_值字段技巧（一）
Pivot Tables grand finale: Tricks with the Values field透视表终曲：值字段技巧This is going to be the last PivotTable post, at least for a while. Unlike the last several posts, the subject matter that follows applies to any PivotTable, not just those connected to SQL Server Analysis Services.这是本阶段内最后一篇关于透视表的文章了。和前几篇文章不同，本主题相关的应用不只是用于连接到SQL Server Analysis Services的,而是任何透视表。In current versions of Excel, one of the capabilities that exist in PivotTables is the ability to adjust the position of the labels that describe the values in the Values region of the PivotTable (i.e. “Sum of Sales”). Excel PivotTables offer significant flexibility in this area – the labels can be on rows, on columns, and anywhere in the hierarchy on either of those areas. When we visit customers to talk to them about how they use PivotTables, though, we see a couple of things. First, the majority of users aren’t fans of our initial placement of the labels. Second, most people have never figured out that the labels can be repositioned. We have tried to address both of these items in Excel 12.在这个版本的Excel中，透视表的一个功能就是，用于描述透视表（例如"Sum of Sales"）中选定范围内值的标签的位置是可以改变的。这一点上Excel透视表非常的灵活，标签可以被放在行，列，或者那些区域层级的任意位置。当我们去客户那里，告诉他们怎么使用透视表的时候，通常，我们会遇到两种情况。一种是，大多数用户不喜欢标签的初始位置。另一种，多数客户根本不知道这些标签是可以移动位置的。我们已经试着在Excel12中解决这些问题了。This area is probably best explained by walking through an example, so here goes. To start with, imagine you were building the following PivotTable. It has some items on rows and columns, and Sales Amount summarized in the Values area.看一个例子，应该是解释这个问题的最好的方式，所以:),here goes。开始，想象一下你原来做下面这张表的时候。列和行上都有一些项目，后面的计算区域还有销售统计额。If you add a second field to the Values area – say Product Cost – then Excel adds some captions (“Sum of Sales Amount”, “Sum of Product Cost”) below the years (“2003”, “2004”) to help the user distinguish which numbers are Sales and which numbers are Product Cost.
透视表终曲_值字段技巧（二）
If you want to re-position the captions elsewhere, you can simply drag-and-drop the “∑ Values” field to another drop zone or another position in the drop zone that currently contains the “∑ Values” field. Say I wanted to see the labels above the “Year” field in the Column area. All I need to do is start dragging the “∑ Values” field, and I get feedback as to where the field will end up when I am done (blue bar, new cursor).如果您想把标题放到其它地方，您只需拖拽"∑ Values"字段到其它拖放区域或者已含有"∑ Values"字段的拖放区域的别的位置。也就是说当我要查看列区域中"Year"字段上面的标签的时候，我所要做的就是拖动"∑ Values"字段，当我要放下（蓝色边，不一样的鼠标指针）的时候就会看见字段竖起来。If I drag the “∑ Values” field above the “Year” field and let go, the PivotTable will refresh, and the captions will now be outside the year information, showing me a different view of my data. Here is what that looks like.如果我将"∑ Values"字段拖到"Year"字段上放下，透视表就会刷新，并且标题也会显示出年度的信息，显示出来的是一个不同的视图。如下：I can also move the captions to the Row area. Here is what the PivotTable looks like when I have moved the “∑ Values” field to the bottom of the hierarchy on the Row area.我也可以将标题移动到行上。下面是当我移动"∑ Values"字段到行的底端相应级别时透视表的样子：Further, I can move the captions anywhere else in the hierarchy in the Row area. Here is what the PivotTable looks like when I have moved the “∑ Values” field in between the Product Name and Product Category fields.而且，我可以在行的同级别里随意移动标题。下面是我将"∑ Values"字段移到Product Name 和Product Category字段中间的样子：By now you are probably getting the idea – the placement of the labels is infinitely flexible, allowing you to see the data pretty much any way you want. Hopefully folks see this as a useful feature. As always, I am interested to hear your feedback.
技巧1_色彩缤纷的Data Bars
Conditional Formatting Trick 1 – Multi-Coloured Data Bars条件格式技巧1——色彩缤纷的Data BarsA few months ago, I described the new features we have added to Excel 2007 in the area of conditional formatting. One of the new formats we added is called a “data bar” … check out this earlier post for a refresher, but the basic idea is that Excel draws a bar in each cell representing the value of that cell relative to the other cells in the selected range. Here is a shot from that post.几个月以前，我讲述了在Excel 2007中新增加的有关条件格式的各种特性，其中之一就是我们称之为“data bar”的……可参阅以前的文章。但是我们只讲到最基础的概念，即在一个选定的区域里面，由Excel根据不同单元格的数值对比情况，在每个单元格中绘制一个色带。下面是以前文章中的截图：The Excel 2007 UI allows you to choose whatever colour you want for your data bars, but, by default, all the data bars you apply to a range have to be the same colour. Someone on our team recently showed me how to use a tiny bit of VBA to simulate having multiple colours of data bars on a range conditionally applied, so I thought I would pass along the trick.Excel 2007允许你为你的data bars选择任何你想要的颜色，但是，默认情况下，同一区域中的data bars，只能有同一种颜色。最近，开发团队中的某位成员向我展示了如何在同一区域中创建多种颜色的data bars，只需要利用非常简单的VBA代码即可。所以，我想我应该好好发挥这个技巧的威力。Say, for example, you are looking at student grades, and you want all the data bars for students with a passing mark (60%+ and above) to be green, and those with a failing grade (59% or less) to be red. The first thing you would do is to add some red data bars to your data, and then some green data bars. By default, Excel shows you the last set applied, so the data bars would be green. If you then launch the VB Editor (Alt + F11) and in the immediate window (Ctrl+G), type:selection.FormatConditions(1).formula = "=if(c3>59, true, false)"You would see that your data now looks like this, which makes it easy to spot the failing grades.
Excel服务——体系架构
Excel Services – Architecture Excel服务——体系架构Before I continue to drill down on the features of Excel Services, I would like to explain the architecture at a high level and touch on configuration possibilities. 在我继续勾勒Excel服务的特性以前，我想从一个较高的层次解说Excel服务的体系架构。Excel Services is built on the SharePoint products and technologies platform. There are three core components of Excel Services Excel服务是建立在SharePoint产品和技术平台之上，有三个核心组件。Excel Calculation ServiceExcel Web AccessExcel Web Service
数据集函数Part1 概述（二）
What are the new CUBE functions?新增的数据集函数是什么？We have implemented seven new CUBE functions that can be used in Excel formulas just like any other function in Excel. These functions permit Excel to fetch data from SQL Server Analysis Services (2000 & 2005), including any member, set, aggregated value, property, or KPI (Key Performance Indicator) from the OLAP cube. This data can then be placed anywhere in the spreadsheet, intermingled with other local calculations and/or within other formulas. Here are the seven new CUBE functions:我们补充了7个新数据集函数，同其它工作表函数一样，可以在Excel公式中使用。这些函数允许Excel从 SQL Server Analysis Services (2000 & 2005) 提取数据，包括任意成员、子集、汇总值、属性或KPI（关键业绩指标）。这些数据可以放在电子表格的任何地方参与本地计算，或者作为其他公式的一部份参与计算。CUBEMEMBER (connection, member_expression,)This function will fetch the member or tuple defined by the member_expression. For example, (from the illustration above,) the formula: =CUBEMEMBER ("Adventure Works", "[Sales Reason].[On Promotion]") returns the member named “On Promotion” from the “Sales Reason” dimension of the Adventure Works cube.该函数通过定义member_expression（成员表达式）提取成员或成员组。例如，上个实例的公式=CUBEMEMBER ("Adventure Works", "[Sales Reason].[On Promotion]")， 从Adventure Works 数据集的“销售成因”维度返回了一个“促销”成员。CUBEVALUE (connection, [member_expression_1], [member_expression_2], …)This function will fetch the aggregated value from the cube filtered by the various member_expression arguments. For example, the formula: =CUBEVALUE ("Adventure Works","[Measures].[Gross Profit]","[Product].[Category].[Bikes]","[Date].[Fiscal Year].[FY 2004]") returns the value $5,035,271.22 which is the aggregated amount in the Adventure Works cube for Gross Profit for Bikes in Fiscal 2004.
介绍Excel服务
Introduction to Excel Services, or “running Excel spreadsheets on a server”介绍Excel服务或者说“在服务器上运行Excel工作簿”Back in September, I posted an article on the big picture which mentioned that we are creating an all-new “Excel Services” server technology as part of our Excel 12 work. Some of you may have caught a glimpse of Excel Services being demonstrated as part of our BI announcement in October. For the next few weeks, I am going to cover the work we have done in this area.在9月, 我张贴了有大图的文章提及我们创造了全新Excel服务器技术作为我们Excel12开发工作的一部分。 你们也许瞥见了Excel服务器作为我们BI 公告一部分 在10月发布。 在今后几星期, 我将报道我们完成的这个部分的工作。What is it?Excel Services is brand new server technology that will ship with Office 12. Excel Services supports loading, calculating, and rendering Excel spreadsheets on servers. There are two primary interfaces: a web-based UI that lets you view spreadsheets in the browser, and a web services interface for programmatic access. I will spend some time on both of these interfaces in future posts. For now, let’s start with an example of the type of work flow that we anticipate will be common using Excel services’ web-based UI. Specifically, let’s look at how a sales analyst would share some work done in Excel with a sales manager.它是什么?Excel服务器是将运用于Office12 的全新的服务器技术。 Excel服务支持装载, 计算, 并且反馈Excel报表在服务器。 有二个主要接口: 让您在基于互联网浏览器的观看报表用户界面；存取列表的网络服务器界面。 在以后的文章中我在这两个接口上将花费一些时间用来介绍。 现在, 让我们用一个工作流程的例子来看看我们期望的基于互联网的Excel用户交流界面。 在下面的例子中, 我们看看在销售管理中销售分析员如何分享Excel上的工作。A sales analyst authors a sales analysis spreadsheet using Excel 12
关于我们在Office中书写代码，另外加上一些抓图
A Small Piece Of Pleasant News For Those Of Us That Write Code In Office, Plus Some More Screenshots … 一小段令人愉快的新闻——关于我们在Office中书写代码，另外加上一些抓图Any readers that have written VB using the VBA editor in Microsoft Office has probably noticed that historically, their mouse scroll wheel (or equivalent) does not work in the code window. I just noticed in recent builds of Office 2007 that it does. I am not sure when, exactly, that was fixed, but I am happy to report that it has been, so there you go. 一些用Microsoft Office中VBA编辑器写VB代码的读者大概注意到了它的历史，他们的鼠标滚轮（或者是中键）不能在代码窗口中使用。我刚才注意到了在最近的Office 2007工程中它已经能用了。我没有把握准确的说是什么时候有了这个改进，但是我很高兴的报告他已经可以了，因为事实已经放在那了。Additionally, I sort of blew it in the last post when I didn’t include any screenshots of a PivotTable with Page Fields (or “Report Filters” as we are calling them in Exel 2007). Since they look sharp, I wanted to redress that. Here are 4 of the PivotTables I showed you last time with Report Filters added. Note that they have lost that “button” look and are now nicely formatted text. 另外，在以前的文章中，我没有加入一些关于数据透视表页字段的截图（或者称之为“Report Filters”正如我们在Exel 2007叫的一样）。由于它们看起来非常专业，所以我希望对这点进行补充。下面是我最近展示给大家的已经添加了Report Filters 的4张数据透视图。注意他们已经失去了看起来像“按钮”的那种界面并且现在可以格式化文本，更加好
Word20007的发展历史视频教程
Word是Microsoft公司的一个文字处理应用程序。与Word2003相比，Word2007最明显的变化就是取消了传统的菜单操作方式，而代之于各种功能区。在Word2007窗口上方看起来像菜单的名称其实是功能区的名称，当单击这些名称时并不会打开菜单，而是切换到与之相对应的功能区面板。每个功能区根据功能的不同又分为若干个组，每个功能区的所拥有的功能。 总的来说操作方式和2003都差不多，只是工具菜单键排列有了点变化，在就是增加了一些新功能。今天小编为大家带来Word 20007相关视频教程，欢迎大家学习观看。