Monday, August 20, 2012

Excel Hot Keys

Undo: Ctrl+Z
Copy: Ctrl+C
Paste: Enter
Multiple Paste: Ctrl+V
Cut: Ctrl+X
Find: Ctrl + F
Find & Replace: Ctrl + H
Print: Ctrl + P
Save: Ctrl + S
Close: Ctrl + F4
Close Excel: Alt + F4
Move to edge of region: Ctrl + Arrow
Select current region: Ctrl + *
Select all cells: Ctrl + A
Select A1: Ctrl + Home
Select last cell in used range: Ctrl + End
Select from active cell to last cell in used range: Ctrl+Shift+End
Select from active cell to A1: Ctrl+Shift+Home
Move to the next sheet: Ctrl+PageDown
Move to the previous sheet: Ctrl+PageUp
Move to next open workbook: Ctrl + Tab
Open new workbook: Ctrl + N
Insert new worksheet: Shift + F11
Paste function window: Shift + F3
Insert new function: = + FunctionName + Ctrl + A
Open VBE: Alt+F11
Array formula: Ctrl+Shift+Enter
Define name: Ctrl + F3
Paste name: F3
Select columns: Ctrl + Spacebar
Select rows: Shift + Spacebar
Format Cells: Ctrl+1,
Bold: Ctrl+B
Underline: Ctrl+U
Current Date: Ctrl+;
Current time: Ctrl+shift+:
Hide Cell: Ctrl + 9
Unhide Cell: Ctrl + Shift + 9
Hide Column: Ctrl + 0
Unhide Column: Ctrl + Shift + 0

F2 Edit the selected cell.
F5 Go to a specific cell. For example, C6.
F7 Spell check selected text and/or document.
F11 Create chart.
Alt + Shift + F1 Insert New Worksheet.
Shift + F3 Open the Excel formula window.
Shift + F5 Bring up search box.
Ctrl + 5 Strikethrough highlighted selection.
Ctrl + P Bring up the print dialog box to begin printing.
Ctrl + F9 Minimize current window.
Ctrl + F10 Maximize currently selected window.
Ctrl + F6 Switch between open workbooks / windows.
Alt + = Create a formula to sum all of the above cells
Ctrl + ' Insert the value of the above cell into cell currently selected.
Ctrl + Shift + ! Format number in comma format.
Ctrl + Shift + $ Format number in currency format.
Ctrl + Shift + # Format number in date format.
Ctrl + Shift + % Format number in percentage format.
Ctrl + Shift + ^ Format number in scientific format.
Ctrl + Shift + @ Format number in time format.

No comments: