excel f2键功能_功能区的Excel 2007键盘快捷键

excel f2键功能

While trying to type a hyphen in Excel 2007, I stumbled onto a handy keyboard shortcut.

尝试在Excel 2007中键入连字符时，我偶然发现了一个方便的键盘快捷键。

I had a bit of an overreach on the hyphen, and hit the F10 key instead. To my amazement, the Ribbon filled with little tags.

我在连字符上有些过头了，而是按了F10键。 令我惊讶的是，功能区充满了小标签。

Maybe I've been living under a rock, but I don't remember seeing those before.

也许我一直生活在一块岩石下，但我不记得以前见过那些人。

There's a number or letter on each Ribbon tab, and each icon on the Quick Access Toolbar (QAT).

每个功能区选项卡上都有一个数字或字母，而快速访问工具栏(QAT)上则有每个图标。

使用快捷键 (Use the Shortcut keys)

Pressing the F10 key activates the Ribbon. Then, type the letter(s) or number(s) that you see on any tab or QAT command.

按F10键激活功能区。 然后，键入在任何选项卡或QAT命令上看到的字母或数字。

For example, I can type an A to activate the Data tab. (Note: Even if the Data tab is active, you'll have to type an A to see its command tags.)

例如，我可以键入A来激活“数据”选项卡。 (注意：即使“数据”标签处于活动状态，您也必须键入A才能查看其命令标签。)

Tags will appear on the available Data commands.

标签将出现在可用的数据命令上。

Because there's a table on my worksheet, most of the commands are available, so I can type T to add an AutoFilter or type Q to start an Advanced Filter.

因为工作表上有一个表，所以大多数命令都可用，因此我可以键入T添加一个自动筛选器，或者键入Q启动一个高级筛选器。

It seems like a useful feature, and the only shortcut that I have to memorize is the F10 key. Anyway, it's nice to know that a typo can lead to an interesting discovery. _____________________

这似乎是一个有用的功能，我唯一要记住的快捷键是F10键。 无论如何，很高兴知道错字会导致有趣的发现。 _____________________

翻译自: https://contexturesblog.com/archives/2009/04/27/excel-2007-keyboard-shortcuts-for-the-ribbon/

excel f2键功能