Site icon StudyGyaan

MS Excel Shortcuts Cheat Sheet

Comprehensive Excel Shortcuts Cheat Sheet is your ultimate guide. Discover essential Excel Keyboard Shortcuts with our printable PDF. Master Excel Shortcut Keys for efficient navigation and formula entry. Download our Excel Spreadsheet Shortcut CheatSheet PDF for quick reference and streamline your workflow today!.

Effortlessly move around your Excel sheets and select data with ease.

ShortcutDescription
F2Edits the active cell, putting the cursor at the end
F5Displays the (Edit > GoTo) dialog box
F6Moves to the next pane in a workbook (if the window is split)
F9Calculates All the worksheets in All the open workbooks
F11Displays the (Insert > Chart) dialog box that creates a chart (on a chart sheet) using the highlighted range
Ctrl + F6Moves to the next open workbook or window
Ctrl + ADisplays formula palette given a function name or selects the whole worksheet or current date
Ctrl + GDisplays the GoTo dialog box
Ctrl + Shift + 8Selects the current region (surrounded by blank rows and columns)
Ctrl + /Selects the array containing the active cell
Alt + ;Selects the visible cells in the current selection
Ctrl + Shift + (8 or *)Selects the current region (surrounded by blank rows and columns)
Ctrl + *Selects the current region (using the * on the number keyboard)
Ctrl + [Selects all the cells that are directly referred to by the formula in the active cell (precedents)
Ctrl + Shift + [Selects all the cells that are directly (or indirectly) referred to by the formula in the active cell
Ctrl + ]Selects all the cells that directly refer to the active cell (dependents)
Ctrl + Shift + ]Selects all the cells that directly (or indirectly) refer to the active cell
Ctrl + Shift + Page DownSelects the active worksheet and the one after it
Ctrl + Shift + Page UpSelects the active worksheet and the one before it
Ctrl + Shift + SpacebarSelects all the objects on the worksheet when an object is selected or selects the whole worksheet
Ctrl + SpacebarSelects the current column
Shift + Arrow keysSelects the active cell and the cell in the given direction
Shift + BackspaceSelects the active cell when multiple cells are selected
Shift + SpacebarSelects the current row
Ctrl + Shift + Arrow KeyExtends the selection to the next cell adjacent to a blank cell in that direction
Ctrl + Shift + EndExtends the selection to the last used cell on the worksheet
Ctrl + Shift + HomeExtends the selection to the beginning of the worksheet
Shift + Arrow KeysExtends the selection by one cell in that direction
Shift + HomeExtends the selection to the first column
Shift + Page DownExtends the selection down one screen
Shift + Page UpExtends the selection up one screen
End + Shift + Arrow KeysExtends the selection to the next non-blank cell in that direction
End + Shift + EndExtends the selection to the last cell in the current row
End + Shift + HomeExtends the selection to the last used cell on the worksheet
EnterMoves from top to bottom within a selection
TabMoves from left to right within a selection
Ctrl + .Moves clockwise to the next corner within a selection
Shift + TabMoves from right to left within a selection (opposite direction to Tab)
Alt + Ctrl + Left ArrowMoves to the left between non-adjacent cells in a selection
Alt + Ctrl + Right ArrowMoves to the right between non-adjacent cells in a selection
=Starts a Formula
Ctrl + `Toggles between the value layer and the formula layer
Ctrl + InsertCopies the current selection to the clipboard
Ctrl + Shift + (Unhides any hidden rows within the selection
Ctrl + Shift + )Unhides any hidden columns within the selection
Ctrl + Shift + :Selects unequal cells
Page UpMoves to the previous screen of rows up
Shift + EnterMoves to the cell directly above (opposite direction to Enter)
Shift + TabMoves to the cell directly to the left (opposite direction to Tab)
Alt + Page DownMoves you one screen of columns to the right
Alt + Page UpMoves you one screen of columns to the left
Ctrl + HomeMoves to cell “A1” on the active sheet
Ctrl + EndMoves to the last used cell on the active worksheet
Ctrl + Up ArrowMoves to the first row in the current region
Ctrl + Down ArrowMoves to the last row in the current region
Ctrl + Left ArrowMoves to the first column in the current region
Ctrl + Right ArrowMoves to the last column in the current region
Ctrl + Page UpMoves to the previous worksheet in the workbook
Ctrl + Page DownMoves to the next worksheet in the workbook
Ctrl + Shift + TabMoves to the previous open workbook or window
Scroll Lock + Arrow KeysMoves the workbook or window one cell in the corresponding direction
Scroll Lock + EndMoves to the last cell in the current window
Scroll Lock + HomeMoves to the first cell in the current window
Scroll Lock + Page DownMoves you down one screen (current selection unchanged)
Scroll Lock + Page UpMoves you up one screen (current selection unchanged)

Editing Excel Shortcuts

Make quick edits to your data, formulas, and cell contents for precision and accuracy.

ShortcutDescription
F4Repeats the last worksheet action (Edit > Repeat)
Shift + F2Inserts or edits a cell comment (Insert > Comment)
Shift + F4Repeats the last Find, the same as (Edit > Find Next)
Shift + F9Calculates just the active worksheet
Shift + F11Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet)
Ctrl + BToggles bold on the current selection
Ctrl + CCopies the current selection to the clipboard
Ctrl + DCopies the first cell in the selection downwards
Ctrl + FDisplays the Find dialog box
Ctrl + HDisplays the Replace dialog box
Ctrl + IToggles italics on the current selection
Ctrl + KDisplays the Insert Hyperlink dialog box
Ctrl + LDisplays the Create Table dialog box
Ctrl + NCreates a new workbook
Ctrl + ODisplays the Open dialog box
Ctrl + PDisplays the Print dialog box
Ctrl + RCopies the leftmost cell in the selection to the right
Ctrl + SSaves, Displays the Save As dialog box if a new workbook
Ctrl + UToggles underlining on the current selection
Ctrl + VPastes the entry from the clipboard
Ctrl + WCloses the active workbook or window
Ctrl + XCuts the current selection to the clipboard
Ctrl + YRepeats the last workbook action
Ctrl + ZUndo the last workbook action
Ctrl + Shift + FActivates the Font Tab of the format cells
Ctrl + Shift + OSelects all the cells with comments
Ctrl + Shift + PActivates the Font Size tab of the format cells

File Management Excel Shortcuts

Manage your Excel files efficiently with handy shortcuts for saving, opening, and closing.

ShortcutDescription
F12Displays the (File > Save As) dialog box
Shift + F12Saves, Displays the (File > Save As) dialog box if a new workbook
Ctrl + F4Closes the selected workbook window
Ctrl + F12Displays the (File > Open) dialog box
Alt + F2Displays the (File > Save As) dialog box
Alt + F4Closes all the workbooks (saving first) and exits Excel (File > Exit)

Functionality and Tools Excel Shortcuts

Access powerful Excel functions and tools swiftly to enhance your spreadsheet experience.

ShortcutDescription
F1Displays the Office Assistant or (Help > Microsoft Excel Help)
F3Displays the (Insert > Name > Paste) dialog box
F7Displays the (Tools > Spelling) dialog box
F8Toggles whether to extend a selection with the arrow keys
F10Toggles the activation of the Menu Bar
Shift + F3Displays the (Insert > Function) dialog box
Shift + F5Displays the (Edit > Find) dialog box
Shift + F8Toggles between switching Add Mode on or off
Shift + F10Displays the (Shortcut) menu for the selected item
Ctrl + F1Closes and reopens the current task pane (ribbon in 2007)
Ctrl + F3Displays the (Insert > Name > Define) dialog box
Ctrl + F5Restores the size of the active workbook or window
Ctrl + F7Activates the Move window command
Ctrl + F8Activates the Resize window command
Ctrl + F9Minimizes the size of the active workbook or window
Ctrl + F10Maximizes the size of the active workbook or window
Alt + F1Creates a chart (on a chart sheet) using the highlighted range
Alt + F8Displays the (Tools > Macro > Macros) dialog box

Formatting Excel Shortcuts

Apply formatting to your data and cells swiftly for a professional and polished look.

ShortcutDescription
Ctrl + 0Hides the columns in the current selection
Ctrl + 1Displays the formatting dialog box
Ctrl + 2Toggles bold on the current selection
Ctrl + 3Toggles italics on the current selection
Ctrl + 4Toggles underlining on the current selection
Ctrl + 5Toggles the strikethrough of text on the current selection
Ctrl + 6Toggles between hiding, displaying
Ctrl + 8Toggles the display of Outline symbols on the active worksheet
Ctrl + 9Hides the rows in the current selection (Format > Row > Hide)
Ctrl + Shift + 0Unhides the columns in the current selection
Ctrl + Shift + 2Enters the value from the cell directly above into the active cell
Ctrl + Shift + 9Unhides the rows in the current selection
Alt + ‘Displays the Style dialog box
Ctrl + Shift + ( ‘ or )Applies the Time format “hh:mm” to the selection
Ctrl + Shift + (1 or !)Applies the Comma separated format “#,##0.00” to the selection
Ctrl + Shift + (4 or $)Applies the Currency format “£#,##0.00” to the selection
Ctrl + Shift + (5 or %)Applies the Percentage format “0%” to the selection
Ctrl + Shift + (6 or ^)Applies the Exponential format “#,##E+02” to the selection
Ctrl + Shift + (# or ~)Applies the General format to the selection
Ctrl + (# or ~)Applies the Custom Date format “dd-mmm-yy” to the selection
Ctrl + Shift + (7 or &)Applies the outline border to the selection
Ctrl + Shift + (- or _ )Removes all the borders from the selection

Cell Entry and Navigation Excel Shortcuts

Navigate through cells and enter data efficiently, saving time and effort.

ShortcutDescription
EnterEnters the contents of the active cell and moves to the cell below (by default)
Shift + EnterEnters the contents of the active cell and moves to the cell above (by default)
TabEnters the contents of the active cell and moves one cell to the right
Shift + TabEnters the contents of the active cell and moves one cell to the left
Alt + =Enters the SUM() function (AutoSum) to sum the adjacent block of cells
Alt + 0128Enters the euro symbol (€) (using Number keypad)
Alt + 0162Enters the cent symbol (¢) (using Number keypad)
Alt + 0163Enters the pound sign symbol (£) (using Number keypad)
Alt + EnterEnters a new line (or carriage return) into a cell
Ctrl + ‘Enters the contents from the cell directly above into the active cell
Ctrl + Shift + 2Enters the value from the cell directly above into the active cell
Ctrl + ;Enters the current date into the active cell
Ctrl + Shift + ;Enters the current time into the active cell
Ctrl + Shift + EnterEnters the formula as an Array Formula
Shift + InsertEnters the data from the clipboard
Alt + Down ArrowDisplays the Pick From List drop-down list
EscCancels the cell entry and restores the original contents

Deleting and Clearing Excel Shortcuts

Clear unnecessary data and delete cells with ease to keep your spreadsheet clean and organized.

ShortcutDescription
DeleteDeletes the selection or one character to the right
BackspaceDeletes the selection or one character to the left
Shift + DeleteCuts the selection to the clipboard
Ctrl + DeleteDeletes text to the end of the line
Ctrl + –Displays the Delete dialog box
Ctrl + Shift + =Displays the Cells dialog box
Ctrl + :Selects the cells in a selected row that do not match the value in the active cell
Ctrl + Shift + :Selects the cells in a selected column that do not match the value in the active cell

Other Navigation Excel Shortcuts

Explore additional shortcuts to navigate and select data effectively, improving your productivity.

ShortcutDescription
Arrow KeysMoves to the next cell in that direction
Ctrl + TabMoves to the next open workbook or window
Alt + TabMoves to the next application open on your computer
Alt + Shift + TabMoves to the previous application open on your computer
EnterMoves to the cell directly below
TabMoves to the next cell on the right (or unprotected cell)
HomeMoves to the first column in the current row
End + Arrow KeysMoves to the next non-empty cell in that direction
End + EnterMoves to the last cell in the current row that is not blank
End + HomeMoves to the last used cell on the active worksheet
End + HomeMoves to the last used cell on the active worksheet
Page DownMoves to the next screen of rows down

Download PDF

Exit mobile version