Here is a comprehensive list of more than 125 keyboard shortcuts in Excel. You can download the entire list of keyboard shortcut keys as an Excel workbook here. These shortcuts cover formatting cells and worksheets, inserting rows and columns, calculations, handling workbooks and a number of other useful keys that will make you an Excel Keyboard expert in no time.
| Shortcut key | Action |
| Alt or F10 | Activate menu |
| Alt + ’ | Format Style dialog box |
| Alt + = | AutoSum |
| Alt + Down arrow | Display AutoComplete list |
| Alt + Enter | Start a new line in the same cell |
| Alt + Esc | Toggle Between most recent two applications in taskbar |
| Alt + F1 | Insert a Chart sheet |
| Alt + F11 | Open Visual Basic Editor |
| Alt + F2 | Save As |
| Alt + F4 | Exit Workbook |
| Alt + F8 | Macro dialog box |
| Alt + i + c | Insert column |
| Alt + i + r | Insert row |
| Alt + Shift + F1 | New worksheet |
| Alt + Shift + F2 | Save Workbook |
| Ctrl W | Close Workbook |
| Ctrl + – | Delete |
| Ctrl + " | Copy Value from Cell Above |
| Ctrl + : | Insert Current Time |
| Ctrl + ; | Insert Current Date |
| Ctrl + 0 | Hide columns |
| Ctrl + 1 | Format cells dialog box |
| Ctrl + 2 | Bold |
| Ctrl + 3 | Italic |
| Ctrl + 4 | Underline |
| Ctrl + 5 | Strikethrough |
| Ctrl + 6 | Show/Hide objects |
| Ctrl + 7 | Show/Hide Standard toolbar |
| Ctrl + 8 | Toggle Outline symbols |
| Ctrl + 9 | Hide rows |
| Ctrl + A | Select All Cells in range |
| Ctrl + Alt + F9 | Forces FULL calculation of all worksheets in all open workbooks |
| Ctrl + Alt + Shift + F9 | Forces FULL calculation with dependency tree rebuild |
| Ctrl + B | Bold |
| Ctrl + C | Copy |
| Ctrl + D | Fill Down |
| Ctrl + End | Move to last used cell in a worksheet |
| Ctrl + Enter | Fill the selected cell range with the current entry. |
| Ctrl + F | Find |
| Ctrl + F10 | Maximize or restore window |
| Ctrl + F11 | Inset 4.0 Macro sheet |
| Ctrl + F12 | File Open |
| Ctrl + F3 | Define name |
| Ctrl + F4 | Close |
| Ctrl + F5 | XL, Restore window size |
| Ctrl + F6 | Next workbook window |
| Ctrl + F7 | Move window |
| Ctrl + F8 | Resize window |
| Ctrl + F9 | Minimize workbook |
| Ctrl + G | Goto |
| Ctrl + H | Replace |
| Ctrl + Home | Move to the first non-header cell of the sheet |
| Ctrl + I | Italic |
| Ctrl + K | Insert Hyperlink |
| Ctrl + N | New Workbook |
| Ctrl + N | New Workbook |
| Ctrl + O | Open |
| Ctrl + P | |
| Ctrl + Page Down | Move to next worksheet |
| Ctrl + Page Up | Move to previous worksheet |
| Ctrl + R | Fill Right |
| Ctrl + Right Arrow | Move to right end of range |
| Ctrl + Right Arrow | Move to right end of range |
| Ctrl + S | Save |
| Ctrl + Shift + ! | Comma format |
| Ctrl + Shift + + | Insert Cells, Rows, Columns |
| Ctrl + Shift + # | Date format |
| Ctrl + Shift + $ | Currency format |
| Ctrl + Shift + % | Percent format |
| Ctrl + Shift + & | Place outline border around selected cells |
| Ctrl + Shift + ( | Unhide rows |
| Ctrl + Shift + ) | Unhide columns |
| Ctrl + Shift + * | Select current region |
| Ctrl + Shift + @ | Time format |
| Ctrl + Shift + ^ | Exponential format |
| Ctrl + Shift + _ | Remove outline border |
| Ctrl + Shift + ~ | General format |
| Ctrl + Shift + 1 | Format cell to two decimal places |
| Ctrl + Shift + 2 | Format cell to time |
| Ctrl + Shift + 3 | Format cell to date |
| Ctrl + Shift + 4 | Format cell to currency |
| Ctrl + Shift + 5 | Format cell to percentage |
| Ctrl + Shift + 6 | Format cell to scientific notation |
| Ctrl + Shift + 7 | Draws outline around your selection |
| Ctrl + Shift + A | Insert argument names into formula |
| Ctrl + Shift + Enter | Used to enter an array formula |
| Ctrl + Shift + F12 | |
| Ctrl + Shift + F3 | Create name by using names of row and column labels |
| Ctrl + Shift + F6 | Previous Window |
| Ctrl + Spacebar | Select the current column |
| Ctrl + Tab | In a workbook: activate next workbook |
| Ctrl + U | Underline |
| Ctrl + V | Paste |
| Ctrl + X | Cut |
| Ctrl + Y | Repeat |
| Ctrl + Z | Undo |
| Enter | Do the command |
| F1 | Help |
| F10 | Activate Menubar |
| F11 | New Chart |
| F12 | Save As |
| F2 | Edit |
| F3 | Paste Name |
| F4 | Repeat last action |
| F4 | While typing a formula, switch between absolute/relative refs |
| F5 | Goto |
| F6 | Next Pane |
| F7 | Spell check |
| F8 | Extend mode |
| F9 | Recalculate all workbooks |
| Shift | Hold down shift for additional functions in Excel’s menu |
| Shift + Ctrl + F | Font Drop Down List |
| Shift + Ctrl + F + F | Font tab of Format Cell Dialog box |
| Shift + Ctrl + F6 | Previous workbook window |
| Shift + Ctrl + P | Point size Drop Down List |
| Shift + Ctrl + Tab | In toolbar: previous toolbar |
| Shift + Ctrl + Tab | In a workbook: activate previous workbook |
| Shift + Enter | Go to previous cell |
| Shift + F1 | What’s This? |
| Shift + F10 | Display shortcut menu |
| Shift + F11 | New worksheet |
| Shift + F12 | Save |
| Shift + F2 | Edit cell comment |
| Shift + F3 | Paste function into formula |
| Shift + F4 | Find Next |
| Shift + F5 | Find |
| Shift + F6 | Previous Pane |
| Shift + F8 | Add to selection |
| Shift + F9 | Re-calculate active worksheet |
| Shift + Spacebar | Select the current row |
| Shift + Tab | Previous application in taskbar |
| Tab | Next tool |
Table Formula in Excel (Something I didn’t Know Till Yesterday) 
Named Range – A Few Quickies 
So How Many Of These Excel Shortcuts Do You Know, Punk ? 
Custom Format to Catch Numbers Appearing as Text 
Keyboard Shortcuts in Excel to Sort, Add, Hide Pivot Table Items and Fields 
Sparklines in Excel – New Features in Excel 2010 Series 
Wow…Great collection. I see a lot of good information here. I will come back for more.
April 29th, 2009 at 2:11 pm