ADVANCED EXCEL KEYBOARD SHORTCUTS EXCEL KEYSTROKES ACTION EXCEL KEYSTROKES ACTION DATA SELECTION / NAVIGATION FORMATTING Ctrl + Pg Up / Pg Down Move to Prior / Next Worksheet Alt + E + S, then: Paste Special (copy first) Shift / Ctrl + Spacebar Select Entire Row / Column F, T, V Formulas, Format, Value. Excel Keyboard Shortcuts PDF Download Posted September 1, 2019. September 28, 2020. Online Training For Everyone. A Microsoft Excel test is a pre-employment hiring assessment that employers use during the recruitment process to check how proficient candidates are with Microsoft Excel. Spreadsheets allow users to input and analyse data.
Excel Shortcuts
Hello Friends,
List Of Shortcut Keys For Excel
In various competitive exams such as IBPS, SBI, UPSC and SSC few questions are asked based on MS Excel Shortcut Keys. This PDF file will not only help you in answering such questions in exams but will also be useful on day to day basis in your job.
| Excel Shotcuts | Action |
| ALT+SHIFT+F1 | Insert new worksheet |
| F2 | Edit the selected cell |
| F5 | Go to a specific cell |
| F11 | Create Chart |
| CTRL+1 | Bring up Format Cells Dialog box |
| CTRL+A | Select All |
| CTRL+B | Bold |
| CTRL+C | Copy |
| CTRL+F | Find |
| CTRL+H | Find and Replace |
| CTRL+I | Italicize |
| CTRL+N | Create New Excel Document |
| CTRL+P | Bring up Print Dialog box |
| CTRL+S | Save |
| CTRL+U | Underline |
| CTRL+V | Paste |
| CTRL+X | Cut |
| CTRL+Y | Repeat last action/Redo |
| CTRL+Z | Undo |
| CTRL+SHIFT+F | Opens Fonts Preference Window |
| CTRL+F9 | Minimise current workbook |
| CTRL+F10 | Maximum current workbook |
| CTRL+F6 | Switch between open Excel documents |
| CTRL+Space | Select entire column |
| CTRL+Home | Go to the beginning of Word Document |
| CTRL+End | Go to the end of the Word Document |
| SHIFT+Space | Select entire row |
| SHIFT+F3 | Open Formula Window |
Also Read:
Thank You
Excel Shortcut Keys Pdf Free Download
GK Babaji