Commonly Used Shortcut Keys Excel 97-2003 v6.0 Action Keystroke Keystroke Action 1 Anchoring cells F4 (in edit cell mode (F2)) 25 Go to end (contiguous range) 2 Auditing toolbar Alt T U 26 Go to precedent cell(s) / Return Ctrl+[ / F5, Enter 3 ...Trace precedents Alt T U T 27 Group rows or columns Alt D G or (Shift+Alt+) 4 ...Trace dependents Alt T U D 28 ...Hide grouped range Alt D G H 5 ...Remove arrows Alt T U A 29 ...Show grouped range Alt D G S 6 Auto sum Alt+= 30 ...Ungroup rows or columns Alt D G or (Shift+Alt+) 7 Borders – outside area Ctrl+Shift+7 31 Highlight a contiguous range Ctrl+Shift+Arrow Keys 8 Borders – remove all Ctrl+Underscore (Ctrl+Shift+–) 32 Highlight entire column / row Ctrl+Spacebar / Shift+Spacebar 9 Clear Alt E A 33 Move a sheet / Copy a sheet Alt E M / Alt E M, Alt+C 10 Comment – inserting Shift+F2 or (Alt I M) 34 Name a cell Alt I N D or (Ctrl+F3) 11 Comment – deleting Alt E A M 35 Page Break Preview / Normal Alt V P / Alt V N 12 Copy / Cut Ctrl+C / Ctrl+X 36 Page setup… Alt F U… 13 … Paste (after copy or cut) Ctrl+V or (Enter) 37 Print Ctrl+P or (Alt F P) 14 Copy, Paste special formats Ctrl+C, Alt E S T 38 Print preview Alt F V 15 Copy, Paste special formulas Ctrl+C, Alt E S F 39 Redo Ctrl+Y 16 Delete / Insert Ctrl+– / Ctrl++ 40 Rename sheet Alt O H R 17 Deselect to original cell Shift+Backspace 41 Repeat F4 18 Edit cell / Highlight precedents F2 42 Replace Ctrl+H 19 Fill right / Fill down Ctrl+R / Ctrl+D 43 Set print area Alt F T S 20 Font – change size Ctrl+Shift+P 44 Tools options Alt T O… 21 Format cells… Ctrl+1 or (Alt O E) 45 Undo Ctrl+Z 22 Function – inserting Alt I F or (Shift+F3) 46 Workbooks – toggle Ctrl+Tab 23 Go to F5 or (Ctrl+G) 47 Worksheets – move between Ctrl+Page Up / Ctrl+Page Down 24 Go to constants (highlight inputs) F5, Alt+S O X 48 Zoom – sizing / return to 100% Alt V Z / Alt V Z 1 © 1999-2012 All rights reserved. Ctrl+Arrow Keys Preparing Financial Professionals for Success Commonly Used Functions © 1999-2012 All rights reserved. Excel 97-2003 Preparing Financial Professionals for Success Commonly Used Shortcut Keys Excel 2007 v6.0 Keystroke Action Action Keystroke 1 Anchoring cells F4 (in edit cell mode (F2)) 25 Go to end (contiguous range) 2 Auditing toolbar Alt M… (See "Formula Auditing") 26 Go to precedent cell(s) / Return Ctrl+[ / F5, Enter 3 ...Trace precedents Alt M P 27 Group rows or columns Alt A G G or (Shift+Alt+) 4 ...Trace dependents Alt M D 28 ...Hide grouped range Alt A H 5 ...Remove arrows Alt M A A 29 ...Show grouped range Alt A J 6 Auto sum Alt+= 30 ...Ungroup rows or columns Alt A U U or (Shift+Alt+) 7 Borders – outside area Ctrl+Shift+7 31 Highlight a contiguous range Ctrl+Shift+Arrow Keys 8 Borders – remove all Ctrl+Underscore (Ctrl+Shift+–) 32 Highlight entire column / row Ctrl+Spacebar / Shift+Spacebar 9 Clear Alt H E 33 Move a sheet / Copy a sheet Alt H O M, Alt+C 10 Comment – inserting Shift+F2 or (Alt R C) 34 Name a cell Alt M M D or (Alt M N N) or (Ctrl+F3) 11 Comment – deleting Alt R D 35 Page Break Preview / Normal Alt W I / Alt W L 12 Copy / Cut Ctrl+C / Ctrl+X 36 Page setup… Alt P S P 13 … Paste (after copy or cut) Ctrl+V or (Enter) 37 Print Ctrl+P or (Alt F P) 14 Copy, Paste special formats Ctrl+C, Alt H V S T or (Ctrl+Alt+V T) 38 Print preview Alt F W V or (Ctrl + F2) 15 Copy, Paste special formulas Ctrl+C, Alt H V F or (Ctrl+Alt+V F) 39 Redo Ctrl+Y 16 Delete / Insert Ctrl+– / Ctrl++ 40 Rename sheet Alt H O R 17 Deselect to original cell Shift+Backspace 41 Repeat F4 18 Edit cell / Highlight precedents F2 42 Replace Ctrl+H 19 Fill right / Fill down Ctrl+R / Ctrl+D 43 Set print area Alt P R S 20 Font – change size Alt H F S or (Ctrl+Shift+P, Alt S) 44 Tools Show More
