Bookmarked. Great post.

Hey
here are some short-cuts – sorry, but only in german
regards stef@n

ALT + ‘ ( Apostroph ) Formatvorlage
ALT + = Formel SUMME einfügen
ALT + (Pfeil nach unten) Anzeige der AutoEingabe – Liste
ALT + EINGABE Zeilenumbruch innerhalb einer Zelle
ALT + F1 Einfügen Diagrammblatt
ALT + F11 Anzeige des VB-Editors
ALT + F2 Speichern unter
ALT + F4 Beenden
ALT + F8 Anzeigen Dialogfeld “Makro”
ALT + SHIFT + F1 Einfügen Tabellenblatt
ALT + SHIFT + F2 Speichern
F1 Online-Hilfe oder Office-Assistent
F2 Bearbeiten aktive Zelle
F3 Einfügen eines Namens in eine Formel
F4 Wiederholung der letzten Aktion
F5 Gehe zu
F6 Wechseln zum nächsten Ausschnitt
F7 Rechtschreibung
F8 Markierung erweitern
F9 Alle Blätter berechnen
F10 Menüleiste aktivieren
F11 Erstellen Diagramm
F12 Speichern unter
SHIFT + F1 Direkthilfe
SHIFT + F2 Bearbeiten Zellkommentar
SHIFT + F3 Einfügen einer Funktion in eine Formel
SHIFT + F4 Weiter Suchen
SHIFT + F5 Suchen
SHIFT + F6 Wechseln zum vorherigen Ausschnitt
SHIFT + F8 zur Markierung hinzufügen
SHIFT + F9 Aktives Tabellenblatt berechnen
SHIFT + F10 Anzeigen Kontextmenü
SHIFT + F11 Einfügen Tabellenblatt
SHIFT + F12 Speichern
SHIFT + BildAb Erweitern der Markierung um eine Bildschirmseite nach unten
SHIFT + BildAuf Erweitern der Markierung um eine Bildschirmseite nach oben
SHIFT + Leertaste gesamte Zeile markieren
SHIFT + Pfeiltaste Erweitern der Markierung um eine Zelle
SHIFT + POS1 Erweitern der Markierung bis zum Zeilenanfang
SHIFT + Rücktaste Reduzierung der Markierung auf die aktuelle Zelle
STRG + – ( Minuszeichen ) Zelle löschen
STRG + ! Zahlenformat “Zahl mit Tausendertrennzeichen, 2 Dezimalstellen + Vorzeichen” zuweisen
STRG + ” Zahlenformat “Wissenschaft mit 2 Nachkommastellen” zuweisen
STRG + # Wechseln der Anzeige zwischen Zellwerten und Zellformeln
STRG + $ Zahlenformat “Währung + 2 Nachkommastellen” zuweisen
STRG + % Zahlenformat “Prozent ohne Dezimalstellen” zuweisen
STRG + & Zahlenformat “Standard” zuweisen
STRG + ( Spalte einblenden
STRG + ) Zeile einblenden
STRG + * markieren des aktuellen Bereichs
STRG + . ( Punkt ) aktuelles Datum einfügen
STRG + / Markieren der aktuellen Matrix
STRG + : ( Doppelpunkt ) aktuelle Uhrzeit einfügen
STRG + ; ( Semikolon ) Kopieren des Wertes aus der Zelle darüber
STRG + _ ( Underscore ) Gesamtrahmen zuweisen
STRG + + ( Pluszeichen ) leere Zelle einfügen
STRG + > alle Rahmen löschen
STRG + < Zelleninhalt von darüber liegender Zelle kopieren
STRG + § (Paragraph) Datumsformat "01.Jan 00" zuweisen
STRG + 0 ( Null ) Excel97: Ein-/Ausblenden der Standard-Symbolleiste, Excel 2003: Spalte ausblenden
STRG + 1 Format Zellen
STRG + 5 Formatierung "Text durchgestrichen"
STRG + 6 Wechseln dem Ein-/Ausblenden von Objekten und dem Anzeigen von Platzhaltern
STRG + 8 Excel 97: Spalte ausblenden, Excel 2003: Standard-Symbolleiste ein-/ausblenden
STRG + 9 Zeile ausblenden
STRG + A alles markieren bzw. nach Eingabe eines Funktionsnamens: Anzeige der Formelpalette
STRG + Ä Markieren aller Zellen, deren Formel die aktuelle Zelle referenziert ( direkt )
STRG + BildAb Wechseln zum nächsten Blatt innerhalb der Arbeitsmappe
STRG + BildAuf Wechseln zum vorherigen Blatt innerhalb der Arbeitsmappe
STRG + C markierten Bereich kopieren
STRG + EINGABE alle markierte Zellen erhalten aktuellen Eintrag
STRG + ENDE Bewegen an das Ende des Tabellenblattes
STRG + F Suchen
STRG + F2 aktive Zelle anzeigen
STRG + F3 Festlegen eines Namens
STRG + F4 Fenster schließen
STRG + F5 Wiederherstellung der Fenstergröße
STRG + F6 Wechseln zum nächsten Arbeitsmappenfenster
STRG + F7 Verschieben Fenster
STRG + F8 Fenstergröße ändern
STRG + F9 Arbeitsmappe minimieren
STRG + F10 Maximieren oder Wiederherstellen des Arbeitsmappenfensters
STRG + F11 Einfügen einer Excel (4.0) Makrovorlage
STRG + F12 öffnen
STRG + K Hyperlink einfügen
STRG + Leertaste gesamte Spalte markieren
STRG + N neue Arbeitsmappe
STRG + O öffnen
STRG + P Drucken
STRG + Pfeiltaste Bewegen an den Rand des aktuellen Datenbereichs
STRG + POS1 Bewegen an den Anfang des Tabellenblattes
STRG + R Zelleninhalt von linker Zelle kopieren
STRG + Rücktaste aktive Zelle anzeigen
STRG + S Speichern
STRG + SHIFT + A nach Eingabe eines Funktionsnamens: Einfügen der Argumentnamen und Klammern
STRG + SHIFT + ä Markieren aller Zellen, deren Formel die aktuelle Zelle referenziert ( direkt oder indirekt )
STRG + SHIFT + EINGABE Eingabe einer Formel als Matrixformel
STRG + SHIFT + ENDE Erweitern der Markierung bis zur letzten verwendeten Zelle (rechts unten)
STRG + SHIFT + F Formatierung Fett
STRG + SHIFT + F12 Drucken
STRG + SHIFT + F3 Erstellen eines Namens unter Verwendung von Zeilen- und Spaltenbeschriftungen
STRG + SHIFT + F6 Wechseln zum vorherigen Arbeitsmappenfenster
STRG + SHIFT + K Formatierung Kursiv
STRG + SHIFT + Leertaste alle Zellen markieren
STRG + SHIFT + O Markieren aller Zellen mit Kommentar
STRG + SHIFT + Pfeiltaste Erweitern der Markierung bis zur letzten nicht-leeren Zelle
STRG + SHIFT + POS1 Erweitern der Markierung bis Tabellenblatt Anfang
STRG + SHIFT + TAB Wechseln zur vorherigen Arbeitsmappe
STRG + SHIFT + U Formatierung Unterstreichung
STRG + SHIFT + ü Markieren aller Zellen, auf die sich die aktuelle Formel bezieht ( direkt oder indirekt )
STRG + TAB Wechseln zur nächsten Arbeitsmappe
STRG + U Zelleninhalt von darüber liegender Zelle kopieren
STRG + ü Markieren aller Zellen, auf die sich die aktuelle Formel bezieht ( direkt )
STRG + V Einfügen aus Zwischenablage
STRG + W Fenster schließen
STRG + X Ausschneiden der Markierung
STRG + Y Wiederholung der letzten Aktion
STRG + Z Rückgängigmachen der letzten Aktion

Thanks Chandoo

Hello Chandoo.

Nice list of shortcuts. But some of them doesn’t work in French. Here’s what I found.
How about a multilingual sheet of shortcuts ?

Select blank cells :
F5 + ALT + S + K + ENTER => F5 + ALT + C + D + ENTER
Select all cells that are directly or indirectly referred to by formulas in the selection
CTRL + SHIFT + { => ALT + L + RS + S + N + {S|T} {Direct|All}
Select all cells with formulas that refer directly or indirectly to the active cell
CTRL + SHIFT + } => ALT + L + RS + S + A + {S|T} {Direct|All}
Evaluate formulas. (its easy to remember when working with some “tuf” formulas!)
ALT + TUF => ALT + UV
Copy a formula from above cell and edit
CTRL + ‘ => Not Found
Alternate between displaying cell values and displaying cell formulas
CTRL + ` (Single Left Quotation Mark) => Not Found
Format Selection (cells, objects, charts)
CTRL + 1
Single border around selected cells
CTRL + SHIFT + 7 => CTRL + 0
Sort
ALT + DS => ALT + éT
Freeze panes
ALT + WFF => ALT + NVF
Create a pivot table in new sheet (of course after selecting the range)
ALT + DPF => ALT + SYTN
Create a pivot table in the same sheet.
ALT + DPN => ALT + SYTF
Clear all contents
ALT + EAA => ALT + LEA

“Selects all the way to a1 from cursor position

SelectionCTRL + SHIT + HOME”

You might get a smelly finger if you use that shortcut

Think you missed the F out

I think it would be cool if you add a Printer friendly button.

gr8 job..Chandoo.. n all others..

How about translating german contribution by stef@n ??

Regards.

Chandoo
One you missed

CTRL + ALT +F9
Rebuilds the internal links within a spreadsheet and then saves

I think it is similar to the Open, Repair option in 2007

Chandoo, great post!
Chandoo there’s yet a very important shortcut key that should get mention for its huge benefit. The CTRL +. (Period) helps bring back the yellow diamond shaped Symbol that usually is available only on the Top Cell of a selected Column. So instead of scrolling your way all the way to the top, with a click of CTRL +. makes this accessible immediately, and by clicking on it, giving you a number of options like converting text to number etc etc.

Chandoo, how about having a seperate blog for Excel VBA shortcut keys???

Hi Chandoo,

Here’s another useful one for the formatting group.
To erase all formatting from your selected cells
Alt + E + A + F (easy to remember E[rase] + A[ll] + F[ormats]
Note that dates/times format to general numbers/decimals

I think this excel is helful for all the people but when you have try to do it.

Hello again.

I was trying to use Chrisham’s shortcut in my french Excel and I found this weird shortcut :

CTRL + . (period form numpad only)
This one change the corner selected (turns clockwise) in a selection range.

CTRL + SHIFT + ; (SHIFT+; = . period with french keyboard) bring “Photo” icon in the quick toolbar. Doesn’t seem to do anything else.

Cyril

err.. should have written CTRL+, (comma)

Sorry

Nice list of shortcuts. It’s good to be reminded of the old Alt + menu key shortcuts (I just wish more of them still worked in XL 2007). Although the list is great, an Excel table would be much, much better!

Hey together
my idea:
let’s create a list / table of all short-cuts

shortcut – english – german – french – … – … – …

good idea ??
Stef@n

you can translate it with
http://translate.google.de/#

AND
don’t forget short-cut’s like

Alt + 0155 “ø”
Alt + 0216 “Ø”
Alt + 0241 “ñ”
Alt + 241 “±”
Alt + 184 “©”
Alt + 0137 ” ‰”
Alt + 230 “µ”
AltGr + E “€”

regards Stef@n

AND
test the following short-cuts
some of them seemed UNUSED?!

Stef@n

STRG = CTRL !!

Alt + F3
Alt + F5
Alt + F7
Alt + F9
Alt + F10
Alt + F12
Alt + n. oben
Alt + n. rechts
Alt + n. links
Alt + Pos1
Alt + Entf
Alt + Einfg
Alt + Ende
Alt + Shift + 0
Alt + Shift + 1
Alt + Shift + 2
Alt + Shift + 3
Alt + Shift + 4
Alt + Shift + 5
Alt + Shift + 6
Alt + Shift + 7
Alt + Shift + 8
Alt + Shift + 9
Alt + Shift + >
Alt + Shift + ;
Alt + Shift + :
Alt + Shift + _
Alt + Shift + *
Alt + Shift + `
Alt + Shift + °
Alt + Shift + F3
Alt + Shift + F5
Alt + Shift + F6
Alt + Shift + F7
Alt + Shift + F8
Alt + Shift + F9
Alt + Shift + F10
Alt + Shift + F11
Alt + Shift + F12
F3
Shift + F7
Strg + ´
Strg + ^
Strg + B
Strg + D
Strg + E
Strg + I
Strg + J
Strg + L
Strg + M
Strg + Q
Strg + T
Strg + F1
Strg + F2
Strg + Shift + 0
Strg + Shift + ß
Strg + Shift + `
Strg + Shift + #
Strg + Shift + A
Strg + Shift + B
Strg + Shift + C
Strg + Shift + D
Strg + Shift + E
Strg + Shift + F
Strg + Shift + H
Strg + Shift + I
Strg + Shift + J
Strg + Shift + L
Strg + Shift + M
Strg + Shift + N
Strg + Shift + P
Strg + Shift + Q
Strg + Shift + R
Strg + Shift + T
Strg + Shift + V
Strg + Shift + W
Strg + Shift + X
Strg + Shift + Y
Strg + Shift + Z
Strg + Shift + F1
Strg + Shift + F2
Strg + Shift + F5
Strg + Shift + F7
Strg + Shift + F8
Strg + Shift + F9
Strg + Shift + F11
Strg + Alt + F3
Strg + Alt + F5
Strg + Alt + F6
Strg + Alt + F7
Strg + Alt + F8
Strg + Alt + F9
Strg + Alt + F10
Strg + Alt + F11
Strg + Alt + F12

Hey Chandoo
if you don’t like so LONG comment’s
– please delete my threads –
regards Stef@n

Nice Idea… I’ll will put in my list as soon as it is ready for this !!!
But don’t prepare this sheet instead of taking care of your nice twins

Chandoo, you mentioned…
Copy the value from the cell above the active cell into the cell or the formula bar
Editing
CTRL + SHIFT + ”

You can also use CTRL + D.

Never mind what I said… It’s there already.

Try CTRL ~ (tilde). This command will view any worksheet formulas. This is great for quick on the fly eyeballing a worksheet that you are reviewing.

This is my second post, not sure if the first one went through.

Hey
CTRL ~ (tilde)
is
STRG #
in Germany
but it doesn’t work in switzerland :O
…
what i mean:
It does not seem quite so easy to create a “comprehensive” overview
best regards
Stef@n

Greetings,
Stef@n

I am not sure about what the translation is for this in Switzerland (Swedish), however the purpose of the command (CTRL ~ ) is to view all of the cell data and range formulas in a worksheet in one view. Maybe we can try something together to make it work for you. Let me know what your feedback is…. are you getting a message in EXCEL when you use this command?
Also, maybe you have a Global setting function that might prevent this from working? Let’s see what we can come up with together.

Hey
I think that problem is the keyboard layout
In Germany there is a button (next to the key input)
you can typed on the following characters
AltGr + shift * ~ (tilde)
So: in many countries, the keyboard layout is different.
ie: Ctrl (AltGr) ~ does not work at all.

The following formulas only when you press Ctrl #

the only way is, in my view – the use of vba

Sub formulasHide ()
ActiveWindow.DisplayFormulas = False
End Sub
Sub formulasFade ()
ActiveWindow.DisplayFormulas = True
End Sub

regards Stef@n

Stef@n

Thanks for the info. I never really thought about how this may work in other countries. let me know if I can help on anything else.

Best regards,
Michael

Quick reference sheet:

EXCEL : http://www.its.qut.edu.au/assist/userguides/exfiles/xl.pdf
WORD : http://www.its.qut.edu.au/assist/userguides/exfiles/office.pdf

Not forgot the original source at Microsoft Office Excel 2007 shortcut and function keys here:
http://office.microsoft.com/en-us/excel/HP100738481033.aspx
and the Ribbon, Help, and other Microsoft Office keyboard shortcuts here:
http://office.microsoft.com/en-us/excel/HA101680811033.aspx?pid=CH100947761033
and how to disable user interface items and shortcut keys here:
http://technet.microsoft.com/en-us/library/cc179143.aspx
Anyone want to generate a pdf with everything?

@Chandoo.. Professionally I am interested about Accessibility in Office System as shown here:
http://www.microsoft.com/enable/products/office2007/
and keyboard navigation:
http://office.microsoft.com/training/Training.aspx?AssetID=RP100664581033&CTT=6&Origin=RC100664431033
and keyboard shortcuts:
http://www.microsoft.com/enable/products/keyboard.aspx
but in Spanish language as shown here:
http://office.microsoft.com/es-es/excel/HP100738483082.aspx
You should know that keyboard shortcuts methods are different in different languages and with different keyboard layouts, so your mammoth project to assemble all in one piece it should apply only to English language and there is no automatic translator to translate the keyboard shortcuts methods.
For my part, once you publish the English sheet, I could be able to develop the corresponding Spanish version.

Great list. Love the Select Visible Cells Only. That saves a lot clicks with Edit/GoTo/Special/Visible Cells Only.
Thanks!

Not technically Excel Shortcuts but these works just the same

Windows Button + Right/Left Arrow – Toggles from Current Window position to Left Half Display, Right Half Display and Back to Current View
Windows Button + Up Arrow – Toggles from Current Window position to Full Screen Display and back to current position
Windows Button + Down Arrow – Toggles from Current Window position to minimised position

Alternate Keyboard Shortcut for Right Click – Press the Menu Button which is located between the Alt and Ctrl keys on the Right Side of the Space Bar.

I added custom keyboard shortcuts using Simple Shortcuts (http://www.simpleshortcuts.net)... It’s addictive. They have these cool customizable cycles that save me a ton of time. It looks like they’re working on a new program called Smart Shortcuts (http://www.smartshortcuts.com) that is supposed to be even better. I can’t wait to try it…

Chandoo,

I haven’t seen this one yet in the list – Ctrl+6

When you have a chart covering your dataset toggle Ctrl+6 to clear the chart out of the way and back again

I know you can drag sheet tabs with the mouse to re-order them and even drag them from one workbook into another but I didn’t know (until about 5 mins. ago) – if you hold the Ctrl key and then drag the sheet tab it will create a duplicate.

PS Is it common knowledge that the office button (xl 2007) when clicked once (to open the menu also turns red and if you click it once more will act as an ‘Off’ button completely closing Excel. Not great if you stutter a mouse click – everything shuts!

anyone tried the ALT + PGUp or ALT + PGDown. It pages left and right, so easy to scan accross a table rather than using left/right arrow, or CTRL & left/right arrow which can take you too far.

Another v. easy method to generate your own shortcuts is to use icons. Eg, the paste values icon, with the name “&V” means that if I now type ALT + V it will paste values.

Hi,

Use full information for all that people whom r learning Excel