John Walkenbach的Excel PUP加载项

[Update - John Walkenbach has sold his website and this product is no longer available] About a week ago, John Walkenbach had a clearance sale for his PUP Add-In for Excel. PUP stands for Power Utility Pak, and that's not an overstatement. I've been using the latest version, PUPv7 for Excel 2007, for the past week, and am amazed by all its features.

[ 更新 -John Walkenbach出售了他的网站，并且该产品不再可用 ]大约一周前，John Walkenbach的PUP Excel附加组件进行了清仓销售。 PUP代表Power Utility Pak，这并不是夸大其词。 过去一周，我一直在使用最新版本的Excel 2007 PUPv7，它的所有功能都令我惊讶。

When installed, PUPv7 adds a tab to the Excel Ribbon, with six groups of commands. The Ribbon tab's groups don't collapse if you make the Excel window narrower, like the built-in tabs do, but that's a minor quibble. There are too many features to list, but here are some of my favourites, so far.

安装后，PUPv7将选项卡添加到Excel功能区，其中包含六组命令。 如果像内置选项卡那样缩小Excel窗口的宽度，“功能区”选项卡的组不会折叠，但这是一个小小的错误。 有太多功能要列出，但到目前为止，这里是我的一些最爱。

PUP书签 (PUP Bookmarks)

Create a bookmark to mark a range in any Excel file, and you can quickly return to that file and location from the PUP Ribbon tab.

创建书签以标记任何Excel文件中的范围，然后可以从“ PUP功能区”选项卡快速返回该文件和位置。

创建工作簿目录 (Create Workbook Contents Sheet)

There's a list of workbook tools, including the handy Create Workbook Contents Sheet command. This creates a cover sheet in your workbook, with a set of hyperlinks or buttons that link to the other sheets in the workbook.

这里有一个工作簿工具列表，包括方便的“创建工作簿目录表”命令。 这将在您的工作簿中创建一个封面，其中包含一组超链接或按钮，这些超链接或按钮链接到该工作簿中的其他工作表。

Maybe the next version will add a hyperlink back to the contents sheet on each indexed sheet, in a specified cell.

也许下一版本将在指定单元格中的每个索引表上的目录表中添加一个超链接。

自定义新工作簿 (Customize a New Workbook)

With the Customize a New Workbook command you can quickly create a workbook with a sheet for each month, each weekday, a numbered series or a list of items.

使用“自定义新工作簿”命令，您可以快速创建一个工作簿，其中包含每个月，每个工作日，一个编号系列或项目列表的工作表。

文字工具 (Text Tools)

In the Modify Cells and Ranges drop down is a Text Tools command. With it, you can change the case of text in selected cells, add text within existing text, or remove text or spaces.

在“修改单元格和范围”下拉列表中，是“文本工具”命令。 使用它，您可以更改所选单元格中文本的大小写，在现有文本中添加文本，或删除文本或空格。

With this tool you won't have to create formulas or macros when you want to modify text, just fill in boxes and click Apply.

使用此工具，您无需在要修改文本时创建公式或宏，只需填写框并单击“应用”即可。

更多功能 (Many More Features)

Those are just a few of the features in PUPv7. There are also worksheet functions, randomizer tools, workbook reports and many more features. I highly recommend that you download the free trial (30 days) or purchase a copy ($40 US).

这些只是PUPv7中的部分功能 。 还有工作表功能，随机化工具，工作簿报告和许多其他功能。 我强烈建议您下载免费试用版(30天)或购买副本(40美元)。

PUPv7 is a real timesaver as as you work in Excel 2007, and it should pay for itself very quickly. PUPv6 is available for Excel 2003 or earlier versions.

在Excel 2007中工作时，PUPv7是真正的节省时间的工具，它应该很快就能收回成本。 PUPv6可用于Excel 2003或更早版本。

翻译自: https://contexturesblog.com/archives/2008/11/25/john-walkenbachs-pup-add-in-for-excel/