EXCEL SHORTCUTS

Function Short cut
Select All Ctrl+A
Bold Ctrl+B
Copy Ctrl+C
Fill Down Ctrl+D
Find Ctrl+F
Goto Ctrl+G
Replace Ctrl+H
Italic Ctrl+I
Insert Hyperlink Ctrl+K
New Workbook Ctrl+N
Open Ctrl+O
Print Ctrl+P
Fill Right Ctrl+R
Save Ctrl+S
Underline Ctrl+U
Paste Ctrl+V
Close Ctrl W
Cut Ctrl+X
Repeat Ctrl+Y
Undo Ctrl+Z
Help F1
Edit F2
Paste Name F3
Repeat last action F4
While typing a formula, switch between absolute/relative refs F4
Goto F5
Next Pane F6
Spell check F7
Extend mode F8
Recalculate all workbooks F9
Activate Menubar F10
New Chart F11
Save As F12
Insert Current Time Ctrl+:
Insert Current Date Ctrl+;
Copy Value from Cell Above Ctrl+”
Copy Formula from Cell Above Ctrl+’
Hold down shift for additional functions in Excel’s menu Shift
What’s This? Shift+F1
Edit cell comment Shift+F2
Paste function into formula Shift+F3
Find Next Shift+F4
Find Shift+F5
Previous Pane Shift+F6
Add to selection Shift+F8
Calculate active worksheet Shift+F9
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. Ctrl+Alt+F9
Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. Ctrl+Alt+Shift+F9
Display shortcut menu Shift+F10
New worksheet Shift+F11
Save Shift+F12
Define name Ctrl+F3
Close Ctrl+F4
XL, Restore window size Ctrl+F5
Next workbook window Ctrl+F6
Previous workbook window Shift+Ctrl+F6
Move window Ctrl+F7
Resize window Ctrl+F8
Minimize workbook Ctrl+F9
Maximize or restore window Ctrl+F10
Inset 4.0 Macro sheet Ctrl+F11
File Open Ctrl+F12
Insert Chart Alt+F1
Save As Alt+F2
Exit Alt+F4
Macro dialog box Alt+F8
Visual Basic Editor Alt+F11
Create name by using names of row and column labels Ctrl+Shift+F3
Previous Window Ctrl+Shift+F6
Print Ctrl+Shift+F12
New worksheet Alt+Shift+F1
Save Alt+Shift+F2
AutoSum Alt+=
Toggle Value/Formula display Ctrl+`
Insert argument names into formula Ctrl+Shift+A
Display AutoComplete list Alt+Down arrow
Format Style dialog box Alt+’
General format Ctrl+Shift+~
Comma format Ctrl+Shift+!
Time format Ctrl+Shift+@
Date format Ctrl+Shift+#
Currency format Ctrl+Shift+$
Percent format Ctrl+Shift+%
Exponential format Ctrl+Shift+^
Place outline border around selected cells Ctrl+Shift+&
Remove outline border Ctrl+Shift+_
Select the current region around the active cell. In a PivotTable report, select the entire PivotTable report. Ctrl+Shift+*
Insert Ctrl++
Delete Ctrl+-
Format cells dialog box Ctrl+1
Bold Ctrl+2
Italic Ctrl+3
Underline Ctrl+4
Strikethrough Ctrl+5
Show/Hide objects Ctrl+6
Show/Hide Standard toolbar Ctrl+7
Toggle Outline symbols Ctrl+8
Hide rows Ctrl+9
Hide columns Ctrl+0
Unhide rows Ctrl+Shift+(
Unhide columns Ctrl+Shift+)
Activate the menu Alt or F10
In toolbar: next toolbar Ctrl+Tab
In a workbook: activate next workbook
In toolbar: previous toolbar Shift+Ctrl+Tab
In a workbook: activate previous workbook
Next tool Tab
Previous tool Shift+Tab
Do the command Enter
Start a new line in the same cell. Alt+Enter
Fill the selected cell range with the current entry. Ctrl+Enter
Font Drop Down List Shift+Ctrl+F
Font tab of Format Cell Dialog box Shift+Ctrl+F+F
Point size Drop Down List Shift+Ctrl+P
Select the entire column Ctrl+Spacebar
Select the entire row Shift+Spacebar
Select the array containing the active cell. CTRL+/
Select all cells that contain comments. CTRL+SHIFT+O
In a selected row, select the cells that don’t match the formula or static value in the active cell. CTRL+\
In a selected column, select the cells that don’t match the formula or static value in the active cell. CTRL+SHIFT+|
Select all cells directly referenced by formulas in the selection. CTRL+[
Select all cells directly or indirectly referenced by formulas in the selection. CTRL+SHIFT+{
Select cells that contain formulas that directly reference the active cell. CTRL+]
Select cells that contain formulas that directly or indirectly reference the active cell. CTRL+SHIFT+}
Select the visible cells in the current selection. ALT+;
With multiple cells selected, select only the active cell. SHIFT+BACKSPACE
Selects the entire worksheet. CTRL+SHIFT+SPACEBAR
If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet.
When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet
Reapply the filter and sort on the current range so that changes you’ve made are included Ctrl+Alt+L
Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. Ctrl+Alt+V
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s