Excel组合汇总功能详解：20141110版教程

excel组合汇总

One Excel annoyance is that after you select a group of cells, you can't unselect one of them. For example, you might want to format specific cells, or create a named range, and you accidentally include a cell that shouldn't be in the group. You can't click on that cell to unselect it – you have to start over, and select more carefully the next time.

Excel的一个烦人之处在于，选择一组单元格后，您将无法取消选择其中的一个。 例如，您可能想要设置特定单元格的格式或创建命名范围，而无意中包含了不应包含在组中的单元格。 您无法单击该单元格来取消选择它–您必须重新开始，并在下次选择时要更仔细。

To solve that problem, Doug Glancy has created a free tool that you can download -- SelecTracker.

为了解决该问题，Doug Glancy创建了一个免费工具，您可以下载该工具-SelecTracker 。

Next, we need a version that lets you unselect one cell within an large area, e.g. if you drag down from A2:A7, click on cell A5, to unselect it.

接下来，我们需要一个版本，使您可以取消选择较大区域内的一个单元格，例如，如果从A2：A7向下拖动，请单击单元格A5以取消选择它。

语境帖子 (Contextures Posts)

Here’s what I posted recently:

这是我最近发布的内容：

• Fix numbers that don't add or sort correctly, when you copy data into Excel from a website, or another source. 当您从网站或其他来源将数据复制到Excel时， 修正无法正确添加或排序的数字 。
• The deadline has passed for the Pivot table online course giveaway. Winners will be announced on Wednesday. 数据透视表在线课程赠品的截止日期已经过去。 获奖者将在周三宣布。
• For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog. 要幽默地窥视其他人对电子表格的看法，请在我的Excel Theater博客上阅读最新的Excel推文集 。

其他Excel文章 (Other Excel Articles)

Here are a few of the Excel articles that I read recently, that you might find useful.

以下是我最近阅读的一些Excel文章，它们可能对您有用。

• Neale Blackwood shares his 4 guidelines for formula creation. Do you agree with all of them? 尼尔·布莱克伍德(Neale Blackwood)分享了他的4条公式创建准则 。 您是否都同意？
• Did you celebrate International Keyboard Shortcut day last week? Dick Kusleika shared several of his favourites, including shortcuts to open, close and save workbooks. 上周您庆祝国际键盘快捷键日吗？ Dick Kusleika分享了他的一些收藏夹，包括打开，关闭和保存工作簿的快捷方式 。
• On Chandoo's blog, Sohail Anwar explains how you can use multiple conditions in a VLOOKUP. 在Chandoo的博客上，Sohail Anwar解释了如何在VLOOKUP中使用多个条件 。
• Even if you're not a lawyer, you can keep track of your time, with this technique from Ben J. Kusmin. 即使您不是律师，也可以使用Ben J. Kusmin的技术来跟踪自己的时间 。
• Sumit Bansal compares the benefits of VLOOKUP versus using INDEX/MATCH. Sumit Bansal比较了VLOOKUP与使用INDEX / MATCH的好处。
• Mike Alexander had some trouble getting rid of the AutoFill Options menu that appears after you fill down on a worksheet. Mike Alexander在摆脱工作表填写后出现的“自动填充选项”菜单时遇到了一些麻烦。
• I'm sure you've heard that Microsoft Office apps, including Excel, are now free for the iPad. Jared Newman takes a look at what you get. 我相信您已经听说iPad可以免费使用 Microsoft Office应用程序，包括Excel。 贾里德·纽曼(Jared Newman)看看您能得到什么。
• Winston Snyder shows how he makes some subtle changes to an Excel Table's TableStyle. 温斯顿·斯奈德(Winston Snyder)展示了他如何对Excel Table的TableStyle进行一些细微的更改 。

 Excel公告 (Excel Announcements)

Here are some upcoming events, courses, recently published books, and other new items, related to Excel.

这是与Excel相关的一些即将发生的事件，课程，最近出版的书籍以及其他新项目。

分享您的活动和文章 (Share Your Events and Articles)

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please share a link in the comments below, with a brief description. Thanks!

如果您最近阅读或撰写了其他有趣的Excel文章，或者即将举行Excel活动，请在下面的评论中共享一个链接，并提供简要说明。 谢谢！

翻译自: https://contexturesblog.com/archives/2014/11/10/excel-roundup-20141110/

excel组合汇总

免责声明：本文系网络转载或改编，未找到原创作者，版权归原作者所有。如涉及版权，请联系删