Microsoft Excel Shortcut Keys

Microsoft Excel Shortcut Keys

The followings are Microsoft Excel shortcuts. Some short-cuts might be version specific.
Use at your own risk.

Mouse shortcuts

Shortcut Description   
Double-click (on a cell) Edit the cell contents.   
Double-click (on a row/column divider) Adjust height/width to auto-fit   
High-light headers of multiple rows/columns then Double-click on a row/column divider Adjust height/width to auto-fit of all high-lighted rows/columns   
Triple-click Select the entire contents in the cell   
Click on row/column divider then drag Adjust height/width of the row/colunn   
High-light headers of multiple rows/columns then Click on row/column divider then drag Adjust height/width of the rows/colunns   
Ctrl + Mouse wheel Zooms in and out of document.   
Hold Shift + Click the cells Select multiple cells


Keyboard shortcuts

Shortcut Description   
F2 Edit the selected cell.   
F5 Goto a specific cell. For example, C6.   
F7 Spell check selected text and/or document.   
F11 Create chart.   
Ctrl + A Select all.   
Ctrl + B Bold.   
Ctrl + C Copy.   
Ctrl + F Find (same as Shift + F5).   
Ctrl + G Go To.   
Ctrl + H Replace.   
Ctrl + I Italic.   
Ctrl + K Insert link.   
Ctrl + N New Workbook.   
Ctrl + O Open Workbook.   
Ctrl + P Print dialog.   
Ctrl + S Save.   
Ctrl + U Underline.   
Ctrl + V Paste.   
Ctrl + Z Undo.   
Ctrl + Y Redo.   
Ctrl + X Cut.   
Ctrl + 5 Strikethrough text.   
Ctrl + F3 Define Name.   
Ctrl + F4 Exit Excel.   
Ctrl + F6 Switch between open workbooks.   
Ctrl + F9 Minimize current window.   
Ctrl + F10 Maximize current window.   
Shift + F1 Activate Help on Item.   
Shift + F2 Insert Comments   
Shift + F3 Insert Function.   
Ctrl + Shift + ; Enter the current time.   
Ctrl + ; Enter the current date.   
Ctrl + Page down Move to next worksheet.   
Ctrl + Page up Move to previous worksheet.   
Ctrl + Shift + # Number Format: Date    
Ctrl + Shift + @ Number Format: Time.   
Ctrl + Shift + ! Number Format: Commas.   
Ctrl + Shift + $ Number Format: Currency    
Ctrl + Shift + % Number Format: Percentage   
Ctrl + Shift + ^ Number Format: Scientific.   
Ctrl + Space Select entire column.   
Shift + Space Select entire row.   
Ctrl + (Arrow key) Move to next section.