shortcut keys for word - excel
Post on 10-Apr-2018
276 Views
Preview:
TRANSCRIPT
-
8/8/2019 Shortcut Keys for Word - Excel
1/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Alt Shift + M MailMergeToPrinter
Sends the results of the mail merge toprinter
Alt + _ OutlineCollapse Collapses an Outline in Outline View by one
level
Alt + + OutlineExpand Expands an Outline in Outline View by one
level
Alt + click Or(Alt + drag to
select several)
TableSelectColumn Selects the current column in a table
Alt + Ctrl + 1 ApplyHeading1 Applies Heading 1 style to the selected text
Alt + Ctrl + 2 ApplyHeading2 Applies Heading 2 style to the selected text
Alt + Ctrl + 3 ApplyHeading3 Applies Heading 3 style to the selected text
Alt + Ctrl + D InsertEndnoteNow Inserts an endnote reference at the insertion
point without displaying the dialog
-
8/8/2019 Shortcut Keys for Word - Excel
2/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Alt + Ctrl + F InsertFootnoteNow Inserts a footnote reference at the insertionpoint without displaying the dialog
Alt + Ctrl + F1 MicrosoftSystemInf
o
Execute the Microsoft System Info
application
Alt+Ctrl +
Home
BrowseSel Select the next/prev browse object
Alt + Ctrl + K FormatAutoFormat Automatically formats a document (orsometimes, automatically screws it up)
Alt + Ctrl + L InsertListNumField Inserts a ListNum Field
Alt + Ctrl + M
(or Alt I, M)
InsertAnnotation Inserts a comment
Alt + Ctrl +
PgDn
EndOfWindow Moves the insertion point to the end of the
last visible line on the screen
Alt + Ctrl + S DocSplit Splits the active window horizontally and
then adjusts the split
-
8/8/2019 Shortcut Keys for Word - Excel
3/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Alt + Ctrl + U TableUpdateAutoFormat
Updates the table formatting to match theapplied Table Autoformat settings
Alt + double-
click
TableSelectTable Selects an entire table
Alt + down
arrow
NextObject Moves to the next object on the page
Alt + F10 AppMaximize Enlarges the application window to full sizeAlt + F11 ViewVBCode Shows the VB editing environment (Tools +
Macro + Visual Basic Editor)
Alt + F3 CreateAutoText Adds an AutoText entry to the active
template
-
8/8/2019 Shortcut Keys for Word - Excel
4/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Alt + F4 () File Close Or Exit Closes the current document, or if nodocuments are open, quits Word. Horrible
command, as it makes it a long winded
business to quit Word. But theres a simple
solution assign Alt+F4 to File Exit instead.
Alt + F4 (Word
97)
File Exit Quits Microsoft Word and prompts to save
the documents (does intercept the menuitem, but not the keyboard shortcut, or the x
button. An Auto Exit macro is usually a
better way of intercepting this).
Alt + F5 App Restore Restores the application window to normal
size
Alt + F7 Next Misspelling Find next spelling errorAlt + F8 Tools Macro Runs, creates, deletes, or revises a macro
-
8/8/2019 Shortcut Keys for Word - Excel
5/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Alt + left arrow WebGoBack Backward hyperlink (useful if you clickedon a page number hyperlink in the table of
contents and then want to return to the
TOC)
Alt + PageDn
(to select to end
of column, useAlt + Shift +
PgDn)
EndOfColumn Moves to the last cell in the current table
column
Alt + PgUp StartOfColumn Moves to the first cell in the current column
Alt + rt arrow WebGoForward Forward hyperlink
Alt + Shift + A ShowAllHeadings Displays all of the heading levels and the
body text in Outline ViewAlt + Shift +
Backspace
EditRedo Redoes the last action that was undone
-
8/8/2019 Shortcut Keys for Word - Excel
6/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Alt + Shift + C ClosePane Closes the active window pane (if you are inNormal View and have, for example, the
Footnote pane open)
Alt + Shift + D InsertDateField Inserts a date field
Alt + Shift + F InsertMergeField Brings up a dialog to insert a mail merge
field at the insertion point. (It does not
intercept the button on the Mail merge.toolbar)
Alt + Shift +
F11
MicrosoftScriptEdit
or
Starts or switches to Microsoft Development
Environment application, allowing you to
view the HTML/XML source code that
would be behind the document if it were
in .htm format (or that is behind it if italready is in .htm format).
Alt + Shift + F9 DoFieldClick Executes the action associated with
macrobutton fields
-
8/8/2019 Shortcut Keys for Word - Excel
7/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Alt + Shift + I MarkCitation Marks the text you want to include in thetable of authorities
Alt + Shift + K MailMergeCheck Checks for errors in a mail merge
Alt + Shift + L OutlineShowFirstLi
ne
Toggles between showing the first line of
each paragraph only or showing all of the
body text in the outline
Alt + Shift + N MailMergeToDoc Collects results of mail merge in a documentAlt + Shift + O MarkTableOfConte
ntsEntry
Inserts a TC field (but it is far better to use
Heading Styles to generate your Table of
Contents instead)
Alt + Shift + P InsertPageField Inserts a page number field
Alt + Shift + R FormatHeaderFoot
erLink
Links the current header/footer to the
previous section (but does not intercept thebutton on the Header Footer toolbar)
Alt + Shift + T InsertTimeField Inserts a time field
-
8/8/2019 Shortcut Keys for Word - Excel
8/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Alt + Shift + X MarkIndexEntry Marks the text you want to include in theindex
Alt + up arrow PrevObject Moves to the previous object on the page
Alt A, F TableAutoFormat Applies a set of formatting to a table
Alt A, H TableHeadings Toggles table headings attribute on and off
Alt E, K EditLinks Allows links to be viewed, updated, opened,
or removed
Alt E, S EditPasteSpecial Inserts the Clipboard contents as a linked
object, embedded object, or other format
Alt F, A (or
F12)
FileSaveAs Saves a copy of the document in a separate
file (brings up the dialog)
Alt F, I FileProperties Shows the properties of the active document
Alt F, U FilePageSetup Changes the page setup of the selected
sections
-
8/8/2019 Shortcut Keys for Word - Excel
9/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Alt I, B InsertBreak Ends a page /column / section at insertionpoint
Alt I, C InsertCaption Inserts caption above / below a selected
object
Alt I, D InsertIndexAndTab
les
Inserts an index or a table of contents,
figures, or authorities into the document
Alt I, F InsertField Inserts a field in the active documentAlt I, L InsertFile Inserts the text of another file into the active
document
Alt I, N InsertFootnote Inserts a footnote or endnote reference at
the insertion point
Alt O, B FormatBordersAnd
Shading
Changes the borders and shading of the
selected paragraphs, table cells, and pictures
Alt O, C FormatColumns Changes the column format of the selected
sections (brings up the dialog)
-
8/8/2019 Shortcut Keys for Word - Excel
10/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Alt O, D FormatDropCap Formats the first character of currentparagraph as a dropped capital (must select
it first)
Alt O, E FormatChangeCase Changes the case of the letters in the
selection
Alt O, P FormatParagraph Brings up the Format Paragraph dialog
Alt O, S FormatStyle Applies, creates, or modifies stylesAlt O, T FormatTabs Brings up the Format Tabs dialog
Alt or F10 MenuMode Makes the menu bar active
Alt R, G DrawGroup Groups the selected drawing objects
Alt R, I DrawSnapToGrid Sets up a grid for aligning drawing objects
Alt R, U DrawUngroup Ungroups the selected group of drawingobjects
-
8/8/2019 Shortcut Keys for Word - Excel
11/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Alt T, C ToolsCustomize Allows you to customizes the Word userinterface (menus, keyboard and toolbars)
and store the customizations in a template
(defaults to Normal.dot, so be careful!)
Alt V, F ViewFootnotes If in Normal View, opens a pane for viewing
and editing footnotes and endnotes (toggle).
If in Page/Print Layout View, switches from
the body text to the footnotes/endnotes or
vice versa.
Alt V, H ViewHeader Displays header in page layout view
Alt V, N Or
( Alt + Ctrl + N)
ViewNormal Changes the editing view to normal view
Alt V, O Or(or Alt + Ctrl +
O)
ViewOutline Displays a document's outline
-
8/8/2019 Shortcut Keys for Word - Excel
12/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Alt V, P Or(Alt + Ctrl + P)
ViewPage Displays the page more-or-less as it will beprinted, and allows editing (In Word 2000
the menu item is called Print Layout, but
fortunately the command hasnt changed.
Alt W, A WindowArrangeAll Arranges windows as non-overlapping tiles
Alt+Ctrl+PgUp Start Of Window Moves the insertion point to the beginning of
the first visible line on the screenAlt+Drag (or
press Ctrl +
Shift + F8 and
drag, but Alt +
Drag is far
easier!)
Column Select Selects a columnar block of text
Alt+End EndOfRow Moves to the last cell in the current row
Alt+Home StartOfRow Moves to the first cell in the current row
-
8/8/2019 Shortcut Keys for Word - Excel
13/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Alt+Shift+downarrow
OutlineMoveDown Moves the selection below the next item inthe outline
Alt+Shift+E MailMergeEditDat
aSource
Lets you edit a mail merge data source
Alt+Shift+left
arrow
OutlinePromote Promotes the selected paragraphs one
heading level
Alt+Shift+rtarrow
OutlineDemote Demotes the selected paragraphs oneheading level
Alt+Shift+up
arrow
OutlineMoveUp Moves the selection above the previous item
in the outline
At + F9 ViewFieldCodes Shows the field codes or results for all fields
(toggle)
Click in leftmargin
TableSelectRow Selects the current row in a table
Click on it HyperlinkOpen Connect to a hyperlinks address
-
8/8/2019 Shortcut Keys for Word - Excel
14/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Ctrl + Shift + E ToolsRevisionMarksToggle Toggles track changes for the activedocument
Ctrl + * ShowAll Shows/hides all nonprinting characters
Ctrl + [ ShrinkFontOnePoi
nt
Decreases the font size of the selection by
one point
Ctrl + ] GrowFontOnePoint Increases the font size of the selection by one
pointCtrl + + Superscript Makes the selection superscript (toggle)
Ctrl + < ShrinkFont Decreases the font size of the selection
Ctrl + = Subscript Makes the selection subscript (toggle)
Ctrl + > GrowFont Increases the font size of the selection
Ctrl + 0 OpenOrCloseUpPara Sets or removes extra spacing above theselected paragraph
Ctrl + 1 SpacePara1 Sets the line spacing to single space
-
8/8/2019 Shortcut Keys for Word - Excel
15/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Ctrl + 2 SpacePara2 Sets the line spacing to double spaceCtrl + 5 SpacePara15 Sets the line spacing to one-and-one-half
space
Ctrl + Del DeleteWord Deletes the next word without putting it on
the Clipboard
Ctrl + down
arrow
ParaDown Moves the insertion point to the beginning of
the next paragraphCtrl + F10 DocMaximize Enlarges the active window to full size
Ctrl + F11 LockFields Locks the selected fields to prevent updating
Ctrl + F3 Spike Deletes the selection and adds it to the
Spike AutoText entry (which allows you
to move text and graphics from nonadjacent
locations)
Ctrl + F5 DocRestore Restores the window to normal size
-
8/8/2019 Shortcut Keys for Word - Excel
16/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Ctrl + F6 NextWindow Switches to the next documelnt window,equivalent to selecting a document from the
Window menu.
Ctrl + F7 DocMove Changes the position of the active window
Ctrl + F8 DocSize Changes the size of the active window
Ctrl + I Italic Makes the selection italic (toggle)
Ctrl + J JustifyPara Aligns the paragraph at both the left and theright indent
Ctrl + K InsertHyperlink Insert Hyperlink
Ctrl + L LeftPara Aligns the paragraph at the left indent
Ctrl + left
arrow
WordLeft Moves the insertion point to the left one
word
Ctrl + M (or
drag the ruler)
Indent Moves the left indent to the next tab stop
-
8/8/2019 Shortcut Keys for Word - Excel
17/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Ctrl + P FilePrint Prints active document (brings up thedialog)
Ctrl + PgDn BrowseNext Jump to the next browse object
Ctrl + PgUp BrowsePrev Jump to the previous browse object
Ctrl + Return InsertPageBreak Inserts a page break at the insertion point
Ctrl + rt arrow WordRight Moves the insertion point to the right one
word
Ctrl + Shift + A AllCaps Makes the selection all capitals (toggle)
Ctrl + Shift + D DoubleUnderline Double underlines the selection (toggle)
Ctrl+ Shift +
F11
UnlockFields Unlocks the selected fields for updating
Ctrl + Shift +F3 InsertSpike Empties the spike AutoText entry andinserts all of its contents into the document
-
8/8/2019 Shortcut Keys for Word - Excel
18/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Ctrl + Shift +F6 PrevWindow Switches back to previous document window
Ctrl + Shift + H HIDDEN Makes the selection hidden text (toggle)
Ctrl + Shift + K SmallCaps Makes the selection small capitals (toggle)
Ctrl + Shift + M
Or
(drag the ruler)
UnIndent Moves the left indent to the previous tab
stop
Ctrl + Shift + Q SymbolFont Applies the Symbol font to the selection
Ctrl + Shift +
Return
InsertColumnBreak Inserts a column break at the insertion point
Ctrl + Shift + T
Or
(drag the ruler)
UnHang Decreases the hanging indent
Ctrl + Shift + W WordUnderline Underlines the words but not the spaces in
the selection (toggle)
-
8/8/2019 Shortcut Keys for Word - Excel
19/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Ctrl + Shift+ L ApplyListBullet Applies List Bullet style to the selected textCtrl + Shift +
F7
UpdateSource Copies the modified text of a linked file back
to its source file
Ctrl + T
(drag the ruler)
HangingIndent Increases the hanging indent
Ctrl + up arrow ParaUp Moves the insertion point to the beginning of
the previous paragraphCtrl +Home StartOfDocument Moves the insertion point to the beginning of
the first line of the document
Ctrl +R RightPara Aligns the paragraph at the right indent
Ctrl +Shift+C CopyFormat Copies the formatting of the selection
Ctrl+
Backspace
DeleteBackWord Deletes the previous word without putting it
on the Clipboard
Ctrl+A EditSelectAll Selects the entire document
-
8/8/2019 Shortcut Keys for Word - Excel
20/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Ctrl+B Bold Makes the selection bold (toggle)Ctrl+C EditCopy Copies the selection and puts it on the
Clipboard
Ctrl+D FormatFont Brings up the Format + Font dialog
Ctrl+E CenterPara Centers the paragraph between the indents
Ctrl+End EndOfDocument Moves the insertion point to the end of the
last line of the document
Ctrl+F EditFind Finds the specified text or the specified
formatting
Ctrl+F2 FilePrintPreview Displays full pages as they will be printed
Ctrl+F9 InsertFieldChars Inserts an empty field with the enclosing
field characters
Ctrl+H EditReplace Finds the specified text or the specified
formatting and replaces it
-
8/8/2019 Shortcut Keys for Word - Excel
21/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Ctrl+N FileNewDefault Creates a new document based on theNormal template.
Ctrl+N FileNew Creates a new document or template (brings
up the dialog). Note that: Word pretends
that Ctrl+N is assigned to FileNew but it
isnt, its assigned to FileNewDefault You
can fix this in Word 2000 by assigning
Ctrl+N to the FileNewDialog command. In
Word 97 the only way to fix it is to create a
macro called FileNew (to do this, press Alt +
F8, type "FileNew" without the quotes and
Click "Create". The macro will
automatically contain the code needed to
make it work).Ctrl+O FileOpen Opens an existing document or template
-
8/8/2019 Shortcut Keys for Word - Excel
22/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Ctrl+Q ResetPara Makes the selection the default paragraphformat of the applied style
Ctrl+S FileSave FileSave
Ctrl+Shift+End EndOfDocExtend Extends the selection to the end of the last
line of the document
Ctrl+Shift+F Font Activates the Fonts listbox on the formatting
toolbarCtrl+Shift+F5
(Or: Alt I, K)
EditBookmark Brings up the bookmark dialog
Ctrl+Shift+F9 UnlinkFields Permanently replaces the field codes with
the results
Ctrl+Shift+Ho
me
StartOfDocExtend Extends the selection to the beginning of the
first line of the document
Ctrl+Shift+N NormalStyle Applies the Normal style
-
8/8/2019 Shortcut Keys for Word - Excel
23/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Ctrl+Shift+P FontSizeSelect Activates the Font Size drop-down on theformatting toolbar
Ctrl+Shift+V PasteFormat Applies the previously copied formatting to
selection
Ctrl+Spacebar ResetChar Makes the selection the default character
format of the applied style
Ctrl+U Underline Formats the selection with a continuousunderline (toggle)
Ctrl+V EditPaste Inserts the Clipboard contents at the
insertion point
Ctrl+W,
Ctrl+F4
DocClose Prompts to save the document and then
closes the active window. (But doesnt
intercept the menu command)Ctrl+X EditCut Cuts the selection and puts it on the
Clipboard
-
8/8/2019 Shortcut Keys for Word - Excel
24/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Ctrl+Z EditUndo Reverses the last actionDbl-click the
endnote
reference
ViewEndnoteArea If in Normal View, opens a pane for viewing
and editing the endnote (toggle). If in
Page/Print Layout View, switches from the
body text to the endnote or vice versa
Dbl-click the
footnotereference
ViewFootnoteArea If in Normal View, opens a pane for viewing
and editing the footnote (toggle). If inPage/Print Layout View, switches from the
body text to the footnote or vice versa.
Del EditClear Performs a forward delete or removes the
selection without putting it on the Clipboard
Down arrow LineDown Moves the insertion point down one line
End EndOfLine Moves the insertion point to the end of thecurrent line
Esc Cancel Terminates an action
-
8/8/2019 Shortcut Keys for Word - Excel
25/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
F1 Help Microsoft Word HelpF11 NextField Moves to the next field
F2 MoveText Moves the selection to a specified location
without using the clipboard (press Return to
execute the more)
F3 InsertAutoText Replaces the name of the AutoText entry
with its contentsF4 EditRedo Or
Repeat
Repeats the last command, or redoes the last
action that was undone (unfortunately,
doesnt work for as many commands in
Word 2000 as in Word 97 and below, but
this is still one of Words most useful
shortcuts, if not the most useful)F5, Ctrl+G EditGoTo Jumps to a specified place in the active
document
-
8/8/2019 Shortcut Keys for Word - Excel
26/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
F6 OtherPane Switches to another window pane in NormalView (for instance, if you have if you have a
Footnotes pane open in Normal view and
want to switch to the main document and
back without closing the pane).
F7 ToolsProofing Checks the spelling and grammar in the
active document
F8 (press Esc to
turn off)
ExtendSelection Turns on extend selection mode and then
expands the selection with the direction keys
F9 UpdateFields Updates and displays the results of the
selected fields
Home StartOfLine Moves the insertion point to the beginning of
the current lineHover over
comment
ViewAnnotations Show or hide the comment pane
-
8/8/2019 Shortcut Keys for Word - Excel
27/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Ins Overtype Toggles the typing mode between replacingand inserting
Left arrow Char Left Moves the insertion point to the left one
character
PgDn Page Down Moves the insertion point and document
display to the next screen of text
PgUp Page Up Moves the insertion point and documentdisplay to the previous screen of text
Right arrow Char Right Moves the insertion point to the right one
character
Shift+F4 Repeat Find Repeats Go To or Find to find the next
occurrence
Shift + Alt +Ctrl + PgDn
End Of WindowExtend
Extends the selection to the end of the lastvisible line on the screen
-
8/8/2019 Shortcut Keys for Word - Excel
28/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Shift + Ctrl +down arrow ParaDownExtend Extends the selection to the beginning of thenext paragraph
Shift + Ctrl +
left arrow
WordLeftExtend Extends the selection to the left one word
Shift + Ctrl + rt
arrow
WordRightExtend Extends the selection to the right one word
Shift + Ctrl +up arrow
ParaUpExtend Extends the selection to the beginning of theprevious paragraph
Shift + down
arrow
LineDownExtend Extends the selection down one line
Shift + F1 HelpTool Gets help on a command / screen region.
Shift + F2 CopyText Makes a copy of the selection without using
the clipboard (press Return to paste)
-
8/8/2019 Shortcut Keys for Word - Excel
29/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Shift + F5 GoBack Returns to the previous insertion point (goesback to up to 3 points, then returns to where
you started; this is one of the most useful
shortcuts of them all. Also useful when
opening a document, if you want to g
straight to where you were last editing it)
Shift + F7 ToolsThesaurus Finds a synonym for the selected word
Shift + F9 (Alt +
F9 toggles all
field codes on or
off)
ToggleFieldDisplay Shows the field codes or the results for the
selection (toggle)
Shift + F11 PrevField Moves to the previous field
Shift+Leftarrow CharLeftExtend Extends the selection to the left onecharacter
-
8/8/2019 Shortcut Keys for Word - Excel
30/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Shift + PgUp PageUpExtend Extends the selection and changes thedocument display to the previous screen of
text
Shift + Rightt
arrow
CharRightExtend Extends the selection to the right one
character
Shift + Tab PrevCell Moves to the previous table cell
Shift + uparrow
LineUpExtend Extends the selection up one line
Shift+
Alt+Ctrl+PgUp
StartOfWindowExt
end
Extends the selection to the beginning of the
first visible line on the screen
Shift+ PgDn PageDownExtend Extends the selection and changes the
document display to the next screen of text
Shift+End EndOfLineExtend Extends the selection to end of the currentline
-
8/8/2019 Shortcut Keys for Word - Excel
31/60
SHORTCUT KEYS FOR MICROSOFT WORD
Keys Windows Name Description
Shift+F3 ChangeCase Changes the case of the letters in theselection
Shift+Home StartOfLineExtend Extends the selection to the beginning of the
current line
Strl + Shift + S Style Activates the Style drop-down on the
Formatting toolbar
Tab NextCell Moves to the next table cellUp arrow LineUp Moves the insertion point up one line
-
8/8/2019 Shortcut Keys for Word - Excel
32/60
Excel Tips & Shortcut Keys
Keys for moving and scrolling in a worksheet or workbook
Arrow keys Move one cell up, down, left, or right
CTRL + arrow key Move to the edge of the current data region
HOME Move to the beginning of the row
CTRL+HOME Move to the beginning of the worksheet
CTRL+END Move to the last cell on the worksheet, which is thecell at the intersection of the rightmost used column
and the bottom-most used row (in the lower-right
corner), or the cell opposite the home cell, which is
typically A1
PAGE DOWN Move down one screenPAGE UP Move up one screen
ALT+PAGE DOWN Move one screen to the right
-
8/8/2019 Shortcut Keys for Word - Excel
33/60
Excel Tips & Shortcut Keys
ALT+PAGE UP Move one screen to the left
CTRL+PAGE DOWN Move to the next sheet in the workbookCTRL+PAGE UP Move to the previous sheet in the workbook
CTRL+F6 or CTRL+TAB Move to the next workbook or window
CTRL+SHIFT+F6
or CTRL+SHIFT+TAB
Move to the previous workbook or window
F6 Move to the next pane in a workbook that has been
split
SHIFT+F6 Move to the previous pane in a workbook that has
been split
CTRL+BACKSPACE Scroll to display the active cell
F5 Display the Go To dialog box
SHIFT+F5 Display the Find dialog boxSHIFT+F4 Repeat the last Find action (same as Find Next)
-
8/8/2019 Shortcut Keys for Word - Excel
34/60
Excel Tips & Shortcut Keys
TAB Move between unlocked cells on a protected
worksheet
Keys for moving in a worksheet with End mode on
END Turn End mode on or off
END, arrow key Move by one block of data within a row or column
END, HOME Move to the last cell on the worksheet, which is the
cell at the intersection of the rightmost used column
and the bottom-most used row (in the lower-rightcorner), or the cell opposite the home cell, which is
typically A1
END, ENTER Move 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)Keys for moving in a worksheet with SCROLL LOCK on
SCROLL LOCK Turn SCROLL LOCK on or off
-
8/8/2019 Shortcut Keys for Word - Excel
35/60
Excel Tips & Shortcut Keys
HOME Move to the cell in the upper-left corner of the
window
END Move to the cell in the lower-right corner of the
window
UP ARROW
or DOWN ARROW
Scroll one row up or down
LEFT ARROW
or RIGHT ARROW
Scroll one column left or right
Tip When you use 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.
Keys for previewing and printing a document
-
8/8/2019 Shortcut Keys for Word - Excel
36/60
Excel Tips & Shortcut Keys
CTRL+P or
CTRL+SHIFT+F12
Display the Print dialog box
Work in print preview
Arrow keys Move around the page when zoomed in
PAGE UP or PAGE DOWN Move by one page when zoomed out
CTRL+UP ARROW or
CTRL+LEFT ARROW
Move to the first page when zoomed out
CTRL+DOWN ARROW orCTRL+RIGHT ARROW
Move to the last page when zoomed out
Keys for working with worksheets, charts, and macros
SHIFT+F11 or
ALT+SHIFT+F1
Insert a new worksheet
F11 or ALT+F1 Create a chart that uses the current range
ALT+F8 Display the Macro dialog box
ALT+F11 Display the Visual Basic Editor
-
8/8/2019 Shortcut Keys for Word - Excel
37/60
Excel Tips & Shortcut Keys
CTRL+F11 Insert a Microsoft Excel 4.0 macro sheet
CTRL+PAGE DOWN Move to the next sheet in the workbookCTRL+PAGE UP Move to the previous sheet in the workbook
SHIFT+CTRL+PAGE DOWN Select the current and next sheet in the workbook
SHIFT+CTRL+PAGE UP Select the current and previous sheet in the
workbook
Keys for entering data on a worksheet
ENTER Complete a cell entry and move down in the selection
ALT+ENTER Start a new line in the same cell
CTRL+ENTER Fill the selected cell range with the current entry
SHIFT+ENTER Complete a cell entry and move up in the selection
TAB Complete a cell entry and move to the right in the
selectionSHIFT+TAB Complete a cell entry and move to the left in the
selection
-
8/8/2019 Shortcut Keys for Word - Excel
38/60
Excel Tips & Shortcut Keys
ESC Cancel a cell entry
BACKSPACE Delete the character to the left of the insertion point,or delete the selection
DELETE Delete the character to the right of the insertion
point, or delete the selection
CTRL+DELETE Delete text to the end of the line
Arrow keys Move one character up, down, left, or right
HOME Move to the beginning of the line
F4 or CTRL+Y Repeat the last action
SHIFT+F2 Edit a cell comment
CTRL+SHIFT+F3 Create names from row and column labels
CTRL+D Fill down
CTRL+R Fill to the rightCTRL+F3 Define a name
Keys for working in cells or the formula bar
-
8/8/2019 Shortcut Keys for Word - Excel
39/60
Excel Tips & Shortcut Keys
BACKSPACE Edit the active cell and then clear it, or delete the
preceding character in the active cell as you edit cell
contents
ENTER Complete a cell entry
CTRL+SHIFT+ ENTER Enter a formula as an array formula
ESC Cancel an entry in the cell or formula bar
CTRL+A Display the Formula Palette after you type a
function name in a formulaCTRL+SHIFT+A Insert the argument names and parentheses for a
function after you type a function name in a formula
CTRL+K Insert a hyperlink
ENTER (in a cell with a
hyperlink)
Activate a hyperlink
F2 Edit the active cell and position the insertion point at
the end of the line
F3 Paste a defined name into a formula
-
8/8/2019 Shortcut Keys for Word - Excel
40/60
Excel Tips & Shortcut Keys
SHIFT+F3 Paste a function into a formula
F9 Calculate all sheets in all open workbooksCTRL+ALT+F9 Calculate all sheets in the active workbook
SHIFT+F9 Calculate the active worksheet
= (equal sign) Start a formula
ALT+= (equal sign) Insert the AutoSum formula
CTRL+; (semicolon) Enter the date
CTRL+SHIFT+: (colon) Enter the time
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 cellinto the cell or the formula bar
ALT+DOWN ARROW Display the AutoComplete list
-
8/8/2019 Shortcut Keys for Word - Excel
41/60
Excel Tips & Shortcut Keys
Keys for formatting data
ALT+' (apostrophe) Display the Style dialog boxCTRL+1 Display the Format Cells dialog box
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 twodecimal 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,
thousands separator, and minus sign () for negative
values
-
8/8/2019 Shortcut Keys for Word - Excel
42/60
-
8/8/2019 Shortcut Keys for Word - Excel
43/60
-
8/8/2019 Shortcut Keys for Word - Excel
44/60
Excel Tips & Shortcut Keys
CTRL+V Paste the selection
DELETE Clear the contents of the selectionCTRL+HYPHEN Delete the selection
CTRL+Z Undo the last action
CTRL+SHIFT+ PLUS SIGN Insert blank cells
Keys for moving within a selection
ENTER Move from top to bottom within the selection
(down), or move in the direction that is selected onthe Edit tab (Tools menu, Options command)
SHIFT+ENTER Move from bottom to top within the selection (up),
or move opposite to the direction that is selected on
the Edit tab (Tools menu, Options command)
TAB Move from left to right within the selection, or move
down one cell if only one column is selected
SHIFT+TAB Move from right to left within the selection, or move
up one cell if only one column is selected
-
8/8/2019 Shortcut Keys for Word - Excel
45/60
Excel Tips & Shortcut Keys
CTRL+PERIOD Move clockwise to the next corner of the selection
CTRL+ALT+RIGHT ARROW Move to the right between nonadjacentselections
CTRL+ALT+LEFT ARROW Move to the left between nonadjacent selections
Keys for selecting cells, columns, or rows
CTRL+SHIFT+ * (asterisk) Select the current region around the active cell (the
current region is a data area enclosed by blank rows
and blank columns)SHIFT+arrow key Extend the selection by one cell
CTRL+SHIFT+arrow key Extend the selection to the last nonblank cell in the
same column or row as the active cell
SHIFT+HOME Extend the selection to the beginning of the row
CTRL+SHIFT+HOME Extend the selection to the beginning of the
worksheet
-
8/8/2019 Shortcut Keys for Word - Excel
46/60
Excel Tips & Shortcut Keys
CTRL+SHIFT+END Extend the selection to the last used cell on the
worksheet (lower-right corner)
CTRL+SPACEBAR Select the entire column
SHIFT+SPACEBAR Select the entire row
CTRL+A Select the entire worksheet
SHIFT+BACKSPACE Select only the active cell when multiple cells are
selected
SHIFT+PAGE DOWN Extend the selection down one screenSHIFT+PAGE UP Extend the selection up one screen
CTRL+SHIFT+ SPACEBAR With an object selected, select all objects on a sheet
CTRL+6 Alternate between hiding objects, displaying objects,
and displaying placeholders for objects
CTRL+7 Show or hide the Standard toolbar
F8 Turn on extending a selection by using the arrow
keys
-
8/8/2019 Shortcut Keys for Word - Excel
47/60
Excel Tips & Shortcut Keys
SHIFT+F8 Add another range of cells to the selection; or use the
arrow keys to move to the start of the range you
want to add, and then press F8 and the arrow keys to
select the next range
SCROLL LOCK,
SHIFT+HOME
Extend the selection to the cell in the upper-left
corner of the window
SCROLL LOCK, SHIFT+END Extend 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.
Keys for extending the selection with End mode on
END Turn End mode on or off END, SHIFT+arrow key Extend the selection to the last nonblank cell in the
same column or row as the active cell
-
8/8/2019 Shortcut Keys for Word - Excel
48/60
Excel Tips & Shortcut Keys
END, SHIFT+HOME Extend the selection to the last cell used on the
worksheet (lower-right corner)
END, SHIFT+ENTER Extend 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).
Keys for selecting cells that have special characteristics
CTRL+SHIFT+*(asterisk) Select the current region around the active cell (thecurrent region is a data 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
-
8/8/2019 Shortcut Keys for Word - Excel
49/60
Excel Tips & Shortcut Keys
CTRL+\ Select cells in a row that don't match the value in the
active cell in that row. You must select the row
starting with the active cell.
CTRL+SHIFT+| Select cells in a column that don't match the value in
the active cell in that column. You must select the
column starting with the active cell.
CTRL+[ (opening bracket) Select only cells that are directly referred to by
formulas in the selection
CTRL+SHIFT+{
(opening brace)
Select all cells that are directly or indirectly referred
to by formulas in the selection
CTRL+]
(closing bracket)
Select only cells with formulas that refer directly to
the active cell
CTRL+SHIFT+}
(closing brace)
Select all cells with formulas that refer directly or
indirectly to the active cellALT+; (semicolon) Select only visible cells in the current selection
Keys for selecting a chart sheet
-
8/8/2019 Shortcut Keys for Word - Excel
50/60
Excel Tips & Shortcut Keys
CTRL+PAGE DOWN Select the next sheet in the workbook, until the chart
sheet you want is selected
CTRL+PAGE UP Select the previous sheet in the workbook, until the
chart sheet you want is selected
-
8/8/2019 Shortcut Keys for Word - Excel
51/60
Keys for selecting an embedded chart
Note The Drawing toolbar must already be displayed.
1. Press F10 to make the menu bar active.2. Press CTRL+TAB or CTRL+SHIFT+TAB to select the Drawing toolbar.
3. Press the RIGHT ARROW key to select the Select Objects button on the
Drawing toolbar.
4. Press CTRL+ENTER to select the first object.
5. Press the TAB key to cycle forward (or SHIFT+TAB to cycle backward) through
the objects until sizing handles appear on the embedded chart you want to select.
6. Press CTRL+ENTER to make the chart active.
Keys for selecting chart items
DOWN ARROW Select the previous group of items
UP ARROW Select the next group of items
RIGHT ARROW Select the next item within the group
LEFT ARROW Select the previous item within the group
-
8/8/2019 Shortcut Keys for Word - Excel
52/60
Keys for working with a data form
ALT+key, where key is the
underlined letter in the field or
command name
Select a field or a command button
DOWN ARROW Move to the same field in the next record
UP ARROW Move to the same field in the previous record
TAB Move to the next field you can edit in the record
SHIFT+TAB Move to the previous field you can edit in the
recordENTER Move to the first field in the next record
SHIFT+ENTER Move to the first field in the previous record
PAGE DOWN Move to the same field 10 records forward
CTRL+PAGE DOWN Move to a new record
PAGE UP Move to the same field 10 records back
CTRL+PAGE UP Move to the first record
HOME or END Move to the beginning or end of a field
-
8/8/2019 Shortcut Keys for Word - Excel
53/60
SHIFT+END Extend a selection to the end of a field
SHIFT+HOME Extend a selection to the beginning of a field
LEFT ARROW or RIGHT
ARROW
Move one character left or right within a field
SHIFT+LEFT ARROW Select the character to the left
SHIFT+RIGHT ARROW Select the character to the right
Keys for using AutoFilter
ALT+DOWN ARROW :
Arrow keys to select the cellthat contains the column label
Display the AutoFilter list for the current column
DOWN ARROW Select the next item in the AutoFilter list
UP ARROW Select the previous item in the AutoFilter list
ALT+UP ARROW Close the AutoFilter list for the current column
HOME Select the first item (All) in the AutoFilter list
END Select the last item in the AutoFilter list
-
8/8/2019 Shortcut Keys for Word - Excel
54/60
ENTER Filter the list by using the selected item in the
AutoFilter list
Keys for outlining data
ALT+SHIFT+RIGHT
ARROW
Group rows or columns
ALT+SHIFT+LEFT ARROW Ungroup rows or columns
CTRL+8 Display or hide outline symbols
CTRL+9 Hide selected rows
CTRL+SHIFT+((opening parenthesis)
Unhide selected rows
CTRL+0 (zero) Hide selected columns
CTRL+SHIFT+)
(closing parenthesis)
Unhide selected columns
Keys for the PivotTable and PivotChart Wizard
UP ARROW or DOWNARROW
Select the previous or next field button in the list
-
8/8/2019 Shortcut Keys for Word - Excel
55/60
LEFT ARROW or RIGHT
ARROW
Select the field button to the left or right in a
multicolumn field button list
ALT+C Move the selected field into the Column area
ALT+D Move the selected field into the Data area
ALT+L Display the PivotTable Field dialog box
ALT+P Move the selected field into the Page area
ALT+R Move the selected field into the Row area
Keys for page fields in a PivotTable or PivotChart report
CTRL+SHIFT+ * (asterisk) Select the entire PivotTable reportArrow keys to select the cell
that contains the field, and
then ALT+DOWN ARROW
Display the list for the current field in a PivotTable
report
Arrow keys to select the page
field in a PivotChart report,
and then ALT+DOWNARROW
Display the list for the current page field in a
PivotChart report
UP ARROW Select the previous item in the list
-
8/8/2019 Shortcut Keys for Word - Excel
56/60
DOWN ARROW Select the next item in the list
HOME Select the first visible item in the list
END Select the last visible item in the list
ENTER Display the selected item
SPACEBAR Select or clear a check box in the list
Keys for laying out a PivotTable or PivotChart report
1. Press F10 to make the menu bar active.
2. Press CTRL+TAB or CTRL+SHIFT+TAB to select the PivotTable toolbar.
3. Press the LEFT ARROW or RIGHT ARROW key to select the menu to the leftor right or, when a submenu is visible, to switch between the main menu and
submenu.
4. Press ENTER (on a field button) and the DOWN ARROW and UP ARROW keys
to select the area you want to move the selected field to.
Note To scroll to the top or bottom of the field list, press ENTER on the More
Fields or button.
Keys for grouping and ungrouping PivotTable items
-
8/8/2019 Shortcut Keys for Word - Excel
57/60
ALT+SHIFT+RIGHT
ARROW
Group selected PivotTable items
ALT+SHIFT+LEFT ARROW Ungroup selected PivotTable items
Keys to use with the OLAP Cube Wizard
-
8/8/2019 Shortcut Keys for Word - Excel
58/60
Use these keys to complete Step 2 in the OLAP Cube Wizard.
To move a field from the Source fields list to the Dimensions box
1. Press the TAB key to select the Source fields list.2. Press the UP ARROW or DOWN ARROW key to select the field you want to
move. Because you cannot change the order of a field after you move it, select first
the field you want to appear at the top of the Dimensions box.
3. Press the TAB key to select the > button, and then press ENTER.
4. To move other fields, repeat steps 1 through 3.
To move a field to a lower or higher level in the Dimensions box
1. Press the TAB key to select the Dimensions box.
2. Press the UP ARROW or DOWN ARROW key to select the field you want to
move.
3. Press CTRL+X.
4. Press UP ARROW / DOWN ARROW key to select where you want to move thefield.
5. Press CTRL+V.
-
8/8/2019 Shortcut Keys for Word - Excel
59/60
-
8/8/2019 Shortcut Keys for Word - Excel
60/60
top related