excel技巧_老Excel狗学新技巧

excel技巧

Yes, if your last name is Dalgleish, some people think it sounds like "Dog Leash", and hilarity ensues. And no, I never get tired of that joke, thanks for asking. 😉

是的，如果您的姓氏是Dalgleish，则有人认为这听起来像“狗皮带”，并且随之而来。 不，谢谢你的询问，我从不厌倦这个笑话。 😉

Anyway, unlike the proverbial old dog, those of us who have been using Excel for a long can CAN learn new tricks. Keep reading to discover which new Excel feature I recently discovered.

无论如何，与众所周知的老狗不同，那些长期使用Excel的人可以学习新的技巧。 继续阅读以发现我最近发现的新Excel功能。

长期的Excel用户 (Long Time Excel Users)

Maybe you're a long time Excel user too. Last month I polled readers on my Debra D's Blog, and asked How Long Have You Been Using Excel?

也许您也是Excel的长期用户。 上个月，我在Debra D的博客上对读者进行了投票，并询问您使用Excel多长时间了 ？

Almost half of the 80 respondents have used Excel for 16 years or more, and they shared some interesting stories in the comments.

在80位受访者中，几乎有一半使用Excel已有16年以上，并且在评论中分享了一些有趣的故事。

旧的Excel习惯 (Old Excel Habits)

You learn a lot about Excel over the years, and appreciate both its strengths and limitations. You find workarounds for some of the features that don't work the way you'd like, and accept that some things can't be done in Excel.

这些年来，您对Excel有了很多了解，并且体会到它的优点和局限性。 您会发现某些功能无法按照您希望的方式解决，并接受一些无法在Excel中完成的功能。

Maybe you've even learned to love (tolerate?) the Excel 2007 Ribbon, despite all the years that you spent learning where the Menu commands were.

尽管您花了很多年学习菜单命令的位置，但也许您甚至学会了爱(容忍)Excel 2007 Ribbon。

But occasionally, new features are added, without much hoopla, and you don't even notice them. At least, that's what happened to me!

但是，有时会添加新功能，而没有太多的麻烦，您甚至都不会注意到它们。 至少，这就是我发生的事情！

旧的Excel标头技巧 (Old Excel Header Tricks)

Excel has customizable headers and footers, where you can place items like the date, or file name, in one of three sections -- left, centre or right.

Excel具有可自定义的页眉和页脚，您可以在其中将日期或文件名之类的内容放在三个部分之一(左，中或右)中。

In Excel 2007, click the Insert tab, and click the Header & Footer command, to change to Page Layout view, with the Header activated.

在Excel 2007中，单击“插入”选项卡，然后单击“页眉和页脚”命令，以在“页眉”被激活的情况下更改为“页面布局”视图。

While the Header or Footer are activated, there's a Design tab on the Ribbon, with Header and Footer tools.

激活页眉或页脚后，功能区上将显示一个“设计”选项卡，其中包含“页眉”和“页脚”工具。

You can click on an Element, like Page Number, to add it to a section in the Header or footer.

您可以单击元素(例如页码)以将其添加到页眉或页脚中的部分。

Or, select one of the default options from the Header or Footer drop down lists.

或者，从“页眉”或“页脚”下拉列表中选择默认选项之一。

The Page Layout wasn't available in previous versions of Excel, but the Header and Footer Elements are pretty much the same as they've always been.

Page Layout在早期版本的Excel中不可用，但是Header和Footer元素几乎与以往一样。

新的Excel标头技巧 (New Excel Header Tricks)

After working with Excel 2007 for almost three years, I finally noticed that the Excel Header and Footer have some fancy new Options. (How embarrassing!)

在使用Excel 2007近三年之后，我终于注意到Excel Header和Footer有一些新的选项。 (多么尴尬！)

Now you can have a different header/footer on the first printed page, and different header/footer on the odd and even printed pages.

现在，您可以在第一张打印页面上使用不同的页眉/页脚，并在奇数和偶数打印页面上使用不同的页眉/页脚。

So, you could show a title on the first page only, then have page numbers at the left on even pages, and on the right on odd pages.

因此，您可以仅在第一页上显示标题，然后在偶数页的左侧显示页码，在奇数页的右侧显示页码。

Microsoft Word has always had these options, but Excel didn't. We just accepted that "Excel isn't a word processing program" and did without the header options.

Microsoft Word一直都有这些选项，但Excel没有。 我们刚刚接受了“ Excel不是文字处理程序”，并且没有标题选项。

You can also align the Excel Header and Footer with the page margins, which is another nice feature. In the old days, the Header and Footer margins couldn't be changed, so they sometimes looked a bit out of line with the rest of the printed page.

您还可以将Excel页眉和页脚与页面边距对齐，这是另一个不错的功能。 在过去，页眉和页脚页边距无法更改，因此它们有时看起来与打印页面的其余部分不一致。

Here's the Page Layout view, with the Align With Page Margins feature turned on.

这是页面布局视图，其中“与页面边距对齐”功能处于启用状态。

I hope you found these new Excel Header and Footer options long before I did, and remember to use them in your printed worksheets. __________

希望您早于我就找到了这些新的Excel页眉和页脚选项，并记得在打印的工作表中使用它们。 __________

翻译自: https://contexturesblog.com/archives/2010/03/26/old-excel-dogs-learn-new-tricks/

excel技巧