MS Excel Shortcut Keys PDF 2023, Most Used MS Excel Shortcut Keys PDF for Windows, Ribbon keyboard shortcuts Keys for Windows.
| PDF Name | MS Excel Shortcut Keys PDF |
| No. of Pages | 17 |
| PDF Size | 796 kb |
| Language | English |
| PDF Category | Education & Jobs |
| Published/Updated | May 18, 2022 |
| Source / Credits | MyPdf |
| Uploaded By | MyPdf |
MS Excel Shortcut Keys PDF
Microsoft Excel is a powerful spreadsheet application that can help you with various tasks, from data entry to data analysis. Here are some of the most useful keyboard shortcuts that can help you work more efficiently in Excel:
MS Excel Shortcut Keys PDF – General
| Function | Key |
|---|---|
| Open Help | F1 |
| Undo Last Action | Ctrl+Z |
| Redo last action | Ctrl+Y |
| Copy selection | Ctrl+C |
| Repeat last action | F4 |
| Cut Selection | Ctrl+X |
| Paste content from clipboard | Ctrl+V |
| Display the Paste Special dialog box | Ctrl+Alt+V |
| Display find and replace with find tab selected | Ctrl+F |
| Display nd and replace with Replace tab selected | Ctrl+H |
| Find previous match (after initial Find) | Ctrl+Shift+F4 |
| Find next match (after initial Find) | Shift +F4 |
| Insert embedded chart | Alt+F1 |
| Insert chart in new sheet | F11 |
| Toggle Autolter | Ctrl+Shift+L |
| Activate filter | Alt+↧ |
| Create table | Ctrl+T |
| Select table row | Shift+Space |
| Select table column | Ctrl + Space |
| Select table (when active cell is in table) | Ctrl+A |
| Clear slicer lter | Alt+C |
| Run Spellcheck | F7 |
| Open Thesaurus | Shift+F7 |
| Open Macro dialog box | Alt+F8 |
| Open VBA Editor | Alt+F11 |
| Duplicate object | Ctrl+D |
| Snap to grid (whilst dragging) | Alt |
| Hide or show objects | Ctrl+6 |
| Open Modify Cell Style dialog box | Alt+’ |
| Show right-click menu | Shift+F10 |
| Display control menu | Alt+Space |
Read More: Basic Autocad Shortcut Keys PDF 2023
MS Excel Shortcut Keys PDF – Worksheet
| Function | Key |
|---|---|
| Insert new worksheet | Shift+F11 |
| Go to next worksheet | Ctrl+PgDn |
| Go to previous worksheet | Ctrl+PgUp |
| Rename current worksheet | Alt+O, H,R |
| Delete current worksheet | Alt+E,L |
| Move current worksheet | Alt+E, M |
| Move between the worksheet, Ribbon, task pane and zoom controls in a worksheet that has been split | F6 or Shift+F6 |
| Select adjacent worksheets | Ctrl+Shift+PgUp/PgDn |
| Select non-adjacent worksheets | Ctrl+Click |
| Toggle scroll lock | ScrLk |
| Toggle full screen | Ctrl+Shift+F1 |
| Ctrl+P | |
| Open print preview window | Ctrl+F2 |
| Set print area | Alt+P, R S |
| Clear print area | Alt+P, R C |
| Zoom in | Ctrl+ Mouse Wheel Up |
| Zoom out | Ctrl+ Mouse Wheel Down |
| Protect sheet | Alt+R, PS |
MS Excel Shortcut Keys PDF – Workbook
| Functional | Key |
|---|---|
| Create new workbook | Ctrl+N |
| Open workbook | Ctrl+O |
| Save workbook | Ctrl+S |
| Save as | F12 |
| Go to next workbook | Ctrl+Tab |
| Go to previous workbook | Ctrl+Shift+Tab |
| Minimize current workbook window | Ctrl+F9 |
| Maximize current workbook window | Ctrl+F10 |
| Protect workbook | Alt+R, PW |
| Close current workbook | Ctrl+F4 |
| Close Excel | Alt+F4 |
MS Excel Shortcut Keys PDF – Ribbon
| Function | Key |
|---|---|
| Expand or collapse ribbon | Ctrl+F1 |
| Activate access keys | Alt |
| Move through Ribbon tabs and groups | ↦ ↤ ↥ ↧ |
| Activate or open selected control | Space or Enter |
| Conrm control change | Enter |
| Get help on selected control | F1 |
Navigation Excel Shortcuts
- Move one cell right – →
- Move one cell left – ←
- Move one cell up – ↑
- Move one cell down – ↓
- Move one screen right – Alt + PgDn
- Move one screen left – Alt + PgUp
- Move one screen up – PgUp
- Move one screen down – PgDn
- Move to right edge of data region – Ctrl + →
- Move to left edge of data region – Ctrl + ←
- Move to top edge of data region – Ctrl + ↑
- Move to bottom edge of data region – Ctrl + ↓
- Move to beginning of row – Home
- Move to last cell in worksheet that contains data – Ctrl + End
- Move to rst cell in worksheet – Ctrl + Home
- Turn End mode on – End
Read More: Basic Maths Formulas Pdf Download
Formatting Excel Shortcuts
- Format cells – Ctrl + 1
- Display Format Cells with Font tab selected – Ctrl + Shift + F
- Apply or remove bold – Ctrl + B
- Apply or remove italics – Ctrl + I
- Apply or remove underscore – Ctrl + U
- Apply or remove strikethrough – Ctrl + 5
- Align center – Alt + H , A C
- Align left – Alt + H , A L
- Indent – Alt + H , 6
- Remove indent – Alt + H , 5
- Wrap text – Alt + H , W
- Align top – Alt + H , A T
- Align middle – Alt + H , A M
- Align bottom – Alt + H , A B
- Increase font size one step – Alt + H , F G
- Decrease font size one step – Alt + H , F K
Number Formatting Excel Shortcuts
- Apply general format – Ctrl + Shift + ~
- Apply number format – Ctrl + Shift + !
- Apply time format – Ctrl + Shift + @
- Apply date format – Ctrl + Shift + #
- Apply currency format – Ctrl + Shift + $
- Apply percentage format – Ctrl + Shift + %
- Apply scientic format – Ctrl + Shift + ^
Note: These shortcuts may vary based on the version of Excel you are using and the keyboard layout you have selected.
So, don’t delay and download the PDF from the link given below.
You can download the MS Excel Shortcut Keys PDF at the link given below:
Report This: We DO NOT own any copyrights of this PDF File. If you want this to be removed or if it is copyright infringement, do drop us an email at [email protected] and this will be taken down within 24 hours!
Download: Agents of Socialization Pdf Download
