| Shortcut key | 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 | 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 the 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 Formula 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 the 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 | Tools, Options, Calculation, Calc Sheet | All |
| Ctrl+Alt+F9 | Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. | None | Excel 97/2000 + |
| Ctrl+Alt+Shift+F9 | Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. | None | Excel 97/2000 + |
| 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 dialogue 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 the row and column labels | Insert, Name, Create | All |
| Ctrl+Shift+F6 | Previous Window | Window, … | All |
| Ctrl+Shift+F12 | 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 the formula | No direct equivalent | All |
| Alt+Down arrow | Display AutoComplete list | None | Excel 95 |
| Alt+’ | Format Style dialogue 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 the current region around the active cell. In a PivotTable report, select the entire PivotTable report. | 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 dialogue 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, Standard | 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 In a workbook: activate next workbook |
None | Excel 97/2000 + |
| Shift+Ctrl+Tab | In toolbar: previous toolbar In a workbook: activate the previous workbook |
None | Excel 97/2000 + |
| Tab | Next tool | None | Excel 97/2000 + |
| Shift+Tab | Previous tool | None | Excel 97/2000 + |
| Enter | Do the command | None | Excel 97/2000 + |
| Alt+Enter | Start a new line in the same cell. | None | Excel 97/2000 + |
| Ctrl+Enter | Fill the selected cell range with the current entry. | None | Excel 97/2000 + |
| Shift+Ctrl+F | Font Drop Down List | Format, Cells, Font | All |
| Shift+Ctrl+F+F | Font tab of Format Cell Dialog box | Format, Cells, Font | Before 97/2000 |
| Shift+Ctrl+P | Point size Drop Down List | Format, Cells, Font | All |
| Ctrl+Spacebar | Select the entire column | None | Excel 97/2000 + |
| Shift+Spacebar | Select the entire row | None | Excel 97/2000 + |
| CTRL+/ | Select the array containing the active cell. | ||
| CTRL+SHIFT+O | Select all cells that contain comments. | ||
| CTRL+\ | In a selected row, select the cells that don’t match the formula or static value in the active cell. | ||
| CTRL+SHIFT+| | In a selected column, select the cells that don’t match the formula or static value in the active cell. | ||
| CTRL+[ | Select all cells directly referenced by formulas in the selection. | ||
| CTRL+SHIFT+{ | Select all cells directly or indirectly referenced by formulas in the selection. | ||
| CTRL+] | Select cells that contain formulas that directly reference the active cell. | ||
| CTRL+SHIFT+} | Select cells that contain formulas that directly or indirectly reference the active cell. | ||
| ALT+; | Select the visible cells in the current selection. | ||
| SHIFT+BACKSPACE | With multiple cells selected, select only the active cell. | ||
| CTRL+SHIFT+SPACEBAR | Selects the entire worksheet. 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 |
||
| Ctrl+Alt+L | Reapply the filter and sort on the current range so that changes you’ve made are included | Data, Reapply | Excel 2007+ |
| Ctrl+Alt+V | Displays the Paste Special dialogue box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. | Home, Paste, Paste Special… | Excel 2007+ |
Similar Posts
All Keyboard Shortcuts of Adobe Photoshop
Menu Basics Shortcuts ACTION PHOTOSHOP SHORTCUTS Preference Ctrl + K File menu Alt + F Edit menu Alt + E Image menu Alt + I Layer menu Alt + L Select menu Alt + S Filter menu Alt + T 3D menu Alt + D Window menu Alt + W Show keyboard shortcuts menu Ctrl…
How to watch today’s big Canon cinema camera launch
Tune in to ascertain the complete unveiling of Canon’s new cinema camera If the Canon EOS R5 doesn’t quite have the video powers you would like for your filmmaking adventures, then you would possibly want to tune into today’s Canon Vision event, where it’ll be announcing an exciting new Canon cinema camera. Canon has already…
How to Disable Ads on Xiaomi Apps
Xiaomi users are now frustrated with the Ads being shown on all MI Apps. Also, Xiaomi executive confirmed on Weibo post that they are working on a new UI which will have fewer ads. The new UI (MIUI 11) will be released within 2 – 3 months. But now we have a solution for…
Update BGMI’s testing Application(1st Update of Battleground Mobile India)
Battlegrounds Mobile India (BGMI)’s early access was launched on Play Store today, 17 June 2021. Indian fans can attend the official Play Store page of BGMI to download the sport. However, the official ways are plagued with many issues. Firstly, the early-access registration page of the Play Store was down for quite some time thanks to server overload,…
Google made an app for creditors Remotely Lock Your financed phone if you don’t make payments
Device Lock Controller Nowadays We all have seen most of the smartphones are high price and flagship in the market. Whereas normal people can’t afford to buy those smartphones. That’s why big companies like Apple, Samsung, And One plus provide credit facilities to help them pay the amount as monthly installments. And if for some…