New shortcuts in Excel 2007

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-
 
R

Rao Ratan Singh

Sir,
will you tell me what is shortcut for Page Setup in Excel 2007 and word 2007
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top