Excel Shortcuts For Quick Reference

Excel Shortcuts for Quick Reference is a guide that provides a comprehensive list of keyboard shortcuts for Microsoft Excel, which can help users to perform common tasks more efficiently and quickly. It is a useful resource for both beginners and advanced users who want to streamline their Excel workflow and save time. By memorizing and utilizing these shortcuts, users can improve their productivity and achieve their goals in Excel with ease.


CTRL+0Opens a workbook
CTRL+NCreate a new workbook
CTRL+PDisplays the print dialog box
CTRL+SSave the workbook
CTRL+WCloses the selected workbook
CTRL+F2Displays print view
F9Calculates all open workbooks
SHIFT+F9Calculates the active worksheet
CTRL+F10Maxmize / workbook
SHIFT+F11Inserts a new worksheet
F12Displays the Save As dialog box


CTRL+SHIFT+~Applies general format
CTRL+SHIFT+$Applies currency format with two decimal places
CTRL+SHIFT+%Applies percentage format with no decimal places.
CTRL+SHIFT+#Applies date format
CTRL+SHIFT+@Applies time format
CTRL+SHIFT+!Applies the Number format with two decimal places, thousands separator
CTRL+1Displays the Format Cells box


CTRL+~Toggles values and formulas
SHIFT+F3Insert Function dialog box
CTRL+F3Name manager box
ALT+M+VEvaluate formula box
CTRL+SHIFT+UExpand/collapse of the formula bar
CTRL+F1Displays or hides the Ribbon
CTRL+SHIFT+LApplies / removes filter
ALT+A+QAdvanced filter
ATL+T+0Excel options


CTRL+SHIFT+:Enters the current time
CTRL+;Enters the current date
CTRL+CCopies the selected cells
CTRL+DCopies topmost cell of a range into the cells below
CTRL+RCopies leftmost cell of a range into cells to right
CTRL+FFind dialog box
CTRL+H+Replace dialog box
CTRL+KEdit hyperlink
CTRL+TCreate Table dialog box
CTRL+ALT+VPaste Special Dialog box
CTRL+XCuts the selected cells
CTRL+ZUndoes last action
SHIFT+F2Adds/edits comment
F4Generates absolute and relative references
F7Spell check
ALT+F8Opens Macro Dialog box
ALT+F11Opens VB Editor
ALT+D+POpens pivot table wizard
ALT+A+MRemoves duplicates
ALT+A+EText to columns Wizard
ALT+ENTEREnters a new line
ALT+D+LData validation
TABLeft cell to right cell
SHIFT+TABRight cell to left cell
CTRL+G or F5Go To dialog box
CTRL+ENDMoves to last used cell
CTRL+HomeMoves to the first used cell
ALT+PAGE DOWNMoves one screen to the right in a worksheet.
CTRL+PAGE DOWNMoves to the next sheet in a workbook
ALT+PAGE UPMoves one screen to the left in a worksheet
CTRL+PAGE UPMoves to the previous sheet in a workbook
CTRL+ArrowMoves to the edge of the current data region

Excel Shortcuts CTRL + F1 to F12

CTRL ShortcutAction
CTRL+F1Displays or hides the ribbon
CTRL+F2Displays the print preview area on the Print tab in the Backstage view
CTRL+F3Opens Name manager
CTRL+F4Closes the selected workbook window
CTRL+F5Restores the window size of the selected workbook window
CTRL+F6Switches between 2 Excel windows
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 when a workbook is not maximized
CTRL+F9Minimizes a workbook window to an icon
CTRL+F10Maximizes or restores the selected workbook window
CTRL+F11Insert a new sheet named Macro1,2….so on
CTRL+F12Display File Open dialog box

Excel Shortcuts CTRL + A to Z

CTRL ShortcutAction
CTRL+ASelect the entire worksheet
CTRL+BApply or remove Bold formatting to font
CTRL+DCopy the contents and format of the topmost cell of a selected range into the cells below
CTRL+EFlash Fill
CTRL+HFind and Replace
CTRL+IApply or remove Italics formatting to font
CTRL+JNot assigned. Still available.
CTRL+KOpen the Insert hyperlink dialog
CTRL+LDisplay the Create Table dialog (Alternative is CTRL+T)
CTRL+MNot assigned. Still available.
CTRL+NCreate a new Workbook
CTRL+ODisplay File Open dialog box
CTRL+PInvokes Print
CTRL+QDisplay the Quick Analysis options for selected cells that contain data
CTRL+RCopy the contents and format of the leftmost cell of a selected range into the cells to the right
CTRL+SSave the workbook
CTRL+TDisplay the Create Table dialog (Alternative is CTRL+L)
CTRL+UApply or remove Underline formatting to font
CTRL+WRedo the last action
CTRL+YRepeat the last command or action
CTRL+ZUndo the last action

Excel Shortcuts CTRL + 0 to 9

CTRL ShortcutAction
CTRL+0Hide the selected columns
CTRL+1Open the Format Cells dialog
CTRL+2Apply or remove Bold formatting to font (CTRL+B)
CTRL+3Apply or remove Italics formatting to font (CTRL+I)
CTRL+4Apply or remove Underline formatting to font (CTRL+U)
CTRL+5Apply or remove strikethrough formatting to font
CTRL+6Switch between hiding objects, displaying objects, and displaying placeholders for objects
CTRL+8Display or hide the outline symbols
CTRL+9Hide the selected rows

Leave a Reply

Your email address will not be published. Required fields are marked *