List of MS Excel Shortcuts Keys

List of MS Excel Shortcuts Keys

Microsoft Excel is a practical tool developed by Microsoft widely used by professionals, students, companies, etc., to create, manipulate, and analyze data using a grid of cells arranged in rows and columns. Whether you’re arranging data, creating charts or managing employees data MS Excel shortcuts keys, commands and array of features can help you work more efficiently. One way to be proficient in Excel skills is by mastering the various keyboard shortcuts or commands it offers.

Here you can explore a comprehensive list of MS Excel shortcuts keys especially beneficial for candidates preparing for competitive exams in Pakistan. Because testing agencies like PPSC, FPSC, KPPSC, BPSC, SPSC, NTS, OTS, CSS MPT, etc., commonly asks about Keyboard shortcuts in the form of MCQs in computer section. On the other hand, these will also help the aspirants to pass the proficiency test organized by these departments before final interview.

Need for Excel Shortcuts

MS Excel Shortcuts keys are combinations of keyboard strokes that allow you to perform tasks quickly and efficiently, often without the need to navigate through menus and ribbons. Using Excel shortcut keys not only saves your time but also enhances your productivity.
Speed: Excel Keyboard shortcuts can incredibly reduce the time it takes to perform common tasks, making you more efficient in your work.
Accuracy: By using Excel shortcuts, you can minimize the risk of errors that can occur when navigating through multiple menus.
Ease of Use: Learning and using shortcut keys can make Excel more accessible and user-friendly, even for beginners.

Now, let’s dive into a list of essential MS Excel shortcut keys, which are particularly valuable for aspirants preparing for competitive exams.

Excel Shortcuts Cheat Sheet

Ctrl + Alphabet Keys (Qwerty Alphabet Keys)
Ctrl + ASelect All
Ctrl + BBold
Ctrl + CCopy
Ctrl + DFill Down
Ctrl + EFlash Fill
Ctrl + FFind
Ctrl + GGoto
Ctrl + HReplace
Ctrl + IItalic
Ctrl + KInsert Hyperlink
Ctrl + NNew Workbook
Ctrl + OOpen
Ctrl + PPrint
Ctrl + RFill Right
Ctrl + SSave
Ctrl + UUnderline
Ctrl + VPaste
Ctrl + WClose
Ctrl + XCut
Ctrl + YRepeat
Ctrl + ZUndo
Ctrl + Symbols (Qwerty Symbols)
Ctrl + :Insert Current Time
Ctrl + ;Insert Current Date
Ctrl + “Copy Value from Cell Above
Ctrl + ‘Copy Formula from Cell Above
Ctrl + `Toggle Value/Formula display
Ctrl + +Insert a New Row below the active cell
Ctrl + –Delete a row or column
Ctrl + SpacebarSelect the entire column
Ctrl + BackspaceJump back to the active cell and bring it into view
Ctrl + /Select the array containing the active cell
Ctrl + \In a selected row, 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 + ]Select cells that contain formulas that directly reference the active cell
Ctrl + TabSwitches between the open workbooks (left to right) if you have more than one workbook open at once.
Ctrl + EnterFill the selected cell range with the current entry
Ctrl + Number Keys
Ctrl + 1Format cells dialog box
Ctrl + 2Bold
Ctrl + 3Italic
Ctrl + 4Underline
Ctrl + 5Strikethrough
Ctrl + 6Show/Hide objects
Ctrl + 7Show/Hide Standard toolbar
Ctrl + 8Toggle Outline symbols
Ctrl + 9Hide rows
Ctrl + 0Hide columns
Function Keys
F2Edit the Active Cell
F3Display the Paste Name dialog box
F4Repeat Last Command or Action
F5Displays the Goto dialog box
F6Next Pane/Task Pane/Zoom Control/Switch between the worksheet
F7Spelling Dialog Box/Spell Check
F8Turn Extend mode On or Off
F9Recalculate all workbooks/Calculate formula in a specific cell or range of cells
F10Activate Menubar
F11New Chart
F12Save As
Shift + Function Keys
Shift + F1Display “What’s This?” window in early versions of Excel
Shift + F2Add or Edit Cell comment
Shift + F3Insert Function Dialog Box
Shift + F4Find Next
Shift + F5Open Find Dialog Box
Shift + F6Move to Previous Pane
Shift + F8Add to selection
Shift + F9Calculate active worksheet
Shift + F10Display shortcut menu for selected item/Cell
Shift + F11Insert a New Worksheet
Shift + F12Save the open workbook
Ctrl + Function Keys
Ctrl + F3Display the Name Manager
Ctrl + F4Close the Current workbook
Ctrl + F5Restore Window Size
Ctrl + F6Switch to Next Workbook
Ctrl + F7Move command on the workbook window
Ctrl + F8Resize Window Command
Ctrl + F9Minimize workbook
Ctrl + F10Maximize or restore window
Ctrl + F11Insert a Macro Sheet
Ctrl + F12Open a File
Alt + Function Keys
Alt + F1Insert Chart of the data in the current range
Alt + F2Open Save As Option
Alt + F4Close all workbooks / Exit
Alt + F8Open Macro Dialog Box
Alt + F11Display Microsoft Visual Basic Editor
Ctrl + Shift + Function Keys
Ctrl + Shift + F3Create name by using names of row and column labels
Ctrl + Shift + F6Previous Window
Ctrl + Shift + F12Print
Alt + Shift + Function Keys
Alt + Shift + F1New worksheet
Alt + Shift + F2Save
Alt + Keys
AltActivate the menu
Alt + =AutoSum
Alt + Down ArrowDisplay AutoFilter list for the current column/Opens a selected drop-down list
Alt + ‘Format Style dialog box
Alt + EnterStart a new line in the same cell
Alt + ;Select the visible cells in the current selection
Ctrl + Alt + Keys
Ctrl + Alt + F9Calculate all worksheets in all open workbooks
Ctrl + Alt + LApply the filter function
Ctrl + Alt + VOpen the Paste Special dialog
Ctrl + Alt + Shift + F9Rechecks dependent formulas
Shift + Keys
ShiftHold down shift for additional functions in Excel’s menu
Shift + SpacebarSelect the entire row
Shift + BackspaceShow the active cell on worksheet
Shift + TabMove to the previous option or option group
Ctrl + Shift + Keys
Ctrl + Shift + PPoint size Drop Down List
Ctrl+ Shift + F6Previous workbook window
Ctrl + Shift + AInsert argument names into formula
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 around selected cells
Ctrl + Shift + *Select the current region around the active cell
Ctrl + Shift + 9Unhide Rows
Ctrl + Shift + 0Unhide Columns
Ctrl + Shift + OSelect all cells that contain comments/notes
Ctrl + Shift + |Select the cells that don’t match the value in the active cell
Ctrl + Shift + }Select cells that contain formulas that directly or indirectly reference the active cell
Ctrl + Shift + {Select all cells directly or indirectly referenced by formulas in the selection
Ctrl + Shift + SpacebarSelect the entire work sheet.

These MS Excel shortcuts Keys are not only essential for competitive exam preparation but are also help for anyone looking to learn excel sheets and enhance their spreadsheet skills. Whether you’re a student aiming for success in competitive exams or simply want to boost your Excel proficiency, integrating various excel shortcuts into your workflow can make you more productive and capable.