• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Complete List of Excel Shortcuts – 109 Shortcuts

Complete List of Excel Shortcuts – 109 Shortcuts

Without moving your fingers off the keyboard and without touching the mouse, you can quickly and effeciently accomplish the action and ultimately saving time.

Microsoft Excel is frequently used by finance and accounting professionals on a daily basis. Even users with a basic knowhow of Excel can become more efficient by learning keyboard shortcuts.

I have listed some of the shortcut keys of Microsoft Excel below. You can print this page or you can download here.

Shortcut KeyFunction of Shortcut Key
BACKSPACEDeletes one character to the left in the formula bar. also clears the content of the active cell. in cell editing mode, it deletes the character to the left of the insertion point
SHIFT + CTRL + FActivates font drop down list
SHIFT + CTRL + PActivates font point size drop down list
SHIFT + F2Adds or edits a cell comment
CTRL + 6Alternates between hiding objects, displaying objects, and displaying placeholders for objects
CTRL + 2Applies or removes bold formatting
CTRL + 3Applies or removes italic formatting
CTRL + 5Applies or removes strikethrough
CTRL + 4Applies or removes underlining
CTRL + SHIFT + $Applies the currency format with two decimal places (negative numbers in parentheses)
CTRL + SHIFT + #Applies the date format with the day, month, and year
CTRL + SHIFT + AApplies the exponential number format with two decimal places
CTRL + SHIFT + ~Applies the genral number format
CTRL + SHIFT + !Applies the number format with two decimal places, thousands separator, and minus sign (-) for negative values
CTRL + SHIFT + &Applies the outline border to the selected cells
CTRL + SHIFT + %Applies the percentage format with no decimal places
CTRL + SHIFT + @ Applies the time format with the hour and minute, and am or pm
ALT + = (Equal)Auto sum selected cells and places value in cell beneath
CTRL + BBold
CTRL + ALT + F9 Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation
SHIFT + F9Calculates the active worksheet
ESCCancels an entry in the cell or formula bar. Closes an open menu or submenu, dialog box, or message window. It also doses full screen mode when this mode has been applied, and returns to normal screen mode to display the ribbon and status bar again.
CTRL + WCloses the selected workbook window
CTRL + F4Closes the selected workbook window
SHIFT + ENTER Completes a cell entry and selects the cell above
CTRL + ’ Copies a formula from the cell above the active cell into the cell or the formuula bar
CTRL + SHIFT + ”Copies the value from the cell above the active cell into the cell or the formula bar
CTRL + "Copies values from cell above to current cell
CTRL + CCopy
ALT + F1Creates a chart of data in the current range
CTRL + NCreates a new, blank workbook
CTRL + XCut
CTRL + TDisplay the create table dialog box
CTRL + PDisplay the print dialog box
CTRL + 8Displays or hides the outline symbols
ALT + SPACEBAR Displays the control menu for the microsoft office excel window
CTRL + Minus (-)Displays the delete dialog box to delete the selected cells
CTRL + 1Displays the format cells dialog box
F5Displays the go to dialog box
CTRL + GDisplays the go to dialog box
CTRL+ SHIFT + PIus (+)Displays the insert dialog box to insert blank cells
SHIFT + F3Displays the insert function dialog box
CTRL + KDisplays the insert hyperlink dialog box for new hyperlinks or the edit hyperlink dialog box for selected existing hyperlinks
ALT + F8Displays the macro dialog box to create, run, edit, or delete a macro
ALT + SHIFT + F10Displays the menu or message for a smart tag. if more than one smart tag is present, it switches to the next smart tag and displays its menu or message.
CTRL + ODisplays the open dialog box to open of find a file
F3Displays the paste name dialog box
CTRL + F2Displays the print preview window
F12Displays the save as dialog box
SHIFT + F10Displays the shortcut menu for a selected item
F7Displays the spelling dialog box to check spelling in the active worksheet or selected range
F4During formula typing, adjusts the reference type, abs to relative, otherwise repeats last action
SHIFT + F8Enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys
CTRL + SHIFT + :Enters the current time
SHIFT + ARROW KEYExtends the selection of cells by one cell
CTRL + SHIFT + HOME Extends the selection of cells to the beginning of the worksheet
CTRL + SHIFT + END Extends the selection of cells to the last used cell on the worksheet (lower-right corner)
CTRL + ENTER Fills the selected cell range with the current entry
CTRL + FFind
CTRL + 0Hides the selected columns
CTRL + 9Hides the selected rows
CTRL + ENDIf the cursor is in the formula bar, moves the cursor to the end of the text
CTRL + SHLFT + ENDIf the cursor is in the formula bar, selects all text in the formula bar from the cursor position to the end—this does not affect the height of the formula bar
ALT + SHIFT + F1Insert a new worksheet
SHIFT + F11 Inserts a new worksheet
CTRL + :Inserts current date
CTRL + IItalics
CTRL + F10Maximizes or restores the selected workbook window
CTRL + F9Minimize current workbook
ARROW KEYSMove on cell up, down, left, or right in a worksheet
ALT + PAGE UP Moves one screen to the left in a worksheet
ALT + PAGE DOWN Moves one screen to the right in a worksheet
CTRL + HOME Moves to the beginning of a worksheet
CTRL + ARROW KEYMoves to the edge of the current data region in the worksheet
CTRL + PAGE DOWN Moves to the next sheet in a workbook
SHIFT + TAB Moves to the previous cell in a worksheet or the previous option in a dialog box
CTRL + PAGE UP Moves to the previous sheet in a workbook
ALT + F11Opens the microsoft visual basic editor, in which yon can create a macro by using visual basic for applications (vba)
CTRL + VPaste
CTRL + F7Performs the move command on the workbook window when it is not maximized. use the arrow keys to move the window, and when finished press enter, or esc to cancel
CTRL + F8Performs the size command (on the control menu for the workbook window) when a workbook is not maximized
CTRL + SHIFT + SPACEBARPressing a third time selects the entire worksheet
CTRL + SHIFT + F6Previous workbook window
CTRL + ALT + SHIFT + F9Rechecks dependent formulas, and then calculates all cells in all open workbooks. including cells not marked as needling to l calculated
DELETERemoves the cell contents (data and formulas) from selected cells without affecting cell formats or comments. in cell editing mode, it deletes the character to the right of the insertion point
CTRL + SHIFT + _ (Underscore)Removes the outline border from the selected cells
CTRL + YRepeats the last command or action, if possible
F4Repeats the last command or action, if possible. When a cell reference or range is selected in a formula, cycles through the various combinations of absolute and relative references
CTRL + HReplace
CTRL + F5 Restores the window size of the selected workbook window
CTRL + SSaves the active file with its current file name, location, and file format
CTRL + ASelect all
CTRL + SPACEBARSelects an entire column in a worksheet
SHIFT + SPACEBARSelects an entire row in a worksheet
CTRL + SHIFT + PAGE DOWN Selects the current and next sheet in a workbook
CTRL + SHIFT + PAGE UP Selects the current and previous sheet in a workbook
CTRL + SHIFT + *Selects the current region around the active cell (the data area enclosed by blank columns) in a pivottable, it selects the entire pivottable report
ALT + ENTER Starts a new line in the same cell
SHIFT + F6Switches between the worksheet, zoom controls, task pane, and ribbon
CTRL + TAB Switches to the next tab in dialog box
CTRL + F6Switches to the next workbook window when more than one workbook window is open
CTRL + SHIFT + TAB Switches to the previous tab in a dialog box
CTRL + F11To open Workbook with Macros
CTRL + UUnderline
CTRL + SHIFT + )Unhides any hidden columns within the selection
CTRL + SHIFT + (Unhides any hidden rows within the selection
CTRL + DUses the fill down command to copy the contents and format of the topmost cell of a selected range into the cells below
CTRL + RUses the fill right command to copy the contents and format of the leftmost cell of the selected range into the cells to the right
CTRL + ZUses the undo command to reverse the last command or to delete the last entry that you typed

If you have any queries or questions, share them in comments below and I will be more than happy to help you.

Filed Under: Microsoft Excel

You are Here: Home / Reader's Question / Microsoft Excel / Complete List of Excel Shortcuts – 109 Shortcuts

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • Calculators
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2025. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT