All Shortcuts of Microsoft Excel (256 Shortcut Keys)

excel

Here Are Very Useful Shortcut Keys Of Microsoft Excel, That Will Help You To Speed Up Your Work And Short The Time Consumption Of Work, So Check Out Below:-

Select cells, columns, rows, or objects in worksheets and workbooks by using shortcut keys :-

CTRL+SHIFT+* (ASTERISK)Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns)
SHIFT+ arrow keyExtend the selection by one cell
CTRL+SHIFT+ arrow keyExtend the selection to the last nonblank cell in the same column or row as the active cell
SHIFT+HOMEExtend the selection to the beginning of the row
CTRL+SHIFT+HOMEExtend the selection to the beginning of the worksheet
CTRL+SHIFT+ENDExtend the selection to the last cell used on the worksheet (lower-right corner)
CTRL+SPACEBARSelect the entire column
SHIFT+SPACEBARSelect the entire row
CTRL+ASelect the entire worksheet
SHIFT+BACKSPACEIf multiple cells are selected, select only the active cell
SHIFT+PAGE DOWNExtend the selection down one screen
SHIFT+PAGE UPExtend the selection up one screen
CTRL+SHIFT+SPACEBARWith an object selected, select all objects on a sheet
CTRL+6Alternate between hiding objects, displaying objects, and displaying placeholders for objects
CTRL+7Show or hide the Standard toolbar
PressIn End mode, to
ENDTurn End mode on or off
END, SHIFT+ arrow keyExtend the selection to the last nonblank cell in the same column or row as the active cell
END, SHIFT+HOMEExtend the selection to the last cell used on the worksheet (lower-right corner)
END, SHIFT+ENTERExtend the selection to the last cell in the current row; this keystroke is unavailable if you selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command)
PressWith SCROLL LOCK on, to
SCROLL LOCKTurn SCROLL LOCK on or off
UP ARROW or DOWN ARROWScroll the screen up or down one row
LEFT ARROW or RIGHT ARROWScroll the screen left or right one column
SHIFT+HOMEExtend the selection to the cell in the upper-left corner of the window
SHIFT+ENDExtend the selection to the cell in the lower-right corner of the window
Tip   When you use the scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. If you want to keep the same selection as you scroll, turn on SCROLL LOCK first.

Select cells with special characteristics by using shortcut keys :-

CTRL+SHIFT+* (ASTERISK)Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns)
CTRL+/Select the current array, which is the array that the active cell belongs to
CTRL+SHIFT+O (the letter O)Select all cells with comments
CTRL+\Select cells whose contents are different from the comparison cell in each row (for each row, the comparison cell is in the same column as the active cell)
CTRL+SHIFT+|Select cells whose contents are different from the comparison cell in each column (for each column, the comparison cell is in the same row as the active cell)
CTRL+[Select only cells that are directly referred to by formulas in the selection
CTRL+SHIFT+{Select all cells that are directly or indirectly referred to by formulas in the selection
CTRL+]Select only cells with formulas that refer directly to the active cell
CTRL+SHIFT+}Select all cells with formulas that refer directly or indirectly to the active cell
ALT+SEMICOLONSelect only visible cells in the current selection

Select chart items by using shortcut keys :-

DOWN ARROWSelect the previous group of items
UP ARROWSelect the next group of items
RIGHT ARROWSelect the next item within the group
LEFT ARROWSelect the previous item within the group

Format data by using shortcut keys :-

ALT+’ (APOSTROPHE)Display the Style command (Format menu)
CTRL+1Display the Cells command (Format menu)
CTRL+SHIFT+~Apply the General number format
CTRL+SHIFT+$Apply the Currency format with two decimal places (negative numbers appear in parentheses)
CTRL+SHIFT+%Apply the Percentage format with no decimal places
CTRL+SHIFT+^Apply the Exponential number format with two decimal places
CTRL+SHIFT+#Apply the Date format with the day, month, and year
CTRL+SHIFT+@Apply the Time format with the hour and minute, and indicate A.M. or P.M.
CTRL+SHIFT+!Apply the Number format with two decimal places, 1000 separator, and – for negative values
CTRL+SHIFT+&Apply the outline border
CTRL+SHIFT+_Remove all borders
CTRL+BApply or remove bold formatting
CTRL+IApply or remove italic formatting
CTRL+UApply or remove an underline
CTRL+5Apply or remove strikethrough formatting
CTRL+9Hide rows
CTRL+SHIFT+(Unhide rows
CTRL+0 (ZERO)Hide columns
CTRL+SHIFT+) Unhide columns

Edit data by using shortcut keys :-

F2Edit the active cell
ESCCancel an entry in the cell or formula bar
BACKSPACEEdit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents
F3Paste a name into a formula
ENTERComplete a cell entry
CTRL+SHIFT+ENTEREnter a formula as an array formula
CTRL+ADisplay the Formula Palette after you type a valid function name in a formula
CTRL+SHIFT+AInsert the argument names and parentheses for a function, after you type a valid function name in a formula

Insert, delete, and copy a selection by using shortcut keys :-

CTRL+CCopy the selection
CTRL+VPaste the selection
CTRL+XCut the selection
DELETEClear the contents of the selection
CTRL+SHIFT+PLUS SIGNInsert blank cells
CTRL+ –Delete the selection
CTRL+ZUndo the last action

Move within a selection by using shortcut keys :-

ENTER Move from top to bottom within the selection (down), or in the direction that is selected on the Edit tab (Tools menu, Options command)
SHIFT+ENTER Move from bottom to top within the selection (up), or opposite to the direction that is selected on the Edit tab (Tools menu, Options command)
TABMove from left to right within the selection, or move down one cell if only one column is selected
SHIFT+TABMove from right to left within the selection, or move up one cell if only one column is selected
CTRL+PERIODMove clockwise to the next corner of the selection
CTRL+ALT+RIGHT ARROWMove to the right between nonadjacent selections
CTRL+ALT+LEFT ARROWMove to the left between nonadjacent selections

Work in cells or the formula bar by using shortcut keys :-

= (EQUAL SIGN)Start a formula
ESCCancel an entry in the cell or formula bar
F2Edit the active cell
BACKSPACEEdit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents
F3Paste a name into a formula
CTRL+F3Define a name
F9Calculate all sheets in all open workbooks
SHIFT+F9Calculate the active worksheet
ALT+= (EQUAL SIGN)Insert the AutoSum formula
CTRL+; (SEMICOLON)Enter the date
CTRL+SHIFT+: (COLON)Enter the time
CTRL+KInsert a hyperlink
ENTERComplete a cell entry
CTRL+SHIFT+” (QUOTATION MARK)Copy the value from the cell above the active cell into the cell or the formula bar
CTRL+` (SINGLE LEFT QUOTATION MARK)Alternate between displaying cell values and displaying cell formulas
CTRL+’ (APOSTROPHE)Copy a formula from the cell above the active cell into the cell or the formula bar
CTRL+SHIFT+ENTEREnter a formula as an array formula
CTRL+ADisplay the Formula Palette after you type a valid function name in a formula
CTRL+SHIFT+AInsert the argument names and parentheses for a function, after you type a valid function name in a formula
ALT+DOWN ARROWDisplay the AutoComplete list

Enter data by using shortcut keys :-

ENTERComplete a cell entry
ESCCancel a cell entry
F4 or CTRL+YRepeat the last action
ALT+ENTERStart a new line in the same cell
BACKSPACEDelete the character to the left of the insertion point, or delete the selection
DELETEDelete the character to the right of the insertion point, or delete the selection
CTRL+DELETEDelete text to the end of the line
Arrow keysMove one character up, down, left, or right
HOMEMove to the beginning of the line
SHIFT+F2Edit a cell comment
CTRL+SHIFT+F3Create names from row and column labels
CTRL+DFill down
CTRL+RFill to the right
CTRL+ENTERFill the selected cell range with the current entry
ENTERComplete a cell entry and move down in the selection
SHIFT+ENTERComplete a cell entry and move up in the selection
TABComplete a cell entry and move to the right in the selection
SHIFT+TABComplete a cell entry and move to the left in the selection

Move and scroll on a worksheet or workbook by using shortcut keys :-

Arrow keyMove one cell in a given direction
CTRL+ arrow keyMove to the edge of the current data region
TABMove between unlocked cells on a protected worksheet
HOMEMove to the beginning of the row
CTRL+HOMEMove to the beginning of the worksheet
CTRL+ENDMove to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1
PAGE DOWNMove down one screen
PAGE UPMove up one screen
ALT+PAGE DOWNMove one screen to the right
ALT+PAGE UPMove one screen to the left
CTRL+PAGE DOWNMove to the next sheet in the workbook
CTRL+PAGE UPMove to the previous sheet in the workbook
CTRL+F6 or CTRL+TABMove to the next workbook or window
CTRL+SHIFT+F6 or CTRL+SHIFT+TABMove to the previous workbook or window
F6Move to the next pane
SHIFT+F6Move to the previous pane
CTRL+BACKSPACEScroll to display the active cell

In End mode :-

ENDTurn End mode on or off
END, arrow keyMove by one block of data within a row or column
END, HOMEMove to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1
END, ENTERMove to the last cell to the right in the current row that is not blank; unavailable if you have selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command)

With SCROLL LOCK turned on :-

SCROLL LOCKTurn SCROLL LOCK on or off
HOMEMove to the cell in the upper-left corner of the window
ENDMove to the cell in the lower-right corner of the window
UP ARROW or DOWN ARROWScroll one row up or down
LEFT ARROW or RIGHT ARROWScroll one column left or right
Tip   When you use the scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. If you want to preserve your selection while you scroll through the worksheet, turn on SCROLL LOCK first.

Work with databases, lists, and PivotTables by using shortcut keys :-

ALT+ key, where key is the underlined letter in the field or command nameSelect a field or a command button
DOWN ARROWMove to the same field in the next record
UP ARROWMove to the same field in the previous record
TABMove to the next field you can edit in the record
SHIFT+TAB Move to the previous field you can edit in the record
ENTERMove to the first field in the next record
SHIFT+ENTERMove to the first field in the previous record
PAGE DOWNMove to the same field 10 records forward
PAGE UPMove to the same field 10 records back
CTRL+PAGE DOWNMove to the new record
CTRL+PAGE UPMove to the first record
HOME or ENDMove to the beginning or end of a field
LEFT ARROW or RIGHT ARROWMove one character left or right within a field
SHIFT+HOMEExtend a selection to the beginning of a field
SHIFT+ENDExtend a selection to the end of a field
SHIFT+LEFT ARROWSelect the character to the left
SHIFT+RIGHT ARROWSelect the character to the right

Work with the AutoFilter feature by using shortcut keys :-

Select the cell that contains the column label, and then press ALT+DOWN ARROWDisplay the AutoFilter list for the current column
ALT+UP ARROWClose the AutoFilter list for the current column
DOWN ARROWSelect the next item in the AutoFilter list
UP ARROWSelect the previous item in the AutoFilter list
HOMESelect the first item (All) in the AutoFilter list
ENDSelect the last item in the AutoFilter list
ENTERFilter the list by using the selected item in the AutoFilter list

Keys for windows and dialog boxes (In a window) :-

ALT+TABSwitch to the next program
ALT+SHIFT+TABSwitch to the previous program
CTRL+ESCShow the Windows Start menu
CTRL+WClose the active workbook window
CTRL+F5Restore the active workbook window
CTRL+F6Switch to the next workbook window
CTRL+SHIFT+F6Switch to the previous workbook window
CTRL+F7Carry out the Move command (workbook icon menu, menu bar)
CTRL+F8Carry out the Size command (workbook icon menu, menu bar)
CTRL+F9Minimize the workbook window to an icon
CTRL+F10Maximize or restore the workbook window
ALT+0 to select the folder list; arrow keys to select a folderSelect a folder in the Open or Save As dialog box (File menu)
ALT+ number (1 is the leftmost button, 2 is the next, and so on)Choose a toolbar button in the Open or Save As dialog box (File menu)
F5Update the files visible in the Open or Save As dialog box (File menu)

Keys for windows and dialog boxes (In a dialog box) :-

CTRL+TAB or CTRL+PAGE DOWNSwitch to the next tab in a dialog box
CTRL+SHIFT+TAB or CTRL+PAGE UPSwitch to the previous tab in a dialog box
TABMove to the next option or option group
SHIFT+TABMove to the previous option or option group
Arrow keysMove between options in the active drop-down list box or between some options in a group of options
SPACEBARPerform the action assigned to the active button (the button with the dotted outline), or select or clear the active check box
Letter key for the first letter in the option name you want (when a drop-down list box is selected)Move to an option in a drop-down list box
ALT+ letter, where letter is the key for the underlined letter in the option nameSelect an option, or select or clear a check box
ALT+DOWN ARROWOpen the selected drop-down list box
ESCClose the selected drop-down list box
ENTERPerform the action assigned to the default command button in the dialog box (the button with the bold outline ¾ often the OK button)
ESCCancel the command and close the dialog box

Keys for windows and dialog boxes (In a text box) :-

HOMEMove to the beginning of the entry
ENDMove to the end of the entry
LEFT ARROW or RIGHT ARROWMove one character to the left or right
CTRL+LEFT ARROW or CTRL+RIGHT ARROWMove one word to the left or right
SHIFT+HOMESelect from the insertion point to the beginning of the entry
SHIFT+ENDSelect from the insertion point to the end of the entry
SHIFT+LEFT ARROWSelect or unselect one character to the left
SHIFT+RIGHT ARROWSelect or unselect one character to the right
CTRL+SHIFT+LEFT ARROWSelect or unselect one word to the left
CTRL+SHIFT+RIGHT ARROWSelect or unselect one word to the right

Print and preview a document by using shortcut keys :-

CTRL+PDisplay the Print command (File menu)

Work in Print Preview :-

Arrow keysMove around the page when zoomed in
PAGE UP or PAGE DOWNMove by one page when zoomed out
CTRL+UP ARROW or CTRL+LEFT ARROWMove to the first page when zoomed out
CTRL+DOWN ARROW or CTRL+RIGHT ARROWMove to the last page when zoomed out

Outline data by using shortcut keys in Print Preview  :-

ALT+SHIFT+LEFT ARROWUngroup rows or columns
ALT+SHIFT+RIGHT ARROWGroup rows or columns
CTRL+8Display or hide outline symbols
CTRL+9Hide selected rows
CTRL+SHIFT+(Unhide selected rows
CTRL+0 (ZERO)Hide selected columns
CTRL+SHIFT+)Unhide selected columns

Keys for Menus :-

SHIFT+F10Show a shortcut menu
F10 or ALTMake the menu bar active
ALT+SPACEBARShow the program icon menu (on the program title bar)
DOWN ARROW or UP ARROW (with the menu or submenu displayed)Select the next or previous command on the menu or submenu
LEFT ARROW or RIGHT ARROWSelect the menu to the left or right, or, with a submenu visible, switch between the main menu and the submenu
HOME or ENDSelect the first or last command on the menu or submenu
ALTClose the visible menu and submenu at the same time
ESCClose the visible menu, or, with a submenu visible, close the submenu only
Tip   You can select any menu command on the menu bar or on a visible toolbar with the keyboard. Press ALT to select the menu bar. (To then select a toolbar, press CTRL+TAB; repeat until the toolbar you want is selected.) Press the letter that is underlined in the menu name that contains the command you want. In the menu that appears, press the letter underlined in the command name that you want.

Keys for Toolbars :-

F10 or ALTMake the menu bar active
CTRL+TAB or CTRL+SHIFT+TABSelect the next or previous toolbar
TAB or SHIFT+TAB (when a toolbar is active)Select the next or previous button or menu on the toolbar
ENTEROpen the selected menu
ENTERPerform the action assigned to the selected button
ENTEREnter text in the selected text box
Arrow keys to move through options in the list or menu; ENTER to select the option you want (when a drop-down list box is selected)Select an option from a drop-down list box or from a drop-down menu on a button

Keys for using the Office Assistant :-

ALT+F6; repeat until the balloon is activeMake the Office Assistant the active balloon
ALT+topic number (where 1 is the first topic, 2 is the second, and so on)Select a Help topic from the topics displayed by the Office Assistant
ALT+DOWN ARROWSee more help topics
ALT+UP ARROWSee previous help topics
ESCClose an Office Assistant message
F1Get Help from the Office Assistant
ALT+NDisplay the next tip
ALT+BDisplay the previous tip
ESCClose tips
TAB to select the Office Assistant button; SPACEBAR to show or hide the AssistantShow or hide the Office Assistant in a wizard

Function keys :-

F1Display Help or the Office Assistant
F2Edit the active cell
F3Paste a name into a formula
F4Repeat the last action
F5Go To
F6Move to the next pane
F7Spelling command
F8Extend a selection
F9Calculate all sheets in all open workbooks
F10Make the menu bar active
F11Create a chart
F12Save As command

Leave a Reply

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

*