Action | Menu equivalent comments | Version | |
| Ctrl+A | Select All | None | All |
| Ctrl+B | Bold | Format, Cells, Font, Font Style, Bold | All |
| Ctrl+C | Copy | Edit, Copy | All |
| Ctrl+D | Fill Down | Edit, Fill, Down | All |
| Ctrl+F | Find | Edit, Find | All |
| Ctrl+G | Goto | Edit, Goto | All |
| Ctrl+H | Replace | Edit, Replace | All |
| Ctrl+I | Italic | Format, Cells, Font, Font Style, Italic | All |
| Ctrl+K | Insert Hyperlink | Insert, Hyperlink | Excel 97/2000 |
| Ctrl+N | New Workbook | File, New | All |
| Ctrl+O | Open | File, Open | All |
| Ctrl+P | Print | File, Print | All |
| Ctrl+R | Fill Right | Edit, Fill Right | All |
| Ctrl+S | Save | File, Save | All |
| Ctrl+U | Underline | Format, Cells, Font, Underline, Single | All |
| Ctrl+V | Paste | Edit, Paste | All |
| Ctrl W | Close | File, Close | Excel 97/2000 |
| Ctrl+X | Cut | Edit, Cut | All |
| Ctrl+Y | Repeat | Edit, Repeat | All |
| Ctrl+Z | Undo | Edit, Undo | All |
| F1 | Help | Help, Contents and Index | All |
| F2 | Edit | None | All |
| F3 | Paste Name | Insert, Name, Paste | All |
| F4 | Repeat last action | Edit, Repeat. Works while not in Edit mode. | All |
| F4 | While typing a formula, switch between absolute/relative refs | None | All |
| F5 | Goto | Edit, Goto | All |
| F6 | Next Pane | None | All |
| F7 | Spell check | Tools, Spelling | All |
| F8 | Extend mode | None | All |
| F9 | Recalculate all workbooks | Tools, Options, Calculation, Calc,Now | All |
| F10 | Activate Menubar | N/A | All |
| F11 | New Chart | Insert, Chart | All |
| F12 | Save As | File, Save As | All |
| Ctrl+: | Insert Current Time | None | All |
| Ctrl+; | Insert Current Date | None | All |
| Ctrl+" | Copy Value from Cell Above | Edit, Paste Special, Value | All |
| Ctrl+' | Copy Fromula from Cell Above | Edit, Copy | All |
| Shift | Hold down shift for additional functions in Excel's menu | none | Excel 97/2000 |
| Shift+F1 | What's This? | Help, What's This? | All |
| Shift+F2 | Edit cell comment | Insert, Edit Comments | All |
| Shift+F3 | Paste function into formula | Insert, Function | All |
| Shift+F4 | Find Next | Edit, Find, Find Next | All |
| Shift+F5 | Find | Edit, Find, Find Next | All |
| Shift+F6 | Previous Pane | None | All |
| Shift+F8 | Add to selection | None | All |
| Shift+F9 | Calculate active worksheet | Calc Sheet | All |
| Shift+F10 | Display shortcut menu | None | All |
| Shift+F11 | New worksheet | Insert, Worksheet | All |
| Shift+F12 | Save | File, Save | All |
| Ctrl+F3 | Define name | Insert, Names, Define | All |
| Ctrl+F4 | Close | File, Close | All |
| Ctrl+F5 | XL, Restore window size | Restore | All |
| Ctrl+F6 | Next workbook window | Window, ... | All |
| Shift+Ctrl+F6 | Previous workbook window | Window, ... | All |
| Ctrl+F7 | Move window | XL, Move | All |
| Ctrl+F8 | Resize window | XL, Size | All |
| Ctrl+F9 | Minimize workbook | XL, Minimize | All |
| Ctrl+F10 | Maximize or restore window | XL, Maximize | All |
| Ctrl+F11 | Inset 4.0 Macro sheet | None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro | All |
| Ctrl+F12 | File Open | File, Open | All |
| Alt+F1 | Insert Chart | Insert, Chart... | All |
| Alt+F2 | Save As | File, Save As | All |
| Alt+F4 | Exit | File, Exit | All |
| Alt+F8 | Macro dialog box | Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions | Excel 97/2000 |
| Alt+F11 | Visual Basic Editor | Tools, Macro, Visual Basic Editor | Excel 97/2000 |
| Ctrl+Shift+F3 | Create name by using names of row and column labels | Insert, Name, Create | All |
| Ctrl+Shift+F6 | Previous Window | Window, ... | All |
| Ctrl+Shift+F12 | Print | File, Print | All |
| Alt+Shift+F1 | New worksheet | Insert, Worksheet | All |
| Alt+Shift+F2 | Save | File, Save | All |
| Alt+= | AutoSum | No direct equivalent | All |
| Ctrl+` | Toggle Value/Formula display | Tools, Options, View, Formulas | All |
| Ctrl+Shift+A | Insert argument names into formula | No direct equivalent | All |
| Alt+Down arrow | Display AutoComplete list | None | Excel 95 |
| Alt+' | Format Style dialog box | Format, Style | All |
| Ctrl+Shift+~ | General format | Format, Cells, Number, Category, General | All |
| Ctrl+Shift+! | Comma format | Format, Cells, Number, Category, Number | All |
| Ctrl+Shift+@ | Time format | Format, Cells, Number, Category, Time | All |
| Ctrl+Shift+# | Date format | Format, Cells, Number, Category, Date | All |
| Ctrl+Shift+$ | Currency format | Format, Cells, Number, Category, Currency | All |
| Ctrl+Shift+% | Percent format | Format, Cells, Number, Category, Percentage | All |
| Ctrl+Shift+^ | Exponential format | Format, Cells, Number, Category, | All |
| Ctrl+Shift+& | Place outline border around selected cells | Format, Cells, Border | All |
| Ctrl+Shift+_ | Remove outline border | Format, Cells, Border | All |
| Ctrl+Shift+* | Select current region | Edit, Goto, Special, Current Region | All |
| Ctrl++ | Insert | Insert, (Rows, Columns, or Cells) Depends on selection | All |
| Ctrl+- | Delete | Delete, (Rows, Columns, or Cells) Depends on selection | All |
| Ctrl+1 | Format cells dialog box | Format, Cells | All |
| Ctrl+2 | Bold | Format, Cells, Font, Font Style, Bold | All |
| Ctrl+3 | Italic | Format, Cells, Font, Font Style, Italic | All |
| Ctrl+4 | Underline | Format, Cells, Font, Font Style, Underline | All |
| Ctrl+5 | Strikethrough | Format, Cells, Font, Effects, Strikethrough | All |
| Ctrl+6 | Show/Hide objects | Tools, Options, View, Objects, Show All/Hide | All |
| Ctrl+7 | Show/Hide Standard toolbar | View, Toolbars, Stardard | All |
| Ctrl+8 | Toggle Outline symbols | None | All |
| Ctrl+9 | Hide rows | Format, Row, Hide | All |
| Ctrl+0 | Hide columns | Format, Column, Hide | All |
| Ctrl+Shift+( | Unhide rows | Format, Row, Unhide | All |
| Ctrl+Shift+) | Unhide columns | Format, Column, Unhide | All |
| Alt or F10 | Activate the menu | None | All |
| Ctrl+Tab | In toolbar: next toolbar | None | Excel 97/2000 |
| Shift+Ctrl+Tab | In toolbar: previous toolbar | None | Excel 97/2000 |
| Ctrl+Tab | In a workbook: activate next workbook | None |
skip to main |
skip to sidebar
BASIC SHORTCUT KEYS
Alt + F File menu options in current program
Alt + E Edit options in current program
F1 Universal help (for all programs)
Ctrl + A Select all text
Ctrl + X Cut selected item
Shift + Del Cut selected item
Ctrl + C Copy selected item
Ctrl + Ins Copy selected item
Ctrl + V Paste
Shift + Ins Paste
Home Go to beginning of current line
Ctrl + Home Go to beginning of document
End Go to end of current line
Ctrl + End Go to end of document
Shift + Home Highlight from current position to beginning of line
Shift + End Highlight from current position to end of line
Ctrl + f Move one word to the left at a time
Ctrl + g Move one word to the right at a time
MICROSOFT WINDOWS SHORTCUT KEYS:
Alt + Tab Switch between open applications
Alt + Shift + Tab Switch backwards between open applications
Alt + Print Screen Create screen shot for current program
Ctrl + Alt + Del Reboot/Windows® task manager
Ctrl + Esc Bring up start menu
Alt + Esc Switch between applications on taskbar
F2 Rename selected icon
F3 Start find from desktop
F4 Open the drive selection when browsing
F5 Refresh contents
Alt + F4 Close current open program
Ctrl + F4 Close window in program
Ctrl + Plus Key Automatically adjust widths of all columns in Windows Explorer
Alt + Enter Open properties window of selected icon or program
Shift + F10 Simulate right-click on selected item
Shift + Del Delete programs/files permanently
Holding Shift During Bootup
Boot safe mode or bypass system files
Holding Shift During Bootup
When putting in an audio CD, will prevent
CD Player from playing
WINKEY SHORTCUTS:
WINKEY + D Bring desktop to the top of other windows
WINKEY + M Minimize all windows
WINKEY + SHIFT + M Undo the minimize done by
WINKEY + M and WINKEY + D
WINKEY + E Open Microsoft Explorer
WINKEY + Tab Cycle through open programs on taskbar
WINKEY + F Display the Windows® Search/Find feature
WINKEY + CTRL + F Display the search for computers window
WINKEY + F1 Display the Microsoft® Windows® help
WINKEY + R Open the run window
WINKEY + Pause /Break Open the system properties window
WINKEY + U Open utility manager
WINKEY + L Lock the computer (Windows XP® & later)
OUTLOOK SHORTCUT KEYS:
Alt + S Send the email
Ctrl + C Copy selected text
Ctrl + X Cut selected text
Ctrl + P Open print dialog box
Ctrl + K Complete name/email typed in address bar
Ctrl + B Bold highlighted selection
Ctrl + I Italicize highlighted selection
Ctrl + U Underline highlighted selection
Ctrl + R Reply to an email
Ctrl + F Forward an email
Ctrl + N Create a new email
Ctrl + Shift + A Create a new appointment to your calendar
Ctrl + Shift + O Open the outbox
Ctrl + Shift + I Open the inbox
Ctrl + Shift + K Add a new task
Ctrl + Shift + C Create a new contact
Ctrl + Shift+ J Create a new journal entry
WORD SHORTCUT KEYS:
Ctrl + A Select all contents of the page
Ctrl + B Bold highlighted selection
Ctrl + C Copy selected text
Ctrl + X Cut selected text
Ctrl + N Open new/blank document
Ctrl + O Open options
Ctrl + P Open the print window
Ctrl + F Open find box
Ctrl + I Italicize highlighted selection
Ctrl + K Insert link
Ctrl + U Underline highlighted selection
Ctrl + V Paste
Ctrl + Y Redo the last action performed
Ctrl + Z Undo last action
Ctrl + G Find and replace options
Ctrl + H Find and replace options
Ctrl + J Justify paragraph alignment
Ctrl + L Align selected text or line to the left
Ctrl + Q Align selected paragraph to the left
Ctrl + E Align selected text or line to the center
Ctrl + R Align selected text or line to the right
Ctrl + M Indent the paragraph
Ctrl + T Hanging indent
Ctrl + D Font options
Ctrl + Shift + F Change the font
Ctrl + Shift + > Increase selected font +1
Ctrl + ] Increase selected font +1
Ctrl + Shift + < Decrease selected font -1
Ctrl + [ Decrease selected font -1
Ctrl + Shift + * View or hide non printing characters
Ctrl + f Move one word to the left
Ctrl + g Move one word to the right
Ctrl + h Move to beginning of the line or paragraph
Ctrl + i Move to the end of the paragraph
Ctrl + Del Delete word to right of cursor
Ctrl + Backspace Delete word to left of cursor
Ctrl + End Move cursor to end of document
Ctrl + Home Move cursor to beginning of document
Ctrl + Space Reset highlighted text to default font
Ctrl + 1 Single-space lines
Ctrl + 2 Double-space lines
Ctrl + 5 1.5-line spacing
Ctrl + Alt + 1 Change text to heading 1
Ctrl + Alt + 2 Change text to heading 2
Ctrl + Alt + 3 Change text to heading 3
F1 Open help
Shift + F3 Change case of selected text
Shift + Insert Paste
F4 Repeat last action performed (Word 2000+)
F7 Spell check selected text and/or document
Shift + F7 Activate the thesaurus
F12 Save as
Ctrl + S Save
Shift + F12 Save
Alt + Shift + D Insert the current date
Alt + Shift + T Insert the current time
Ctrl + W Close document
EXCEL SHORTCUT KEYS:
F2 Edit the selected cell
F5 Go to a specific cell
F7 Spell check selected text and/or document
F11 Create chart
Ctrl + Shift + ; Enter the current time
Ctrl + ; Enter the current date
Alt + Shift + F1 Insert new worksheet
Shift + F3 Open the Excel® formula window
Shift + F5 Bring up search box
Ctrl + A Select all contents of worksheet
Ctrl + B Bold highlighted selection
Ctrl + I Italicize highlighted selection
Ctrl + C Copy selected text
Ctrl + V Paste
Ctrl + D Fill
Ctrl + K Insert link
Ctrl + F Open find and replace options
Ctrl + G Open go-to options
Ctrl + H Open find and replace options
Ctrl + U Underline highlighted selection
Ctrl + Y Underline selected text
Ctrl + 5 Strikethrough highlighted selection
Ctrl + O Open options
Ctrl + N Open new document
Ctrl + P Open print dialog box
Ctrl + S Save
Ctrl + Z Undo last action
Ctrl + F9 Minimize current window
Ctrl + F10 Maximize currently selected window
Ctrl + F6 Switch between open workbooks/windows
Ctrl + Page up & Page Down
Move between Excel worksheets in the same document
Ctrl + Tab Move between two or more open Excel files
Alt + = Create formula to sum all of above cells
Ctrl + ‘ Insert value of above cell into current cell
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
Ctrl + g Move to next section of text
Ctrl + Space Select entire column
Shift + Space Select entire row
Ctrl + W Close document
Alt + E Edit options in current program
F1 Universal help (for all programs)
Ctrl + A Select all text
Ctrl + X Cut selected item
Shift + Del Cut selected item
Ctrl + C Copy selected item
Ctrl + Ins Copy selected item
Ctrl + V Paste
Shift + Ins Paste
Home Go to beginning of current line
Ctrl + Home Go to beginning of document
End Go to end of current line
Ctrl + End Go to end of document
Shift + Home Highlight from current position to beginning of line
Shift + End Highlight from current position to end of line
Ctrl + f Move one word to the left at a time
Ctrl + g Move one word to the right at a time
MICROSOFT WINDOWS SHORTCUT KEYS:
Alt + Tab Switch between open applications
Alt + Shift + Tab Switch backwards between open applications
Alt + Print Screen Create screen shot for current program
Ctrl + Alt + Del Reboot/Windows® task manager
Ctrl + Esc Bring up start menu
Alt + Esc Switch between applications on taskbar
F2 Rename selected icon
F3 Start find from desktop
F4 Open the drive selection when browsing
F5 Refresh contents
Alt + F4 Close current open program
Ctrl + F4 Close window in program
Ctrl + Plus Key Automatically adjust widths of all columns in Windows Explorer
Alt + Enter Open properties window of selected icon or program
Shift + F10 Simulate right-click on selected item
Shift + Del Delete programs/files permanently
Holding Shift During Bootup
Boot safe mode or bypass system files
Holding Shift During Bootup
When putting in an audio CD, will prevent
CD Player from playing
WINKEY SHORTCUTS:
WINKEY + D Bring desktop to the top of other windows
WINKEY + M Minimize all windows
WINKEY + SHIFT + M Undo the minimize done by
WINKEY + M and WINKEY + D
WINKEY + E Open Microsoft Explorer
WINKEY + Tab Cycle through open programs on taskbar
WINKEY + F Display the Windows® Search/Find feature
WINKEY + CTRL + F Display the search for computers window
WINKEY + F1 Display the Microsoft® Windows® help
WINKEY + R Open the run window
WINKEY + Pause /Break Open the system properties window
WINKEY + U Open utility manager
WINKEY + L Lock the computer (Windows XP® & later)
OUTLOOK SHORTCUT KEYS:
Alt + S Send the email
Ctrl + C Copy selected text
Ctrl + X Cut selected text
Ctrl + P Open print dialog box
Ctrl + K Complete name/email typed in address bar
Ctrl + B Bold highlighted selection
Ctrl + I Italicize highlighted selection
Ctrl + U Underline highlighted selection
Ctrl + R Reply to an email
Ctrl + F Forward an email
Ctrl + N Create a new email
Ctrl + Shift + A Create a new appointment to your calendar
Ctrl + Shift + O Open the outbox
Ctrl + Shift + I Open the inbox
Ctrl + Shift + K Add a new task
Ctrl + Shift + C Create a new contact
Ctrl + Shift+ J Create a new journal entry
WORD SHORTCUT KEYS:
Ctrl + A Select all contents of the page
Ctrl + B Bold highlighted selection
Ctrl + C Copy selected text
Ctrl + X Cut selected text
Ctrl + N Open new/blank document
Ctrl + O Open options
Ctrl + P Open the print window
Ctrl + F Open find box
Ctrl + I Italicize highlighted selection
Ctrl + K Insert link
Ctrl + U Underline highlighted selection
Ctrl + V Paste
Ctrl + Y Redo the last action performed
Ctrl + Z Undo last action
Ctrl + G Find and replace options
Ctrl + H Find and replace options
Ctrl + J Justify paragraph alignment
Ctrl + L Align selected text or line to the left
Ctrl + Q Align selected paragraph to the left
Ctrl + E Align selected text or line to the center
Ctrl + R Align selected text or line to the right
Ctrl + M Indent the paragraph
Ctrl + T Hanging indent
Ctrl + D Font options
Ctrl + Shift + F Change the font
Ctrl + Shift + > Increase selected font +1
Ctrl + ] Increase selected font +1
Ctrl + Shift + < Decrease selected font -1
Ctrl + [ Decrease selected font -1
Ctrl + Shift + * View or hide non printing characters
Ctrl + f Move one word to the left
Ctrl + g Move one word to the right
Ctrl + h Move to beginning of the line or paragraph
Ctrl + i Move to the end of the paragraph
Ctrl + Del Delete word to right of cursor
Ctrl + Backspace Delete word to left of cursor
Ctrl + End Move cursor to end of document
Ctrl + Home Move cursor to beginning of document
Ctrl + Space Reset highlighted text to default font
Ctrl + 1 Single-space lines
Ctrl + 2 Double-space lines
Ctrl + 5 1.5-line spacing
Ctrl + Alt + 1 Change text to heading 1
Ctrl + Alt + 2 Change text to heading 2
Ctrl + Alt + 3 Change text to heading 3
F1 Open help
Shift + F3 Change case of selected text
Shift + Insert Paste
F4 Repeat last action performed (Word 2000+)
F7 Spell check selected text and/or document
Shift + F7 Activate the thesaurus
F12 Save as
Ctrl + S Save
Shift + F12 Save
Alt + Shift + D Insert the current date
Alt + Shift + T Insert the current time
Ctrl + W Close document
EXCEL SHORTCUT KEYS:
F2 Edit the selected cell
F5 Go to a specific cell
F7 Spell check selected text and/or document
F11 Create chart
Ctrl + Shift + ; Enter the current time
Ctrl + ; Enter the current date
Alt + Shift + F1 Insert new worksheet
Shift + F3 Open the Excel® formula window
Shift + F5 Bring up search box
Ctrl + A Select all contents of worksheet
Ctrl + B Bold highlighted selection
Ctrl + I Italicize highlighted selection
Ctrl + C Copy selected text
Ctrl + V Paste
Ctrl + D Fill
Ctrl + K Insert link
Ctrl + F Open find and replace options
Ctrl + G Open go-to options
Ctrl + H Open find and replace options
Ctrl + U Underline highlighted selection
Ctrl + Y Underline selected text
Ctrl + 5 Strikethrough highlighted selection
Ctrl + O Open options
Ctrl + N Open new document
Ctrl + P Open print dialog box
Ctrl + S Save
Ctrl + Z Undo last action
Ctrl + F9 Minimize current window
Ctrl + F10 Maximize currently selected window
Ctrl + F6 Switch between open workbooks/windows
Ctrl + Page up & Page Down
Move between Excel worksheets in the same document
Ctrl + Tab Move between two or more open Excel files
Alt + = Create formula to sum all of above cells
Ctrl + ‘ Insert value of above cell into current cell
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
Ctrl + g Move to next section of text
Ctrl + Space Select entire column
Shift + Space Select entire row
Ctrl + W Close document
Accelerating Excel
| To... | Use this shortcut |
Move right to left, cell by cell | Tab |
Move up and down, cell by cell | Enter |
Erase data in current cell | Backspace |
Return to the beginning of the row | Home |
Enter the date | Ctrl + ; (semicolon) |
Enter the time | Ctrl + Shift + : (colon) |
Start a formula | = (equal sign) |
Check the spelling of titles or words within the cells | F7 |
Find out about the style within the cell | ALT + ' (apostrophe) |
Display the Format Cells dialog box | Ctrl + 1 |
Apply the general number format | Ctrl + Shift + ~ |
Turn numbers into dollars | Ctrl + Shift + $ |
Make numbers a percentage | Ctrl + Shift + % |
Apply a border | Ctrl + Shift + & |
No comments:
Post a Comment