MS-Excel Shortcut Keys

MS-Excel Shortcut Keys

In this topic we will show you most useful MS-Excel Shortcut Keys, for example Ctrl + Drag, Shift + Drag, Shift + Drag and more Shortcut Keys we will consider in this topic.

 MS-Excel Shortcut Keys
ShortcutDescription
Ctrl + DragDrag and copy or Drag to duplicate worksheet
Ctrl + Shift + DragDrag and insert copy
Shift + DragDrag and insert
Alt + DragDrag to worksheet
DragDrag and cut
 
MS-Excel Shortcut Keys
ShortcutDescription
Ctrl + DFill down from cell above
Ctrl + EFlash fill
Ctrl + KAdd hyperlink
Ctrl + Shift + “Copy value from cell above
 
Extend Selection
ShortcutDescription
Ctrl + Shift + Down ArrowExtend the selection to the last cell down
Ctrl + Shift + Left ArrowExtend the selection to the last cell left
Ctrl + Shift + Right ArrowExtend the selection to the last cell right
Ctrl + Shift + Up ArrowExtend the selection to the last cell up
Shift + Down ArrowExtend selection by one cell down
Shift + Left ArrowExtend selection by one cell left
Shift + Right ArrowExtend selection by one cell right
Shift + Up ArrowExtend selection by one cell up
Alt + Shift + Page DownExtend selection right one screen
Alt + Shift + Page UpExtend selection left one screen
 
File
ShortcutDescription
Ctrl + F4Close current workbook
Ctrl + PPrint file
Alt + F4Close Excel
 
Formatting
ShortcutDescription
Ctrl + 5Apply or remove strikethrough formatting
Ctrl + BApply or remove bold formatting
Ctrl + IApply or remove italic formatting
Ctrl + UApply or remove underscoring
Ctrl + Shift + FDisplay Format Cells with Font tab selected
Alt + H,5Remove indent
Alt + H,6Indent
Alt + H,A,CAlign center
Alt + H,FGIncrease font size one step
Alt + H,FKDecrease font size one step
Alt + H,A,LAlign left
Alt + H,A,RAlign right
 
General
ShortcutDescription
Ctrl + FDisplay find and replace
Ctrl + HDisplay find and replace, replace selected
Ctrl + VPaste content from clipboard
Ctrl + XCut selected cells
Ctrl + YRedo last action
Ctrl + Shift + F4Find previous match
Ctrl + Alt + VDisplay the Paste Special dialog box
Shift + F4Find next match
Alt + F,TOpen options
 
Grid Operations
ShortcutDescription
Ctrl + 8Hide or show outline symbols
Ctrl + Alt + +Zoom in
Ctrl + Alt + -Zoom out
Alt + Shift + Right ArrowGroup rows or columns
DeleteDelete contents of selected cells
 
Navigation
ShortcutDescription
Ctrl + Left ArrowMove to left edge of data region
Ctrl + Right ArrowMove to right edge of data region
Left ArrowMove one cell left
Right ArrowMove one cell right
EndTurn end mode on
Ribbon
ShortcutDescription
F1Get help on selected control or Open help
Ctrl + F1Expand or collapse ribbon
AltActivate access keys
SpacebarActivate or open selected control
 
Selection
ShortcutDescription
Ctrl + ClickAdd non-adjacent cells to selection
Ctrl + Alt + Left ArrowMove left between non-adjacent selections
Ctrl + Alt + Right ArrowMove right between non-adjacent selections
Shift + ClickAdd adjacent cells to selection
 
Tables and Filters
ShortcutDescription
Ctrl + TInsert table
Ctrl + Shift + LToggle Autofilter
Ctrl + Shift + TToggle table total row
Alt + CClear slicer filter
Alt + Down ArrowActivate filter
 
Selecting Cells, Rows, and Column
ShortcutDescription
F8Toggle Extend mode on and off
Shift + BackspaceReduce the selection to the active cell
Shift + HomeExtend the selection to the first cell in the row
Shift + Page UpExtend the selection upward by one screen
Shift + Page DownExtend the selection downward by one screen
Shift + F8Toggle add mode on and off
Ctrl + Shift + HomeExtend the selection to the first cell used on the worksheet
Ctrl + Shift + EndExtend the selection to the last cell used on the worksheet
Ctrl + Shift + SpacebarSelect all the objects on the current worksheet while retaining the current selection
Ctrl + SpacebarExtend the selection in the direction of the arrow key
Ctrl + ASelect all cells on the current worksheet
Shift + SpacebarSelect the current columns
 
Applying Border
ShortcutDescription
Ctrl + Shift + &Apply an outline border
Ctrl + Shift + _Remove the outline border
Alt + BToggle the bottom border on the selected cells
Alt + DToggle the downward diagonal border on the selected cells
Alt + HToggle the horizontal border on the selected cells
Alt + LToggle the left border on the selected cells
Alt + RToggle the right border on the selected cells
Alt + TToggle the top border on the selected cell
Alt + UToggle the upward diagonal border on the selected cells
Alt + VToggle the vertical border on the selected cells
 
Creating and Navigating
ShortcutDescription
F11, Alt + F1Create a chart from the selected range
 
Entering and Editing Data
ShortcutDescription
F2Switch the active cell into Edit mode
F3Pastes a defined name into a formula
F4Repeats the last command or action, if possible
F7Displays the Spelling dialog box to checkspelling in the active worksheet or selected range
F8Toggle Extend mode on and off
F10Minimizes a workbook window to an icon
F12Displays the Save As dialog box
Ctrl + F3Display the Define Name dialog box
Ctrl + F5Restores the window size of the selected workbook window
Ctrl + F9Minimize the active workbook window
Ctrl + F10Restore or maximize the selected minimized workbook window
Ctrl + 0Hides the selected columns
Ctrl + 9Hides the selected rows
Ctrl + ASelects the current region
Ctrl + CDisplays the Microsoft Office Clipboard
Ctrl+ GDisplay the Go To dialog box
Ctrl + ODisplays the Open dialog box to open or find a file
Ctrl + RDisplays the Print dialog box
Ctrl + SSaves the active file with its current file name and location
Ctrl + ZRepeats the last command or action, if possible
Ctrl + BackspaceScroll the workbook to display the active cell
Ctrl + SpacebarSelect the current worksheet
Ctrl + HomeMove to the last used cell in the worksheet
Ctrl + EndMove to the last used cell in the worksheet
Ctrl + EnterFill the selected range with the entry
Ctrl + DeleteDelete from the insertion point to the end of the cell's contents.
Ctrl + Down ArrowDisplay the AutoComplete drop-down list
Ctrl + _Removes the outline border from the selected cells
Ctrl + ;Enters the current date
Ctrl + :Enters the current time
Ctrl + Shift + F3Display the Create Names dialog box
Ctrl + Shift + OSelects all cells that contain comments
Ctrl + Shift + ZUndo the most recent AutoCorrect
Ctrl + Shift + :Enter the time in the active cell
Shift + F2Insert a new comment or edit the existing comment
Shift + F8Toggle add mode on and off
Shift + F10Displays the shortcut menu for a selected item
Shift + F11Inserts a new worksheet
Shift + EnterEnter the entry in the cell and select the next cell in the opposite direction
Shift + TabEnter the entry in the cell and select the next cell to the left.
Shift + SpacebarSelect the current row
Alt + F8Displays the Macro dialog box to run, edit, or delete a macro
Alt + EnterBegin a new line within the active cell
Alt + Page UpMove to the left by one screen
Alt + Shift + F1Inserts a new worksheet
EnterEnter the entry in the cell and select the next cell
EscCancel editing in the active cell
TabEnter the entry in the cell and select the next cell to the right
BackspaceDelete from the insertion point to the end of the cell's contents
HomeMove to the first cell in the active row
Page DownMove down the screen
Page UpMove up the screen
 
Formatting Cells
ShortcutDescription
Ctrl + 1Display the Format Cells dialog box
Ctrl + 5Toggle strikethrough
Ctrl + Shift + ~Apply the General format
Ctrl + Shift + $Apply the two-decimal-place Currency format
Ctrl + Shift + %Apply the Percentage format ( no decimal places)
Ctrl + Shift + ^Apply the Exponential format with two decimal places
Ctrl + Shift + #Apply the DD-MM-YY date format
Ctrl + Shift + @Apply the HH:MM AM/PM time format
Ctrl + Shift + !Apply the two-decimal-place number format with the thousands separator
Alt + 'Display the Style dialog box
 
Hiding and Unhiding Rows and Columns
ShortcutDescription
Ctrl + 0Hide all selected columns
Ctrl + 9Hide all selected rows
Ctrl + Shift + {Unhide hidden rows in the selection
Ctrl + Shift + }Unhide hidden columns in the selection
 
Inserting and Deleting Cells
ShortcutDescription
Ctrl + -Delete the selected cells
Ctrl + Shift + +Insert cells
 
Minimizing and Navigating
ShortcutDescription
Ctrl + F9Minimize the active workbook window
Page DownMove down one screen
Alt + Page DownMove to the right by one screen
Alt + Page UpMove to the left by one screen
Shift + F11, Alt + Shift + F1Insert a new worksheet in the active workbook
Ctrl + Shift + Page DownSelect the current worksheet and the next worksheet
Ctrl + Shift + TabSelect the previous minimized workbook window
Ctrl + EndMove to the first cell in the worksheet
Ctrl + HomeMove to the last used cell in the worksheet
Ctrl + BackspaceScroll the workbook to display the active cell
Ctrl + TabSelect the next minimized workbook window
Ctrl + Page UpMove to the next worksheet
Ctrl + NCreate a new default workbook
Ctrl + GDisplay the Go To dialog box
Ctrl + F10Restore or maximize the selected minimized workbook window
Page UpMove up one screen
 
Recalculating Worksheets
ShortcutDescription
F9Recalculating all the worksheets in all the open workbooks
Ctrl + Alt + F9Recalculating all calculations in all the worksheets in all the open workbooks
Ctrl + Alt + Shift + F9Recheck all formulas, then recalculate all calculation in all the worksheets



Selecting Cells That Match
ShortcutDescription
Ctrl + /Select the array that the active cell is in
Ctrl + Shift + 0Select all cells that have comments attached
Ctrl + Shift + |Select non-matching cells in the active column
Ctrl + Shift + *Select the data region
Ctrl + Shift + }Select cells that contain formulas directly or indirectly referencing the active cell
Ctrl + Shift + {Select cells directly or indirectly referenced by formulas in the active cell
Ctrl + ]Select cells that contain formulas directly referencing the active cell
Ctrl + [Select cells directly referenced by formulas in the active cell.
Ctrl + \Select non-matching cells in the active row
Alt + ;Select only the visible cells in the current selection
 
Working in Data Forms
ShortcutDescription
Ctrl + Page DownInsert a new, blank record in the database
Shift + EnterMove to the next record, first field
Down ArrowMove to the next record, same field
Up ArrowMove to the previous record, same field
Page DownMove ten records backward, same field
Page UpMove ten records backward, same field
EnterMove to the next record, first field
 
Working in PivotTables
ShortcutDescription
Ctrl + Shift + *Select the entire Pivot Tables
Alt + Shift + Left ArrowGroup the select items
 
Working in Print Preview
ShortcutDescription
Ctrl + Up ArrowDisplay the first page of the print area
Ctrl + Down ArrowDisplay the last page of the print area
Page UpDisplay the previous page
Page DownDisplay the next page
 
Working with Formulas
ShortcutDescription
F3Displays the Paste Name dialog box
Ctrl + ADisplay the Function Arguments dialog box
Ctrl + 'Copy the formula from the cell above the active cell
Ctrl + Shift + AEnter the argument names in the Formula bar
Ctrl + Shift + EnterEnter the formula as an array formula
Ctrl + Shift + \Copy the value of the cell above the active cell
Shift + F3Display the Insert Function dialog box
Alt + =Insert an AutoSum formula in the active cell
EnterEnter the formula in the cell
=Start creating a formula

Post a comment

0 Comments