Microsoft Office Shortcut commands list

Microsoft Office Shortcut 

Ctrl+A - Select All

Ctrl+B - Bold

Ctrl+C - Copy

Ctrl+D - Fill Down

Ctrl+F - Find

Ctrl+G - Goto

Ctrl+H - Replace

Ctrl+I - Italic

Ctrl+K - Insert Hyperlink

Ctrl+N - New Workbook

Ctrl+O - Open

Ctrl+P - Print

Ctrl+R - Fill Right

Ctrl+S - Save

Ctrl+U - Underline

Ctrl+V - Paste

Ctrl W - Close

Ctrl+X - Cut

Ctrl+Y - Repeat

Ctrl+Z - Undo

F1 - Help

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

F10 - Activate Menubar

F11 - New Chart

F12 - Save As

Ctrl+: - Insert Current Time

Ctrl+; - Insert Current Date

Ctrl+" - Copy Value from Cell Above

Ctrl+’ - Copy Formula from Cell Above

Shift - Hold down shift for additional functions in Excel’s menu

Shift+F1 - What’s This?

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 - Calculate active worksheet

Shift+F10 - Display shortcut menu

Shift+F11 - New worksheet

Shift+F12 - Save

Ctrl+F3 - Define name

Ctrl+F4 - Close

Ctrl+F5 - XL, Restore window size

Ctrl+F6 - Next workbook window

Shift+Ctrl+F6 - Previous workbook window

Ctrl+F7 - Move window

Ctrl+F8 - Resize window

Ctrl+F9 - Minimize workbook

Ctrl+F10 - Maximize or restore window

Ctrl+F11 - Inset 4.0 Macro sheet

Ctrl+F1 - File Open

Alt+F1 - Insert Chart

Alt+F2 - Save As

Alt+F4 - Exit

Alt+F8 - Macro dialog box

Alt+F11 - Visual Basic Editor

Ctrl+Shift+F3 - Create name by using names of row and column labels

Ctrl+Shift+F6 - Previous Window

Ctrl+Shift+F12 - Print

Alt+Shift+F1 - New worksheet

Alt+Shift+F2 - Save

Alt+= - AutoSum

Ctrl+` - Toggle Value/Formula display

Ctrl+Shift+A - Insert argument names into formula

Alt+Down arrow - Displayy AutoComplete list

Alt+’ - Format Style dialog box

Ctrl+Shift+~ - 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 current region

Ctrl++ - Insert

Ctrl+- - Delete

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+0 - Hide columns

Ctrl+Shift+( - Unhide rows

Ctrl+Shift+) - Unhide columns

Alt or F10 - Activate the menu

Ctrl+Tab - In toolbar: next toolbar

Shift+Ctrl+Tab - In toolbar: previous toolbar

Ctrl+Tab - In a workbook: activate next workbook 

Shift+Ctrl+Tab - In a workbook: activate previous workbook

Tab - Next tool

Shift+Tab - Previous tool

Enter - Do the command

Shift+Ctrl+F - Font Drop Down List

Shift+Ctrl+F+F - Font tab of Format Cell Dialog box

Shift+Ctrl+P - Point size Drop Down List

Previous Post
Next Post
Related Posts

0 Comments:

Follow by Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.