Download - Exel Shortcut keys
-
8/14/2019 Exel Shortcut keys
1/24
Function keys in Microsoft Excel
Function Key SHIFT CTRL
F1 What's This?
F2 Edit the active cell Edit a cell comment
F3 Define a name
F4 Repeat the last action Close the window
F5 Go To Display the Find dialog box Restore the window size
F6 Move to the next pane Move to the previous pane
F7 Spelling command Move the window
F8 Extend a selection Add to the selection Resize the window
F9 Minimize the workbook
F10
F11 Create a chart Insert a new worksheet
F12 Save As command Save command Open command
Display Help or the
Office Assistant
Paste a name into aformula
Paste a function into aformula
Repeat the last Find (FindNext)
Move to the next workbookwindow
Calculate all sheets inall open workbooks
Calculate the activeworksheet
Make the menu baractive
Display a shortcut menu(right click)
Maximize or restore theworkbook window
Insert a Microsoft Excel 4.0macro sheet
-
8/14/2019 Exel Shortcut keys
2/24
ALT CTRL+SHIFT ALT+SHIFT
Insert a chart sheet
Save As command Save command
Exit
Print command
Insert a new
worksheet
Create names by usingrow and column labels
Move to the previousworkbook window
Display the Macrodialog box
Display Visual BasicEditor
-
8/14/2019 Exel Shortcut keys
3/24
Enter data by using shortcut keys
To Press
Complete a cell entry ENTER
Cancel a cell entry ESC
Repeat the last action F4 or CTRL+YStart a new line in the same cell ALT+ENTERDelete the character to the left of the insertion point, or delete BACKSPACE
Delete the character to the right of the insertion point, or delet DELETE
Delete text to the end of the line CTRL+DELETE
Move one character up, down, left, or right Arrow keys
Move to the beginning of the line HOME
Edit a cell comment SHIFT+F2Create names from row and column labels CTRL+SHIFT+F3Fill down CTRL+DFill to the right CTRL+RFill the selected cell range with the current entry CTRL+ENTERComplete a cell entry and move down in the selection ENTERComplete a cell entry and move up in the selection SHIFT+ENTER
Complete a cell entry and move to the right in the selectioTABComplete a cell entry and move to the left in the selectionSHIFT+TAB
Work in cells or the formula bar by using shortcut keys
To Press
Start a formula = (EQUAL SIGN)Cancel an entry in the cell or formula bar ESCEdit the active cell F2
BACKSPACE
Paste a name into a formula F3
Define a name CTRL+F3Calculate all sheets in all open workbooks F9Calculate the active worksheet SHIFT+F9Insert the AutoSum formula ALT+= (EQUAL SIGN)Enter the date CTRL+; (SEMICOLON)Enter the time CTRL+SHIFT+: (COLON)
Insert a hyperlink CTRL+KComplete a cell entry ENTER
CTRL+SHIFT+" (QUOTATION MARK)
Alternate between displaying cell values and displaying c CTRL+` (SINGLE LEFT QUOTATION MARK)
CTRL+' (APOSTROPHE)
Enter a formula as an array formula CTRL+SHIFT+ENTERDisplay the Formula Palette after you type a valid functio CTRL+A
CTRL+SHIFT+A
Display the AutoComplete list ALT+DOWN ARROW
Edit the active cell and then clear it, or delete thepreceding character in the active cell as you edit the cellcontents
Copy the value from the cell above the active cell intothe cell or the formula bar
Copy a formula from the cell above the active cell intothe cell or the formula bar
Insert the argument names and parentheses for afunction, after you type a valid function name in aformula
-
8/14/2019 Exel Shortcut keys
4/24
-
8/14/2019 Exel Shortcut keys
5/24
Format data by using shortcut keys
To
Display the Style command (Format menu)Display the Cells command (Format menu)
Apply the General number formatApply the Currency format with two decimal places (negative numbers appear in parentheses)Apply the Percentage format with no decimal placesApply the Exponential number format with two decimal placesApply the Date format with the day, month, and yearApply the Time format with the hour and minute, and indicate A.M. or P.M.Apply the Number format with two decimal places, 1000 separator, and for negative valuesApply the outline borderRemove all bordersApply or remove bold formattingApply or remove italic formattingApply or remove an underline
Apply or remove strikethrough formattingHide rowsUnhide rowsHide columnsUnhide columns
Edit data by using shortcut keys
To
Edit the active cellCancel an entry in the cell or formula bar
Paste a name into a formulaComplete a cell entryEnter a formula as an array formulaDisplay the Formula Palette after you type a valid function name in a formula
Insert, delete, and copy a selection by using shortcut keys
ToCopy the selectionPaste the selectionCut the selectionClear the contents of the selectionInsert blank cellsDelete the selectionUndo the last action
Edit the active cell and then clear it, or delete the preceding character in the active cell as you editthe cell contents
Insert the argument names and parentheses for a function, after you type a valid function name ina formula
-
8/14/2019 Exel Shortcut keys
6/24
Move within a selection by using shortcut keys
To
Move from left to right within the selection, or move down one cell if only one column is selected
Move from right to left within the selection, or move up one cell if only one column is selectedMove clockwise to the next corner of the selectionMove to the right between nonadjacent selectionsMove to the left between nonadjacent selections
Move from top to bottom within the selection (down), or in the direction that is selected on the Edit
tab (Tools menu, Options command)Move from bottom to top within the selection (up), or opposite to the direction that is selected onthe Edit tab (Tools menu, Options command)
-
8/14/2019 Exel Shortcut keys
7/24
Press
ALT+' (APOSTROPHE)CTRL+1
CTRL+SHIFT+~CTRL+SHIFT+$CTRL+SHIFT+%CTRL+SHIFT+^CTRL+SHIFT+#CTRL+SHIFT+@CTRL+SHIFT+!CTRL+SHIFT+&CTRL+SHIFT+_CTRL+BCTRL+ICTRL+U
CTRL+5CTRL+9CTRL+SHIFT+(CTRL+0 (ZERO)CTRL+SHIFT+)
Press
F2ESC
BACKSPACEF3ENTERCTRL+SHIFT+ENTERCTRL+A
CTRL+SHIFT+A
PressCTRL+CCTRL+VCTRL+XDELETECTRL+SHIFT+PLUS SIGNCTRL+ CTRL+Z
-
8/14/2019 Exel Shortcut keys
8/24
Press
ENTER
SHIFT+ENTER
TAB
SHIFT+TABCTRL+PERIODCTRL+ALT+RIGHT ARROWCTRL+ALT+LEFT ARROW
-
8/14/2019 Exel Shortcut keys
9/24
Select data, cells, chart items, or objects by using shortcut keys
Select cells, columns, rows, or objects in worksheets and workbooks by
To
Extend the selection by one cellExtend the selection to the last nonblank cell in the same column or row as the active cellExtend the selection to the beginning of the rowExtend the selection to the beginning of the worksheetExtend the selection to the last cell used on the worksheet (lower-right corner)Select the entire columnSelect the entire rowSelect the entire worksheetIf multiple cells are selected, select only the active cellExtend the selection down one screen
Extend the selection up one screenWith an object selected, select all objects on a sheetAlternate between hiding objects, displaying objects, and displaying placeholders for objectsShow or hide the Standard toolbarIn End mode, toTurn End mode on or offExtend the selection to the last nonblank cell in the same column or row as the active cellExtend the selection to the last cell used on the worksheet (lower-right corner)
With SCROLL LOCK on, toTurn SCROLL LOCK on or off
Scroll the screen up or down one rowScroll the screen left or right one columnExtend the selection to the cell in the upper-left corner of the windowExtend the selection to the cell in the lower-right corner of the window
Select cells with special characteristics by using shortcut keys
To
Select the current array, which is the array that the active cell belongs toSelect all cells with comments
Select only cells that are directly referred to by formulas in the selectionSelect all cells that are directly or indirectly referred to by formulas in the selection
Select the current region around the active cell (the current region is an area enclosed by blankrows and blank columns)
Extend the selection to the last cell in the current row; this keystroke is unavailable if youselected the Transition navigation keys check box on the Transition tab (Tools menu, Optionscommand)
Tip When you use the scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCKturned off, your selection moves the distance you scroll. If you want to keep the same selectionas you scroll, turn on SCROLL LOCK first.
Select the current region around the active cell (the current region is an area enclosed by blank
rows and blank columns)
Select cells whose contents are different from the comparison cell in each row (for each row, thecomparison cell is in the same column as the active cell)
Select cells whose contents are different from the comparison cell in each column (for eachcolumn, the comparison cell is in the same row as the active cell)
-
8/14/2019 Exel Shortcut keys
10/24
Select only cells with formulas that refer directly to the active cellSelect all cells with formulas that refer directly or indirectly to the active cellSelect only visible cells in the current selection
Select chart items by using shortcut keys
To
Select the previous group of itemsSelect the next group of itemsSelect the next item within the groupSelect the previous item within the group
-
8/14/2019 Exel Shortcut keys
11/24
using shortcut keys
Press
CTRL+SHIFT+* (ASTERISK)SHIFT+ arrow keyCTRL+SHIFT+ arrow keySHIFT+HOMECTRL+SHIFT+HOMECTRL+SHIFT+ENDCTRL+SPACEBARSHIFT+SPACEBARCTRL+ASHIFT+BACKSPACESHIFT+PAGE DOWN
SHIFT+PAGE UPCTRL+SHIFT+SPACEBARCTRL+6CTRL+7PressENDEND, SHIFT+ arrow keyEND, SHIFT+HOME
END, SHIFT+ENTERPressSCROLL LOCK
UP ARROW or DOWN ARROWLEFT ARROW or RIGHT ARROWSHIFT+HOMESHIFT+END
Press
CTRL+SHIFT+* (ASTERISK)CTRL+/CTRL+SHIFT+O (the letter O)
CTRL+\
CTRL+SHIFT+|CTRL+[CTRL+SHIFT+{
-
8/14/2019 Exel Shortcut keys
12/24
CTRL+]CTRL+SHIFT+}ALT+SEMICOLON
Press
DOWN ARROWUP ARROWRIGHT ARROWLEFT ARROW
-
8/14/2019 Exel Shortcut keys
13/24
Move and scroll on a worksheet or workbook by using
To
Move one cell in a given direction
Move to the edge of the current data regionMove between unlocked cells on a protected worksheetMove to the beginning of the rowMove to the beginning of the worksheet
Move down one screenMove up one screenMove one screen to the rightMove one screen to the leftMove to the next sheet in the workbook
Move to the previous sheet in the workbookMove to the next workbook or windowMove to the previous workbook or windowMove to the next paneMove to the previous paneScroll to display the active cell
In End mode, to
Turn End mode on or offMove by one block of data within a row or column
With SCROLL LOCK turned on, to
Turn SCROLL LOCK on or off
Move to the cell in the upper-left corner of the windowMove to the cell in the lower-right corner of the windowScroll one row up or downScroll one column left or right
Move to the last cell on the worksheet, which is the cell at theintersection of the right-most used column and the bottom-mostused row (in the lower-right corner); cell opposite the Home cell,which is typically A1
Move to the last cell on the worksheet, which is the cell at theintersection of the right-most used column and the bottom-mostused row (in the lower-right corner); cell opposite the Home cell,which is typically A1
Move to the last cell to the right in the current row that is notblank; unavailable if you have selected the Transition navigationkeys check box on the Transition tab (Tools menu, Optionscommand)
Tip When you use the scrolling keys (such as PAGE UP andPAGE DOWN) with SCROLL LOCK turned off, your selectionmoves the distance you scroll. If you want to preserve yourselection while you scroll through the worksheet, turn onSCROLL LOCK first.
-
8/14/2019 Exel Shortcut keys
14/24
hortcut keys
Press
Arrow key
CTRL+ arrow keyTABHOMECTRL+HOME
CTRL+ENDPAGE DOWNPAGE UPALT+PAGE DOWNALT+PAGE UPCTRL+PAGE DOWN
CTRL+PAGE UPCTRL+F6 or CTRL+TABCTRL+SHIFT+F6 or CTRL+SHIFT+TABF6SHIFT+F6CTRL+BACKSPACE
Press
ENDEND, arrow key
END, HOME
END, ENTER
Press
SCROLL LOCK
HOMEENDUP ARROW or DOWN ARROWLEFT ARROW or RIGHT ARROW
-
8/14/2019 Exel Shortcut keys
15/24
Work with databases
Work in a data form by using shortcut keys
To
Select a field or a command buttonMove to the same field in the next recordMove to the same field in the previous recordMove to the next field you can edit in the recordMove to the previous field you can edit in the recordMove to the first field in the next recordMove to the first field in the previous recordMove to the same field 10 records forwardMove to the same field 10 records backMove to the new recordMove to the first recordMove to the beginning or end of a fieldMove one character left or right within a fieldExtend a selection to the beginning of a fieldExtend a selection to the end of a fieldSelect the character to the leftSelect the character to the right
Work with the AutoFilter feature by using short
To
Display the AutoFilter list for the current columnClose the AutoFilter list for the current columnSelect the next item in the AutoFilter listSelect the previous item in the AutoFilter list
Select the first item (All) in the AutoFilter listSelect the last item in the AutoFilter listFilter the list by using the selected item in the AutoFilter
Work with the PivotTable Wizard by using shor
In Step 3 of the PivotTable Wizard, to
Select the next or previous field button in the listSelect the field button to the right or left in a multicolumMove the selected field into the Page areaMove the selected field into the Row areaMove the selected field into the Column area
Move the selected field into the Data areaDisplay the PivotTable Field dialog box
Work with page fields in a PivotTable by using
To
Select the previous item in the listSelect the next item in the listSelect the first visible item in the list
-
8/14/2019 Exel Shortcut keys
16/24
-
8/14/2019 Exel Shortcut keys
17/24
, lists, and PivotTables by using shortcut keys
Press
ALT+ key, where key is the underlined letter in the field or command nameDOWN ARROWUP ARROWTABSHIFT+TABENTERSHIFT+ENTERPAGE DOWNPAGE UPCTRL+PAGE DOWNCTRL+PAGE UPHOME or ENDLEFT ARROW or RIGHT ARROWSHIFT+HOMESHIFT+ENDSHIFT+LEFT ARROWSHIFT+RIGHT ARROW
cut keys
Press
Select the cell that contains the column label, and then press ALT+DOWN ARROWALT+UP ARROWDOWN ARROWUP ARROW
HOMEENDENTER
tcut keys
Press
UP ARROW or DOWN ARROWLEFT ARROW or RIGHT ARROWALT+PALT+RALT+C
ALT+DALT+L
shortcut keys
Press
UP ARROWDOWN ARROWHOME
-
8/14/2019 Exel Shortcut keys
18/24
ENDENTER
shortcut keys
Press
ALT+SHIFT+RIGHT ARROWALT+SHIFT+LEFT ARROW
-
8/14/2019 Exel Shortcut keys
19/24
Keys for windows and
In a window, to
Switch to the next programSwitch to the previous program
Show the Windows Start menuClose the active workbook windowRestore the active workbook windowSwitch to the next workbook windowSwitch to the previous workbook windowCarry out the Move command (workbook icon menu, menu bar)Carry out the Size command (workbook icon menu, menu bar)Minimize the workbook window to an iconMaximize or restore the workbook windowSelect a folder in the Open or Save As dialog box (File menu)Choose a toolbar button in the Open or Save As dialog box (File menu)Update the files visible in the Open or Save As dialog box (File menu)
In a dialog box, to
Switch to the next tab in a dialog boxSwitch to the previous tab in a dialog boxMove to the next option or option groupMove to the previous option or option group
Move to an option in a drop-down list box
Select an option, or select or clear a check boxOpen the selected drop-down list boxClose the selected drop-down list box
Cancel the command and close the dialog box
In a text box, to
Move to the beginning of the entryMove to the end of the entry
Move one character to the left or rightMove one word to the left or rightSelect from the insertion point to the beginning of the entrySelect from the insertion point to the end of the entrySelect or unselect one character to the leftSelect or unselect one character to the rightSelect or unselect one word to the leftSelect or unselect one word to the right
Move between options in the active drop-down list box or between someoptions in a group of options
Perform the action assigned to the active button (the button with the dottedoutline), or select or clear the active check box
Perform the action assigned to the default command button in the dialogbox (the button with the bold outline often the OK button)
-
8/14/2019 Exel Shortcut keys
20/24
dialog boxes
Press
ALT+TABALT+SHIFT+TAB
CTRL+ESCCTRL+WCTRL+F5CTRL+F6CTRL+SHIFT+F6CTRL+F7CTRL+F8CTRL+F9CTRL+F10ALT+0 to select the folder list; arrow keys to select a folderALT+ number (1 is the leftmost button, 2 is the next, and so on)F5
Press
CTRL+TAB or CTRL+PAGE DOWNCTRL+SHIFT+TAB or CTRL+PAGE UPTABSHIFT+TAB
Arrow keys
SPACEBAR
ALT+DOWN ARROWESC
ENTERESC
Press
HOMEEND
LEFT ARROW or RIGHT ARROWCTRL+LEFT ARROW or CTRL+RIGHT ARROWSHIFT+HOMESHIFT+ENDSHIFT+LEFT ARROWSHIFT+RIGHT ARROWCTRL+SHIFT+LEFT ARROWCTRL+SHIFT+RIGHT ARROW
Letter key for the first letter in the option name you want (when adrop-down list box is selected)
ALT+ letter, where letter is the key for the underlined letter in theoption name
-
8/14/2019 Exel Shortcut keys
21/24
Print and preview a document by us
To
Display the Print command (File menu)
Work in print preview
To
Move around the page when zoomed inMove by one page when zoomed outMove to the first page when zoomed outMove to the last page when zoomed out
Outline data by using short
To
Ungroup rows or columnsGroup rows or columnsDisplay or hide outline symbolsHide selected rowsUnhide selected rowsHide selected columnsUnhide selected columns
Keys for menus
To
Show a shortcut menuMake the menu bar activeShow the program icon menu (on the program title bar)
Select the next or previous command on the menu or submenu
Select the first or last command on the menu or submenuClose the visible menu and submenu at the same time
Select the menu to the left or right, or, with a submenu visible, switchbetween the main menu and the submenu
Close the visible menu, or, with a submenu visible, close the submenuonly
Tip You can select any menu command on the menu bar or on a visibletoolbar with the keyboard. Press ALT to select the menu bar. (To thenselect a toolbar, press CTRL+TAB; repeat until the toolbar you want isselected.) Press the letter that is underlined in the menu name thatcontains the command you want. In the menu that appears, press theletter underlined in the command name that you want.
-
8/14/2019 Exel Shortcut keys
22/24
Keys for toolbars
On a toolbar, to
Make the menu bar activeSelect the next or previous toolbarSelect the next or previous button or menu on the toolbar
Open the selected menuPerform the action assigned to the selected buttonEnter text in the selected text box
Keys for using the Office A
To
Make the Office Assistant the active balloon
Select a Help topic from the topics displayed by the Office AssistantSee more help topicsSee previous help topicsClose an Office Assistant messageGet Help from the Office AssistantDisplay the next tipDisplay the previous tipClose tips
Show or hide the Office Assistant in a wizard
Select an option from a drop-down list box or from a drop-down menuon a button
-
8/14/2019 Exel Shortcut keys
23/24
ing shortcut keys
Press
CTRL+P
Press
Arrow keysPAGE UP or PAGE DOWNCTRL+UP ARROW or CTRL+LEFT ARROWCTRL+DOWN ARROW or CTRL+RIGHT ARROW
cut keys
Press
ALT+SHIFT+LEFT ARROWALT+SHIFT+RIGHT ARROWCTRL+8CTRL+9CTRL+SHIFT+(CTRL+0 (ZERO)CTRL+SHIFT+)
Press
SHIFT+F10F10 or ALTALT+SPACEBAR
LEFT ARROW or RIGHT ARROWHOME or ENDALT
ESC
DOWN ARROW or UP ARROW (with the menu orsubmenu displayed)
-
8/14/2019 Exel Shortcut keys
24/24
Press
F10 or ALTCTRL+TAB or CTRL+SHIFT+TABTAB or SHIFT+TAB (when a toolbar is active)
ENTERENTERENTER
ssistant
Press
ALT+F6; repeat until the balloon is active
ALT+DOWN ARROWALT+UP ARROWESCF1ALT+NALT+BESC
Arrow keys to move through options in the list ormenu; ENTER to select the option you want (whena drop-down list box is selected)
ALT+topic number (where 1 is the first topic, 2 isthe second, and so on)
TAB to select the Office Assistant button;SPACEBAR to show or hide the Assistant