keyboard shortcuts for excel

Upload: rohit-semlani

Post on 13-Apr-2018

290 views

Category:

Documents


5 download

TRANSCRIPT

  • 7/27/2019 Keyboard Shortcuts for Excel

    1/23

    EYBOARD SHORTCUTS FOREXCEL

    Keys for moving and scrolling in aworksheet or workbook

    Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR andthen press X. To restore the window to its preio!s si"e and location, press

    ALT+SPACEBAR and then press R. To print this topic, press ALT+# and thenpress P.This topic lists$

    %e&s for 'oing and scrolling in a wor(sheet or wor()oo(%e&s for 'oing in a wor(sheet with End 'ode on%e&s for 'oing in a wor(sheet with SCR#LL L#C% on

    Keys for moving and scrolling in a worksheet orworkbook

    Press To

    Arrow keys Move one cell up, down, left, or right

    CTRL+arrow key Move to the edge of the current data regionHOM Move to the !eginning of the row

    CTRL+HOM Move to the !eginning of the worksheet

    CTRL+"# Move to the last cell on the worksheet, which is the cellat the intersection of the right$ost used colu$n and the!otto$%$ost used row &in the lower%right corner', orthe cell opposite the ho$e cell, which is typically A(

    )A* #O" Move down one screen

    )A* ) Move up one screen

    ALT+)A* #O" Move one screen to the right

    ALT+)A* ) Move one screen to the left

    CTRL+)A* #O" Move to the ne-t sheet in the work!ook

    CTRL+)A* ) Move to the previous sheet in the work!ook

    CTRL+./ or CTRL+TA0 Move to the ne-t work!ook or window

  • 7/27/2019 Keyboard Shortcuts for Excel

    2/23

    CTRL+1H2.T+./ orCTRL+1H2.T+TA0

    Move to the previous work!ook or window

    ./ Move to the ne-t pane in awork!ook that has !een split

    1H2.T+./ Move to the previous pane in a work!ook that has !een

    splitCTRL+0AC31)AC 1croll to display the active cell

    .4 #isplay the GoTodialog !o-

    1H2.T+.4 #isplay the Finddialog !o-

    1H2.T+.5 Repeat the last Findaction &sa$e as FindNext'

    TA0 Move !etween unlocked cells on a protected worksheet

    Ret!rn to top

    Keys for moving in a worksheet with End mode on

    Press To

    "# Turn nd $odeon or off

    "#, arrow key Move !y one !lock of data within a row or colu$n

    "#, HOM Move to the last cell on the worksheet, which is the cellat the intersection of the right$ost used colu$n and the!otto$%$ost used row &in the lower%right corner', orthe cell opposite the ho$e cell, which is typically A(

    "#, "TR Move to the last cell to the right in the current row thatis not !lank6 unavaila!le if you have selected theTransition navigation keyscheck !o- on theTransitionta! &Tools$enu, Optionsco$$and'

    Ret!rn to top

    Keys for moving in a worksheet with SCROLLLOCK on

    Press To

    1CROLL LOC3 Turn 1CROLL LOC3on or off

    HOM Move to the cell in the upper%left corner of the window

    "# Move to the cell in the lower%right corner of thewindow

    http://var/www/apps/conversion/tmp/scratch_6/xlhowSplitOrRemoveWindowPanes.htmhttp://var/www/apps/conversion/tmp/scratch_6/xlhowSplitOrRemoveWindowPanes.htmhttp://var/www/apps/conversion/tmp/scratch_6/xlhowSplitOrRemoveWindowPanes.htm
  • 7/27/2019 Keyboard Shortcuts for Excel

    3/23

    ) ARRO or #O" ARRO 1croll one row up or down

    L.T ARRO or R2*HTARRO

    1croll one colu$n left or right

    Ret!rn to topTip *hen &o! !se scrolling (e&s s!ch as PAE -P and PAE #*/0 withSCR#LL L#C% t!rned off, &o!r selection 'oes the distance &o! scroll. 1f &o!want to presere &o!r selection while &o! scroll thro!gh the wor(sheet, t!rn onSCR#LL L#C% first.

    Keys for previewing and printing adocment

    Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR andthen press X. To restore the window to its preio!s si"e and location, press

    ALT+SPACEBAR and then press R. To print this topic, press ALT+# and thenpress P.

    Press To

    CTRL+) or CTRL+1H2.T+.(7 #isplay the Printdialog !o-

    !ork in print preview

    Press To

    Arrow keys Move around the page when 8oo$ed in

    )A* ) or )A* #O" Move !y one page when 8oo$ed out

    CTRL+) ARRO or CTRL+L.TARRO

    Move to the first page when 8oo$ed out

    CTRL+#O" ARRO orCTRL+R2*HT ARRO Move to the last page when 8oo$ed out

  • 7/27/2019 Keyboard Shortcuts for Excel

    4/23

    Keys for working with worksheets"

    charts" and macrosNote To enlarge the Help window to fill the screen, press ALT+SPACEBAR andthen press X. To restore the window to its preio!s si"e and location, press

    ALT+SPACEBAR and then press R. To print this topic, press ALT+# and thenpress P.

    Press To

    1H2.T+.(( or ALT+1H2.T+.( 2nsert a new worksheet

    .(( or ALT+.( Create a chart that uses the current range

    ALT+.9 #isplay the Macrodialog !o-

    ALT+.(( #isplay the :isual 0asic ditor

    CTRL+.(( 2nsert a Microsoft -cel 5;< $acro sheet

    CTRL+)A* #O" Move to the ne-t sheet in the work!ook

    CTRL+)A* ) Move to the previous sheet in the work!ook

    1H2.T+CTRL+)A* #O" 1elect the current and ne-t sheet in the work!ook

    1H2.T+CTRL+)A* ) 1elect the current and previous sheet in the work!ook

    Keys for entering dataNote To enlarge the Help window to fill the screen, press ALT+SPACEBAR andthen press X. To restore the window to its preio!s si"e and location, press

    ALT+SPACEBAR and then press R. To print this topic, press ALT+# and thenpress P.This topic lists$

  • 7/27/2019 Keyboard Shortcuts for Excel

    5/23

    %e&s for entering data on a wor(sheet%e&s for wor(ing in cells or the for'!la )ar

    Keys for entering data on a worksheet

    Press To

    "TR Co$plete a cell entry and $ove down in the selection

    ALT+"TR 1tart a new line in the sa$e cell

    CTRL+"TR .ill the selected cell range with the current entry

    1H2.T+"TR Co$plete a cell entry and $ove up in the selection

    TA0 Co$plete a cell entry and $ove to the right in theselection

    1H2.T+TA0 Co$plete a cell entry and $ove to the left in the

    selection

    1C Cancel a cell entry

    0AC31)AC #elete the character to the left of the insertion point,or delete the selection

    #LT #elete the character to the right of the insertion point,or delete the selection

    CTRL+#LT #elete te-t to the end of the line

    Arrow keys Move one character up, down, left, or right

    HOM Move to the !eginning of the line

    .5 or CTRL+= Repeat the last action

    1H2.T+.7 dit a cell co$$ent

    CTRL+1H2.T+.> Create na$es fro$ row and colu$n la!els

    CTRL+# .ill down

    CTRL+R .ill to the right

    CTRL+.> #efine a na$e

    Ret!rn to top

    Keys for working in cells or the formla bar

    Press To

    0AC31)AC dit the active cell and then clear it, or delete thepreceding character in the active cell as you edit cell

  • 7/27/2019 Keyboard Shortcuts for Excel

    6/23

    contents

    "TR Co$plete a cell entry

    CTRL+1H2.T+"TR nter a for$ula as an array for$ula

    1C Cancel an entry in the cell or for$ula !ar

    CTRL+A #isplay the .or$ula )aletteafter you type a functionna$e in a for$ula

    CTRL+1H2.T+A 2nsert the argu$ent na$es and parentheses for afunction after you type a function na$e in a for$ula

    CTRL+3 2nsert a hyperlink

    "TR &in a cell with a hyperlink' Activate a hyperlink

    .7 dit the active cell and position the insertion point atthe end of the line

    .> )aste a defined na$einto a for$ula1H2.T+.> )aste a function into a for$ula

    .? Calculate all sheets in all open work!ooks

    CTRL+ALT+.? Calculate all sheets in the active work!ook

    1H2.T+.? Calculate the active worksheet

    @ &eual sign' 1tart a for$ula

    ALT+@ &eual sign' 2nsert the Auto1u$ for$ula

    CTRL+6 &se$icolon' nter the date

    CTRL+1H2.T+B &colon' nter the ti$e

    CTRL+1H2.T+ &uotation $ark' Copy the value fro$ the cell a!ove the active cell intothe cell or the for$ula !ar

    CTRL+D &single left uotation$ark'

    Alternate !etween displaying cell values anddisplaying cell for$ulas

    CTRL+E &apostrophe' Copy a for$ula fro$ the cell a!ove the active cellinto the cell or the for$ula !ar

    ALT+#O" ARRO #isplay the AutoCo$plete list

    Ret!rn to top

    Keys for formatting data

    Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR andthen press X. To restore the window to its preio!s si"e and location, press

  • 7/27/2019 Keyboard Shortcuts for Excel

    7/23

    ALT+SPACEBAR and then press R. To print this topic, press ALT+# and thenpress P.

    Press To

    ALT+E &apostrophe' #isplay the Styledialog !o-

    CTRL+( #isplay the FormatCellsdialog !o-CTRL+1H2.T+F Apply the *eneral nu$!er for$at

    CTRL+1H2.T+G Apply the Currency for$at with two deci$al places&negative nu$!ers appear in parentheses'

    CTRL+1H2.T+ Apply the )ercentage for$at with no deci$al places

    CTRL+1H2.T+I Apply the -ponential nu$!er for$at with twodeci$al places

    CTRL+1H2.T+J Apply the #ate for$at with the day, $onth, and year

    CTRL+1H2.T+K Apply the Ti$e for$at with the hour and $inute, and

    indicate A;M; or );M;

    CTRL+1H2.T+ Apply the "u$!er for$at with two deci$al places,thousands separator, and $inus sign &' for negativevalues

    CTRL+1H2.T+N Apply the outline !order

    CTRL+1H2.T+ Re$ove outline !orders

    CTRL+0 Apply or re$ove !old for$atting

    CTRL+2 Apply or re$ove italic for$atting

    CTRL+ Apply or re$ove an underlineCTRL+4 Apply or re$ove strikethrough for$atting

    CTRL+? Hide rows

    CTRL+1H2.T+& &openingparenthesis' nhide rows

    CTRL+< &8ero' Hide colu$ns

    CTRL+1H2.T+' &closingparenthesis' nhide colu$ns

  • 7/27/2019 Keyboard Shortcuts for Excel

    8/23

    Keys for editing data

    Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR andthen press X. To restore the window to its preio!s si"e and location, press

    ALT+SPACEBAR and then press R. To print this topic, press ALT+# and thenpress P.This topic lists$%e&s for editing data%e&s for inserting, deleting, and cop&ing a selection%e&s for 'oing within a selection

    Keys for editing data

    Press To

    .7 dit the active cell and put the insertion point atthe end of the line

    1C Cancel an entry in the cell or for$ula !ar

    0AC31)AC dit the active cell and then clear it, or delete thepreceding character in the active cell as you editthe cell contents

    .> )aste a defined na$einto a for$ula

    "TR Co$plete a cell entry

    CTRL+1H2.T+"TR nter a for$ula as an array for$ula

    CTRL+A #isplay the.or$ula )aletteafter you type afunction na$e in a for$ula

    CTRL+1H2.T+A 2nsert the argu$ent na$es and parentheses for afunction, after you type a function na$e in afor$ula

    .P #isplay the Spellingdialog !o-

    Ret!rn to top

    Keys for inserting" deleting" and copying aselection

    Press To

    CTRL+C Copy the selection

    CTRL+Q Cut the selection

  • 7/27/2019 Keyboard Shortcuts for Excel

    9/23

    CTRL+: )aste the selection

    #LT Clear the contents of the selection

    CTRL+H=)H" #elete the selection

    CTRL+ ndo the last action

    CTRL+1H2.T+)L1 12*" 2nsert !lank cells

    Ret!rn to top

    Keys for moving within a selection

    Press To

    "TR Move fro$ top to !otto$ within the selection &down',or $ove in the direction that is selected on the Editta!

    &Tools$enu, Optionsco$$and'

    1H2.T+"TR Move fro$ !otto$ to top within the selection &up', or$ove opposite to the direction that is selected on theEditta! &Tools$enu, Optionsco$$and'

    TA0 Move fro$ left to right within the selection, or $ovedown one cell if only one colu$n is selected

    1H2.T+TA0 Move fro$ right to left within the selection, or $ove upone cell if only one colu$n is selected

    CTRL+)R2O# Move clockwise to the ne-t corner of the selection

    CTRL+ALT+R2*HT ARRO Move to the right !etween nonadSacent selections

    CTRL+ALT+L.T ARRO Move to the left !etween nonadSacent selections

    Keys for selecting data and cells

    Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR andthen press X. To restore the window to its preio!s si"e and location, press

    ALT+SPACEBAR and then press R. To print this topic, press ALT+# and then

    press P.This topic lists$%e&s for selecting cells, col!'ns, or rows%e&s for e2tending the selection with End 'ode on%e&s for selecting cells that hae special characteristics

    Keys for selecting cells" colmns" or rows

  • 7/27/2019 Keyboard Shortcuts for Excel

    10/23

    Press To

    CTRL+1H2.T+ &asterisk' 1elect the current region around the active cell &thecurrent region is a data area enclosed !y !lank rowsand !lank colu$ns'

    1H2.T+arrow key -tend the selection !y one cellCTRL+1H2.T+arrow key -tend the selection to the last non!lank cell in the

    sa$e colu$n or row as the active cell

    1H2.T+HOM -tend the selection to the !eginning of the row

    CTRL+1H2.T+HOM -tend the selection to the !eginning of the worksheet

    CTRL+1H2.T+"# -tend the selection to the last used cell on theworksheet &lower%right corner'

    CTRL+1)AC0AR 1elect the entire colu$n

    1H2.T+1)AC0AR 1elect the entire row

    CTRL+A 1elect the entire worksheet

    1H2.T+0AC31)AC 1elect only the active cell when $ultiple cells areselected

    1H2.T+)A* #O" -tend the selection down one screen

    1H2.T+)A* ) -tend the selection up one screen

    CTRL+1H2.T+1)AC0AR ith an o!Sect selected, select all o!Sects on a sheet

    CTRL+/ Alternate !etween hiding o!Sects, displaying o!Sects,and displaying placeholders for o!Sects

    CTRL+P 1how or hide the Standardtool!ar

    .9 Turn on e-tending a selection !y using the arrow keys

    1H2.T+.9 Add another range of cells to the selection6 or use thearrow keys to $ove to the start of the range you want toadd, and then press .9 and the arrow keys to select thene-t range

    1CROLL LOC3, 1H2.T+HOM -tend the selection to the cell in the upper%left cornerof the window

    1CROLL LOC3, 1H2.T+"# -tend the selection to the cell in the lower%right corner

    of the window

    Tip *hen &o! !se the scrolling (e&s s!ch as PAE -P and PAE #*/0with SCR#LL L#C% t!rned off, &o!r selection 'oes the distance &o! scroll. 1f&o! want to (eep the sa'e selection as &o! scroll, t!rn on SCR#LL L#C% first.

  • 7/27/2019 Keyboard Shortcuts for Excel

    11/23

    Keys for e#tending the selection with End modeon

    Press To

    "# Turn nd $odeon or off

    "#, 1H2.T+arrow key -tend the selection to the last non!lank cell in thesa$e colu$n or row as the active cell

    "#, 1H2.T+HOM -tend the selection to the last cell used on theworksheet &lower%right corner'

    "#, 1H2.T+"TR -tend the selection to the last cell in the current row;This keystroke is unavaila!le if you selected theTransitionnavigationkeyscheck !o- on theTransitionta! &Tools$enu, Optionsco$$and';

    Keys for selecting cells that have specialcharacteristics

    Press To

    CTRL+1H2.T+ &asterisk' 1elect the current region around the active cell &thecurrent region is a data area enclosed !y !lank rowsand !lank colu$ns'

    CTRL+U 1elect the currentarray,which is the array that theactive cell !elongs to

    CTRL+1H2.T+O &the letter O' 1elect all cells with co$$ents

    CTRL+V 1elect cells in a row that donEt $atch the value in theactive cell in that row; =ou $ust select the row startingwith the active cell;

    CTRL+1H2.T+W 1elect cells in a colu$n that donEt $atch the value inthe active cell in that colu$n; =ou $ust select thecolu$n starting with the active cell;

    CTRL+X &opening !racket' 1elect only cells that are directly referred to !yfor$ulas in the selection

    CTRL+1H2.T+Y &opening !race' 1elect all cells that are directly or indirectly referred to!y for$ulas in the selection

    CTRL+Z &closing !racket' 1elect only cells with for$ulas that refer directly to theactive cell

    CTRL+1H2.T+[ &closing !race' 1elect all cells with for$ulas that refer directly or

  • 7/27/2019 Keyboard Shortcuts for Excel

    12/23

    indirectly to the active cell

    ALT+6 &se$icolon' 1elect only visi!le cells in the current selection

    Ret!rn to top

    Keys for selecting charts and chartitems

    Keys for selecting a chart sheet

    Press To

    CTRL+)A* #O" 1elect the ne-t sheet in the work!ook, until the chartsheet you want is selected

    CTRL+)A* ) 1elect the previous sheet in the work!ook, until thechart sheet you want is selected

    Keys for selecting an embedded chart

    Note The $rawingtool)ar '!st alread& )e displa&ed.

    (; )ress .(< to $ake the $enu !ar active;

    7; )ress CTRL+TA0 or CTRL+1H2.T+TA0 to select the Drawingtool!ar;

    >; )ress the R2*HT ARRO key to select the Select O!ects !utton on theDrawingtool!ar;

    5; )ress CTRL+"TR to select the first o!Sect;4; )ress the TA0 key to cycle forward &or 1H2.T+TA0 to cycle !ackward' through

    the o!Sects until si8ing handles appear on the e$!edded chart you want to select;/; )ress CTRL+"TR to $ake the chart active;

    Keys for selecting chart items

  • 7/27/2019 Keyboard Shortcuts for Excel

    13/23

    Press To

    #O" ARRO 1elect the previous group of ite$s

    ) ARRO 1elect the ne-t group of ite$s

    R2*HT ARRO 1elect the ne-t ite$ within the group

    L.T ARRO 1elect the previous ite$ within the group

    There are also (e&s to !se with PiotChart reports.

    Keys to se with databases and lists

    Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR andthen press X. To restore the window to its preio!s si"e and location, press

    ALT+SPACEBAR and then press R. To print this topic, press ALT+# and thenpress P.This topic lists$%e&s for wor(ing with a data for'%e&s for !sing A!to3ilter

    Keys for working with a data form

    Press To

    ALT+key, where keyis the

    underlined letter in the field orco$$and na$e

    1elect a field or a co$$and !utton

    #O" ARRO Move to the sa$e field in the ne-t record

    ) ARRO Move to the sa$e field in the previous record

    TA0 Move to the ne-t field you can edit in the record

    1H2.T+TA0 Move to the previous field you can edit in the record

    "TR Move to the first field in the ne-t record

    1H2.T+"TR Move to the first field in the previous record

    )A* #O" Move to the sa$e field (< records forwardCTRL+)A* #O" Move to a new record

    )A* ) Move to the sa$e field (< records !ack

    CTRL+)A* ) Move to the first record

    HOM or "# Move to the !eginning or end of a field

    1H2.T+"# -tend a selection to the end of a field

    http://var/www/apps/conversion/tmp/scratch_6/xlhowLayOutPivKeys.htmhttp://var/www/apps/conversion/tmp/scratch_6/xlhowLayOutPivKeys.htm
  • 7/27/2019 Keyboard Shortcuts for Excel

    14/23

    1H2.T+HOM -tend a selection to the !eginning of a field

    L.T ARRO or R2*HT ARRO Move one character left or right within a field

    1H2.T+L.T ARRO 1elect the character to the left

    1H2.T+R2*HT ARRO 1elect the character to the right

    Ret!rn to top

    Keys for sing %to&ilter

    Press To

    Arrow keys to select the cell thatcontains the colu$n la!el, and thenpress ALT+#O" ARRO #isplay the Auto.ilter list for the current colu$n

    #O" ARRO 1elect the ne-t ite$ in the Auto.ilter list

    ) ARRO 1elect the previous ite$ in the Auto.ilter list

    ALT+) ARRO Close the Auto.ilter list for the current colu$n

    HOM 1elect the first ite$ &"ll' in the Auto.ilter list

    "# 1elect the last ite$ in the Auto.ilter list

    "TR .ilter the list !y using the selected ite$ in theAuto.ilter list

    Ret!rn to top

    Keys to se with 'ivotTable and'ivotChart reports

    Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR andthen press X. To restore the window to its preio!s si"e and location, press

    ALT+SPACEBAR and then press R. To print this topic, press ALT+# and thenpress P.

    This topic lists$%e&s for the PiotTa)le and PiotChart *i"ard%e&s for page fields in a PiotTa)le or PiotChart report%e&s for la&ing o!t a PiotTa)le or PiotChart report%e&s for gro!ping and !ngro!ping PiotTa)le ite's

    Keys for the 'ivotTable and 'ivotChart !i(ard

  • 7/27/2019 Keyboard Shortcuts for Excel

    15/23

    Press To

    ) ARRO or #O" ARRO 1elect the previous or ne-t field !utton in the list

    L.T ARRO or R2*HT ARRO 1elect the field !utton to the left or right in a$ulticolu$n field !utton list

    ALT+C Move the selected field into the Colu$n area

    ALT+# Move the selected field into the #ata area

    ALT+L #isplay the PivotTale Fielddialog !o-

    ALT+) Move the selected field into the )age area

    ALT+R Move the selected field into the Row area

    Ret!rn to top

    Keys for page fields in a 'ivotTable or 'ivotChartreport

    Press To

    CTRL+1H2.T+ &asterisk' 1elect the entire )ivotTa!le report

    Arrow keys to select the cell thatcontains the field, and thenALT+#O" ARRO #isplay the list for the current field in a )ivotTa!le

    report

    Arrow keys to select the page fieldin a )ivotChart report, and thenALT+#O" ARRO

    #isplay the list for the current page field in a)ivotChart report

    ) ARRO 1elect the previous ite$ in the list

    #O" ARRO 1elect the ne-t ite$ in the list

    HOM 1elect the first visi!le ite$ in the list

    "# 1elect the last visi!le ite$ in the list

    "TR #isplay the selected ite$

    1)AC0AR 1elect or clear a check !o- in the list

    Ret!rn to top

  • 7/27/2019 Keyboard Shortcuts for Excel

    16/23

    Keys for laying ot a 'ivotTable or 'ivotChartreport

    (; )ress .(< to $ake the $enu !ar active;

    7; )ress CTRL+TA0 or CTRL+1H2.T+TA0 to select the PivotTaletool!ar;>; )ress the L.T ARRO or R2*HT ARRO key to select the $enu to the left or

    right or, when a su!$enu is visi!le, to switch !etween the $ain $enu andsu!$enu;

    5; )ress "TR &on a field !utton' and the #O" ARRO and ) ARRO keysto select the area you want to $ove the selected field to;

    Note To scroll to the top or )otto' of the field list, press E/TER on the )ore

    &ields or )!tton.Ret!rn to top

    Keys for groping and ngroping 'ivotTableitems

    Press To

    ALT+1H2.T+R2*HT ARRO *roup selected )ivotTa!le ite$s

    ALT+1H2.T+L.T ARRO ngroup selected )ivotTa!le ite$s

    Ret!rn to top

    Keys for mens and toolbars

    Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR andthen press X. To restore the window to its preio!s si"e and location, press

    ALT+SPACEBAR and then press R. To print this topic, press ALT+# and thenpress P.

    Press To.(< or ALT Make the $enu !ar active, or close a visi!le $enu

    and su!$enu at the sa$e ti$e

    TA0 or 1H2.T+TA0 &when atool!ar is active' 1elect the ne-t or previous !utton or $enu on the

    tool!ar

    CTRL+TA0 or CTRL+1H2.T+TA0

  • 7/27/2019 Keyboard Shortcuts for Excel

    17/23

    &when a tool!ar is active' 1elect the ne-t or previous tool!ar

    "TR Open the selected $enu, or perfor$ the actionassigned to the selected !utton

    1H2.T+.(< 1how a shortcut $enu

    ALT+1)AC0AR 1how the progra$ icon $enu &on the progra$ title!ar'

    #O" ARRO or ) ARRO&with the $enu or su!$enudisplayed'

    1elect the ne-t or previous co$$and on the $enuor su!$enu

    L.T ARRO or R2*HT ARRO 1elect the $enu to the left or right or, with asu!$enu visi!le, switch !etween the $ain $enuand the su!$enu

    HOM or "# 1elect the first or last co$$and on the $enu orsu!$enu

    1C Close the visi!le $enu or, with a su!$enu visi!le,close the su!$enu only

    CTRL+#O" ARRO #isplay the full set of co$$ands on a $enu

    Tip 4o! can select an& 'en! co''and on the 'en! )ar or on a isi)le tool)arwith the (e&)oard. To select the 'en! )ar, press ALT. Then to select a tool)ar,press CTRL+TAB repeatedl& !ntil &o! select the tool)ar &o! want.0 Press the!nderlined letter in the 'en! na'e that contains the co''and &o! want. 1n the'en! that appears, press the !nderlined letter in the co''and na'e that &o!want.

    Keys for windows" dialog bo#es"and edit bo#es

    Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR andthen press X. To restore the window to its preio!s si"e and location, press

    ALT+SPACEBAR and then press R. To print this topic, press ALT+# and thenpress P.This topic lists shortc!t (e&s for$%e&s for windows%e&s for dialog )o2es%e&s for edit )o2es in dialog )o2es

    Keys for windows

  • 7/27/2019 Keyboard Shortcuts for Excel

    18/23

    #n a window$ press To

    ALT+TA0 1witch to the ne-t progra$

    ALT+1H2.T+TA0 1witch to the previous progra$

    CTRL+1C 1how the indows Start$enu

    CTRL+ or CTRL+.5 Close the active work!ook window

    CTRL+.4 Restore the active work!ook window si8e

    ./ Move to the ne-t pane in a work!ook that has !eensplit

    1H2.T+./ Move to the previous pane in a work!ook that has!een split

    CTRL+./ 1witch to the ne-t work!ook window

    CTRL+1H2.T+./ 1witch to the previous work!ook window

    CTRL+.P Carry out the Moveco$$and &work!ook icon $enu,$enu !ar', or use the arrow keys to $ove the window

    CTRL+.9 Carry out the Si%eco$$and &work!ook icon $enu,$enu !ar', or use the arrow keys to si8e the window

    CTRL+.? Mini$i8e the work!ook window to an icon

    CTRL+.(< Ma-i$i8e or restore the work!ook window

    )RT1CR Copy the i$age of the screen to the Clip!oard

    ALT+)R2"T 1CR" Copy the i$age of the active window to the Clip!oard

    Ret!rn to top

    Keys for dialog bo#es

    #n a dialog ox$ press To

    TA0 Move to the ne-t option or option group

    1H2.T+TA0 Move to the previous option or option group

    CTRL+TA0 or CTRL+)A*#O"

    1witch to the ne-t ta! in a dialog !o-

    CTRL+1H2.T+TA0 orCTRL+)A* ) 1witch to the previous ta! in a dialog !o-

    Arrow keys Move !etween options in the active drop%down list!o- or !etween so$e options in a group of options

    1)AC0AR )erfor$ the action assigned to the active !utton &the!utton with the dotted outline', or select or clear the

    http://var/www/apps/conversion/tmp/scratch_6/xlhowSplitOrRemoveWindowPanes.htmhttp://var/www/apps/conversion/tmp/scratch_6/xlhowSplitOrRemoveWindowPanes.htmhttp://var/www/apps/conversion/tmp/scratch_6/xlhowSplitOrRemoveWindowPanes.htmhttp://var/www/apps/conversion/tmp/scratch_6/xlhowSplitOrRemoveWindowPanes.htm
  • 7/27/2019 Keyboard Shortcuts for Excel

    19/23

    active check !o-

    Letter key for the first letter in theoption na$e you want &when adrop%down list !o- is selected'

    Move to an option in a drop%down list !o-

    ALT+letter, where letteris the keyfor the underlined letter in theoption na$e 1elect an option, or select or clear a check !o-

    ALT+#O" ARRO Open the selected drop%down list !o-

    "TR )erfor$ the action assigned to the default co$$and!utton in the dialog !o- &the !utton with the !oldoutline \ often the O&!utton'

    1C Cancel the co$$and and close the dialog !o-

    Ret!rn to top

    Keys for edit bo#es in dialog bo#es

    #n an edit ox$ press To

    HOM Move to the !eginning of the entry

    "# Move to the end of the entry

    L.T ARRO or R2*HTARRO

    Move one character to the left or right

    CTRL+L.T ARRO Move one word to the left

    CTRL+R2*HT ARRO Move one word to the right

    1H2.T+L.T ARRO 1elect or unselect one character to the left

    1H2.T+R2*HT ARRO 1elect or unselect one character to the right

    CTRL+1H2.T+L.T ARRO 1elect or unselect one word to the left

    CTRL+1H2.T+R2*HT ARRO 1elect or unselect one word to the right

    1H2.T+HOM 1elect fro$ the insertion point to the !eginning of theentry

    1H2.T+"# 1elect fro$ the insertion point to the end of the entry

    Ret!rn to top

  • 7/27/2019 Keyboard Shortcuts for Excel

    20/23

    Keys for sing the Office %ssistant

    Press To

    .( *et Help; #isplays the Assistant !alloon if theAssistant is turned on;

    ALT+number&ALT+( is the firsttopic, ALT+7 is the second, and so on' 1elect a Help topic fro$ the list the Assistant

    displays

    ALT+#O" ARRO 1ee $ore Help topics

    ALT+) ARRO 1ee previous Help topics

    1C Close an Assistant $essage or a tip

    Keys for working with the Openand Save %s dialog bo#es

    Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR andthen press X. To restore the window to its preio!s si"e and location, press

    ALT+SPACEBAR and then press R. To print this topic, press ALT+# and thenpress P.

    Press To

    CTRL+.(7 or CTRL+O #isplay the Opendialog !o-

    ALT+.7 or .(7 or CTRL+1 1ave the active work!ook

    ALT+1H2.T+.7 or1H2.T+.(7

    #isplay the Save asdialog !o-

    ALT+(*o to the previous folder & '

    ALT+7 Open the folder up one level fro$ the open folder &'p One

    (evel!utton '

    ALT+> Close the dialog !o-, and open your orld ide e!

    search page&Searc) t)e *e!utton '

    ALT+5#elete the selected folder or file &Delete!utton '

    ALT+4 Create a new su!folder in the open folder &Create New

    http://var/www/apps/conversion/tmp/scratch_6/IDH_ofdefShowOfficeAssistant.htmhttp://var/www/apps/conversion/tmp/scratch_6/IDH_ofdefShowOfficeAssistant.htm
  • 7/27/2019 Keyboard Shortcuts for Excel

    21/23

    Folder!utton '

    ALT+/ 1witch !etween List, #etails, )roperties, and )reviewviews

    ALT+P 1how the Tools$enu &Tools!utton'

    Keys for sending e*mail messages

    To !se (e&s to send e5'ail 'essages, &o! '!st config!re 6icrosoft #!tloo( as&o!r defa!lt e5'ail progra'. 1f #!tloo( E2press is &o!r defa!lt e5'ail progra',&o! cannot !se 'ost of these (e&s to send e5'ail 'essages.Note To enlarge the Help window to fill the screen, press ALT+SPACEBAR and

    then press X. To restore the window to its preio!s si"e and location, pressALT+SPACEBAR and then press R. To print this topic, press ALT+# and thenpress P.

    Press To

    1H2.T+TA0 Move to the e%$ail $essage header; Cell A( $ust !e the active cellwhen you press these keys;

    ALT+1 1end the active spreadsheet as an e%$ail $essage

    CTRL+1H2.T+0 Open the Address 0ook

    ALT+3 Check the na$es in the To, Cc, and +cc!o-es against the Address

    0ookALT+)R2O# Open the Address 0ook in the To!o-

    ALT+C Open the Address 0ook in the Cc!o-

    ALT+0 Open the Address 0ook in the +cc!o-

    ALT+] *o to the S,!ect!o-

    ALT+) Open the Outlook Message Optionsdialog !o- &-iew$enu, Optionsco$$and in a $essage'

    CTRL+1H2.T+* Create a $essage flag

  • 7/27/2019 Keyboard Shortcuts for Excel

    22/23

    Calclation operators in formlas#perators specif& the t&pe of calc!lation that &o! want to perfor' on theele'ents of a for'!la. 6icrosoft E2cel incl!des fo!r different t&pes of calc!lationoperators$ arith'etic, co'parison, te2t, and reference.%rithmetic operators To perfor' )asic 'athe'atical operations s!ch asaddition, s!)traction, or '!ltiplication7 co')ine n!')ers7 and prod!ce n!'ericres!lts, !se the following arith'etic operators.

    "rit)metic

    operator Meaning Example

    + &plus sign' Addition >+>

    &$inus sign' 1u!traction"egation

    >((

    &asterisk' Multiplication >>

    U &forward slash' #ivision >U>

    &percent sign' )ercent 7

  • 7/27/2019 Keyboard Shortcuts for Excel

    23/23

    Comparison operators 4o! can co'pare two al!es with the followingoperators. *hen two al!es are co'pared )& !sing these operators, the res!lt isa logical al!e, either TR-E or 3ALSE.

    Comparison

    operator Meaning Example

    @ &eual sign' ual to A(@0(

    ^ &greater than sign' *reater than A(^0(

    _ &less than sign' Less than A(_0(

    ^@ &greater than or eualto sign'

    *reater than or eual to A(^@0(

    _@ &less than or eual tosign'

    Less than or eual to A(_@0(

    _^ &not eual to sign' "ot eual to A(_^0(

    Te#t concatenation operator -se the a'persand 80 to 9oin, or concatenate,one or 'ore te2t strings to prod!ce a single piece of te2t.

    Text

    operator Meaning Example

    N &a$persand' Connects, or concatenates, twovalues to produce onecontinuous te-t value

    "orth N wind produce"orthwind

    Reference operators Co')ine ranges of cells for calc!lations with thefollowing operators.

    .e/erence

    operator Meaning Example

    B &colon' Range operator, whichproduces one reference to allthe cells !etween tworeferences, including the tworeferences

    04B0(4

    , &co$$a' nion operator, whichco$!ines $ultiple referencesinto one reference

    1M&04B0(4,#4B#(4'