R
Robert Gelbmann
Dear Excel-lencies!
I wonder whether somebody has already created a complete list of new
(or changed) shortcuts in Excel 2007?
Anyway, here is *my* list of new (or changed) shortcuts in XL2007:
[Instead of Ctrl + Alt one can of course also use AltGr.]
FYI: I've a German keyboard. So please let me know if a shortcut is
misplaced.
---(new shortcuts in Excel 2007)---
Ctrl + Alt + V ......... shows the dialog "Paste special"
Ctrl + Alt + F3 ....... shows the dialog "New name"
[This one seamed to be out of order in the originally (German) Excel
2007 and being repaired with SP1?!]
Alt + F5 ................ refreshes the active PivotTable / Query table
Ctrl + Alt + F5 ....... refresh all pivottables & query tables
Ctrl + Alt + L ......... reapplies sorting/filtering
Ctrl + F1 ............... minimizes / restores the "ribbon"
[was: toggles TaskPane]
Ctrl + F2 ............... shows the print preview
Ctrl + 8 ................. hides the selected column(s)
Ctrl + Shift + 8 ....... unhides the selected column(s)
[was: hide/unhide Standard toolbar;
was: Ctrl + 0 resp. Ctrl + Shift + 0]
Ctrl + Shift + 0 ....... Calculate (Application)
Ctrl + T ................ creates a "table" (data list)
(same as Ctrl + L)
Ctrl + Shift + T ................ toggles total row in a "table"
Ctrl + Shift + L ................ toggles "filter" (AutoFilter)
F10 ............................... activates the "ribbon"
(like the Alt-key; in fact no real change; was: activates the menu bar)
---(EOL)---
Anybody wants to add more? [None of the new "key tips" like Alt + R, 9,
please!]
Greetings from Vienna, Austria,
-Robert Gelbmann-
I wonder whether somebody has already created a complete list of new
(or changed) shortcuts in Excel 2007?
Anyway, here is *my* list of new (or changed) shortcuts in XL2007:
[Instead of Ctrl + Alt one can of course also use AltGr.]
FYI: I've a German keyboard. So please let me know if a shortcut is
misplaced.
---(new shortcuts in Excel 2007)---
Ctrl + Alt + V ......... shows the dialog "Paste special"
Ctrl + Alt + F3 ....... shows the dialog "New name"
[This one seamed to be out of order in the originally (German) Excel
2007 and being repaired with SP1?!]
Alt + F5 ................ refreshes the active PivotTable / Query table
Ctrl + Alt + F5 ....... refresh all pivottables & query tables
Ctrl + Alt + L ......... reapplies sorting/filtering
Ctrl + F1 ............... minimizes / restores the "ribbon"
[was: toggles TaskPane]
Ctrl + F2 ............... shows the print preview
Ctrl + 8 ................. hides the selected column(s)
Ctrl + Shift + 8 ....... unhides the selected column(s)
[was: hide/unhide Standard toolbar;
was: Ctrl + 0 resp. Ctrl + Shift + 0]
Ctrl + Shift + 0 ....... Calculate (Application)
Ctrl + T ................ creates a "table" (data list)
(same as Ctrl + L)
Ctrl + Shift + T ................ toggles total row in a "table"
Ctrl + Shift + L ................ toggles "filter" (AutoFilter)
F10 ............................... activates the "ribbon"
(like the Alt-key; in fact no real change; was: activates the menu bar)
---(EOL)---
Anybody wants to add more? [None of the new "key tips" like Alt + R, 9,
please!]
Greetings from Vienna, Austria,
-Robert Gelbmann-