Ms Excel all shorcut keys

Shortcut Description
Ctrl+ASelect all page content
Ctrl+B / Ctrl+2Make selected text bold
Ctrl+CCopy the value of selected content
Ctrl+DFill down the value from the above cell
Ctrl+EAlign selected content in center
Ctrl+FOpen Find text dialog box
Ctrl+G or F5Open Go To dialog box
Ctrl+HOpen replace text dialog box
Ctrl+I / Ctrl+3Italicize the selected text
Ctrl+KOpen insert a hyperlink dialog box
Ctrl+LOpen create table dialog box
Ctrl+NCreate a New workbook
Ctrl+OOpen an existing document
Ctrl+P or Ctrl+Shift+F12Open Print dialog box
Ctrl+QOpen formatting, chart, table etc. options
Ctrl+RFill value in the cell from left cell
Ctrl+SSave changes in a document
Ctrl+TOpen create table dialog box
Ctrl+U / Ctrl+4Apply or remove underline from selected cell
Ctrl+V / Shift+InsertPaste the copied content
Ctrl+Alt+VOpen paste special dialog box
Ctrl+WClose the currently open workbook
Ctrl+XCut selected text
Ctrl+YRedo a change / forward change
Ctrl+ZUndo a change / backward change
Ctrl+1Open the format cell setting
Ctrl+2Apply bold on selected cell
Ctrl+3Apply italic on selected cell
Ctrl+4Apply underline on selected cell
Ctrl+5Apply strikethrough on selected cell
Ctrl+6Show or Hide the selected object
Ctrl+8Toggle Outline symbols
Ctrl+9Hide Row
Ctrl+0Hide Column
Ctrl+F1Show or Hide the ribbon bar
Ctrl+F3Define Name
Ctrl+F4Close the only current sheet
Ctrl+F5Resize the window
Ctrl+F6Next workbook window
Ctrl+Shift+F6Previous workbook window
Ctrl+F7Move window
Ctrl+F8Resize window
Ctrl+F9Minimize the window
Ctrl+F10Maximize the window
Ctrl+F11Insert New Macro sheet
Ctrl+F12Open the Open window
Ctrl+:Insert current date of system
Ctrl+Shift+:Insert current time of system
Ctrl+'Fill the value in the cell from above cell
Ctrl+"""Copy the formula from above cell
Ctrl+Left ButtonMove to end row of sheet
Ctrl+Right ButtonMove to beginning row of sheet
Ctrl+Down ButtonMove to bottom column of sheet
Ctrl+Up ButtonMove to top column of sheet
F1Open help window
F2Activate editing mode in active cell
F3Paste Name
F4Duplicate the current sheet & open in new window
F5Open Go To dialog box
F6Highlight menu bar shortcuts
F7Spellcheck and Grammar check
F8Turn on extended selection mode
F9Recalculate all worksheet
F10 or AltHighlight menu bar shortcuts
F11Open new chart insert window
F12Open Save As window

Leave a Comment

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