short cut keys (all in)

8/20/2019 Short Cut Keys (All in)

http://slidepdf.com/reader/full/short-cut-keys-all-in 1/6

Word Shortcut Keys:

Manage Word Documents

Ctrl+n Create new document

Ctrl+o Open document

Ctrl+w Close documentCtrl+s Save document

F12 Save document as

Ctrl+p Print document/ print preview

Ctrl+F6 Switch between multiple Word documents

Alt then F r Open !ecent "#le recent$

Navigate within Documents

Arrow %e&t/Arrow !i'ht (ump one character to the le&t / to the ri'ht

Ctrl+Arrow %e&t/Ctrl+Arrow !i'ht (ump one word to the le&t / to the ri'ht

)nd/*ome (ump to the end o& a line / be'innin' o& a line

Arrow own/Arrow ,p (ump one line down / one line down

Ctrl+Arrow own/ Ctrl+Arrow ,p (ump one para'raph down / one para'raph up

Pa'e own/Pa'e ,p (ump one screen down/ one screen up

Alt+Ctrl+Pa'e own/ Alt+Ctrl+Pa'e ,p (ump to top / to bottom o& visible window

Ctrl+)nd/Ctrl+*ome (ump to end / to be'innin' o& documentF6 C-cle throu'h !ibbon/open panes/Status .ar/document window

Ctrl+' or F 0o to a pa'e boomar &ootnote table comment 'raphic or other location

Alt+Ctrl+ 0o bac to previousl- edited location in document "up to 3 places$

Shi&t+F 0o to a the last chan'e or revision4 Also wors a&ter openin' document4

Ctrl+Shi&t+F Set 'o to and edit boomars

Alt+Ctrl+*ome Set .rowse Options4 Press the arrow e-s to select an option and then press enter to browse throu'h a document b- usin' the selected option

Ctrl+Pa'e own/Ctrl+Pa'e ,p 5ove to net / move to previous browser ob7ect as set in .rowse OptionsDialog boxes

8ab C-cle &orward throu'h all options and elements

Shi&t+8ab C-cle bacwards throu'h all options and elements

Ctrl+8ab C-cle &orward throu'h available pa'es

Ctrl+Shi&t+8ab C-cle bacwards throu'h available pa'es

Alt+underlined letter Selects the option indicated b- the letter

Select TextShi&t+Arrow !i'ht/ Shi&t+Arrow %e&t )tend selection one character to the ri'ht / to the le&t

Ctrl+Shi&t+Arrow !i'ht/ Ctrl+Shi&t+Arrow %e&t )tend selection one word to the ri'ht / to the le&t

Shi&t+)nd/Shi&t+*ome )tend selection to the end / to be'innin' o& a line

Shi&t+Arrow own/ Shi&t+Arrow ,p )tend selection one line down / one line up

Shi&t+Pa'e own/ Shi&t+Pa'e ,p )tend selection one screen down / one screen up

Ctrl+Shi&t+)nd/ Ctrl+Shi&t+*ome )tend selection to end / to be'innin' o& document

Alt+Ctrl+Shi&t+Pa'e own/ Alt+Ctrl+Shi&t+Pa'e ,p )tend selection to end / to be'innin' o& visible window

Ctrl+a )tend selection to entire document

Arrow 9e-s Cancel selection and return to be'innin' / to end o& selection

F: 8urn )tend 5ode on; )tend selection without pressin' shi&t

Arrow e-s Pa'e up/Pa'e down )tend selection in )tended 5ode;

F: )tend selection &urther b- word para'raph document in )tended 5ode

Shi&t+F: !educe the sie o& a selection in )tended 5ode

Ctrl+Shi&t+F: and arrow e-s Select a vertical bloc o& tet in )tended 5ode)sc 8urn etend mode o<

F: )tend a selection to a speci#c location in a documentUndo, Copy and aste

Ctrl+ ,ndo the last action

Ctrl+- !edo the last action

Ctrl+c Cop- selected tet or ob7ect

Ctrl+ Cut selected tet or ob7ect

Ctrl+v Paste selected tet or ob7ect

Ctrl+Shi&t+c Cop- tet &ormat

Ctrl+Shi&t+v Paste tet &ormat

Ctrl+Alt+v Paste special

Ctrl+v then Ctrl then Paste and eep Source Formattin'

Ctrl+v then Ctrl then t Paste and eep 8et onl-

Ctrl+F= Cut to the Spie "separate clipboard$Ctrl+Shi&t+F= Paste &rom the Spie

F= Paste Auto8et " a&ter start t-pin'$

Alt+Shi&t+r Cop- the header or &ooter &rom previous section o& the document

!dit Documents

"nsert Special Characters

Alt+Ctrl+c >nsert cop-ri'ht s-mbol

Alt+Ctrl+r >nsert re'istered trademar s-mbol

Alt+Ctrl+t >nsert trademar s-mbol

Alt+Ctrl+4 "Period$ >nsert horiontal ellipsis "?$

Alt+Ctrl+@ >nsert em dash

Alt+Ctrl++B >nsert en dash

Alt then nu >nsert S-mbol "insert menu$

Or Ctrl+2 >nsert sin'le openin' Duotation mar

Ctrl+2 E >nsert sin'le closin' Duotation mar

8-pe character code and press Alt+ >nsert ,nicode character e4'4 2ac

Select character and press alt+ 8rans&orm character to ,nicode

Alt+character code on numeric e-board >nsert AGS> character

"nsert #rea$s

)nter >nsert para'raph brea

Shi&t+)nter >nsert line brea without breain' para'raph

Ctrl+)nter >nsert pa'e brea

Ctrl+Shi&t+)nter >nsert column brea "brea table$

Ctrl+Shi&t+Space >nsert nonbreain' space

Ctrl+Shi&t+@ "*-phen$ >nsert nonbreain' h-phen

Ctrl+@ >nsert optional h-phen"nsert Text !lements

Alt+Ctrl+F >nsert a &ootnote

Alt+Ctrl+d >nsert an endnote

Ctrl+ >nsert a h-perlin

Alt+Shi&t+i >nsert Citation 5ar

Alt+Shi&t+ >nsert >nde 5ar

Move and Delete Text

F2 then move to position and press )nter 5ove selected tet to di<erent position

Shi&t+F2 then move to position and press )nter Cop- selected tet to di<erent position

elete/.acspace elete one character to the ri'ht / to the le&t "or delete selection$

Ctrl+elete/Ctrl+.acspace elete one word to the ri'ht / to the le&t

elete elete one character to the ri'ht or delete selection

Ctrl+Shi&t+H/Ctrl+Shi&t+I ecrease / >ncrease &ont sie one value

%ormats

%ormat Text

Ctrl+d or Ctrl+Shi&t+ Open the Font dialo' bo

Ctrl+Shi&t+H/Ctrl+Shi&t+I ecrease / >ncrease &ont sie one value

Ctrl+/Ctrl+B ecrease / >ncrease &ont sie one pointCtrl+b Appl-/remove bold

Ctrl+i Appl-/remove italic

Ctrl+u Appl-/remove underline

Ctrl+J Appl-/remove subscript

Ctrl+Shi&t+J Appl-/remove superscript

Ctrl+Shi&t+C Cop- &ormattin'

Ctrl+Shi&t+K Paste &ormattin'

Ctrl+Shi&t+d Appl-/remove double@underline

Ctrl+Shi&t+w Appl-/remove words underline "onl- words no spaces$

Ctrl+Shi&t+h Appl-/remove hidden &ormattin'

Ctrl+Shi&t+a Appl-/remove all capitals

Ctrl+Shi&t+ Appl-/remove small capitals

Shi&t+F= Chan'e between all upper@ #rst letter upper@ and all lower@case

Ctrl+d then Alt+ and enter Appl- strie@throu'h &ormattin' "&ont dialo'$Ctrl+Shi&t+D Chan'e the selection to the S-mbol &ont

Shi&t+F1 !eveal Formattin' "show all &ormats o& selection$

Ctrl+Alt+* Appl-/remove *i'hli'ht 8et Feature%ormat aragraphs

Ctrl+r !i'ht@ali'n para'raph

Ctrl+l %e&t@ali'n para'raph

Ctrl+e Center@ali'n para'raph

Ct l 7 ( ti& li h



Word Shortcut Keys:

Alt+Ctrl+Shi&t+s Open or close St-les tas pane

Alt+Ctrl+1 Appl- *eadin' 1 st-le

Alt+Ctrl+2 Appl- *eadin' 2 st-le

Alt+Ctrl+= Appl- *eadin' = st-leAlt+Shi&t+Arrow !i'ht/ Alt+Shi&t+Arrow %e&t Promote / demote *eadin's

Ctrl+Space !emove all manual st-les

Ctrl+Shi&t+n Appl- Gormal st-le

Ctrl+Shi&t+s Open Appl- St-les tas pane "will not close with pressin' it a second time$

Alt+Ctrl+ Start Auto Format

Search and &eplace

Ctrl+h Open traditional #nd and replace window

Ctrl+h then Alt+d Open traditional #nd window

Alt+Ctrl+- or Shi&t+F3 !epeat last #nd a&ter closin' #nd window

Ctrl+8ab (ump between #nd menu and document

Alt+Space Arrow e-s and )nter 5ove #nd menu window

)sc Close traditional search window i& active

Ctrl+F Open "new$ search menu in navi'ation tas pane

Alt then w Open and close Gavi'ation pane "Kiew Gavi'ation$Manage Word 'iew

Switch 'iews

Alt+Ctrl+p Switch to Print %a-out view

Alt+Ctrl+o Switch to Outline view

Alt+Ctrl+n Switch to ra&t view "used to be normal view$

Ctrl+scroll mouse Loom in and oom out

Alt then w D Open Loom 5enu "no native shortcut eists &or oom in/ oom out$

Alt+Ctrl+s Split the document window&ibbons

Ctrl+F1 Show or hide the ribbon

F1 or alt Select item in !ibbon

)sc %eave !ibbon or Submenu

Arrow %e&t/Arrow !i'ht 5ove le&t or ri'ht between main !ibbon 5enus i& active

Arrow 9e-s 5ove le&t/ri'ht/up/down between !ibbon 5enus and Sub@5enusSpace or enter When in ribbon Open or activate selected item

Navigation ane

Alt then w Open and close Gavi'ation pane "Kiew Gavi'ation$

F6/Shi&t+F6 With Gavi'ation Pane open; Switch &orward / bacwards between "1$ Gavi'ation Pane "2$ .ottom 8asbar "=$ !ibbon and "3$ ocument

8ab/Shi&t+8ab >n Gavi'ation Pane; 5ove throu'h Gavi'ation Pane optionsTables

Navigate in Tables

Arrow own/Arrow ,p (ump one row down / one row up

8ab/Shi&t+8ab (ump to "and select$ net / previous table cell

Alt+*ome/Alt+)nd (ump to #rst column/ 7ump to last column

Alt+Pa'e ,p/Alt+Pa'e own (ump to #rst row / 7ump to last row

Ctrl+Arrow %e&t/Ctrl+Arrow !i'ht One cell to the le&t / to the ri'ht

Select Table Contents

Shi&t+)nd Select current table cell)nd then shi&t+*ome Select content o& current table cell

Press and hold shi&t and press arrow e-s repeatedl- )tend selection to ad7acent cells

Ctrl+Shi&t+F: then press )tend selection or bloc

Alt+ on numeric e-pad "with num%oc o<$ Select an entire table

Alt+Shi&t+Arrow ,p/Alt+Shi&t+Arrow own 5ove current row up or down

>n First column press shi&t+end Select rowM

>n First row press alt+Shi&t+Pa'e own Select column

Shi&t+el elete rowsM with rows selected

Shi&t+el elete columns with columns selected

Alt 7 l d r elete row at cursor

Alt 7 l d c elete column at cursor

Alt 7 l a >nsert row above cursor

Alt 7 l e >nsert row below cursor

Alt 7 l l >nsert column to the le&t o& cursor

Alt 7 l r >nsert column to the ri'ht o& cursor

Ctrl+8ab >nsert tab character

8ab in last table cell Add row at the end

M5ae sure selection etends past the last column which is number o& columns +14 Word shows the selection etended net to the last column4

(utline 'iew

Ctrl+Shi&t+o Switch to Outline Kiew

8ab/Shi&t+8ab Promote / emote a para'raph "or Alt+Shi&t+Arrow %e&t/Arrow !i'ht$

Alt+Shi&t+Arrow ,p/ Alt+Shi&t+Arrow own 5ove selected para'raphs up / down

Ctrl+Shi&t+n emote to bod- tet "set st-le to normal$

Alt+Shi&t++ / Alt+Shi&t+@ )pand / Collapse tet under a headin'

Alt+Shi&t+a )pand or collapse all tet or headin's

/ 9e- on the numeric e-pad *ide or displa- character &ormattin'

Alt+Shi&t+l Show the #rst line o& bod- tet or all bod- tetAlt+Shi&t+1 Show all headin's with the *eadin' 1 st-le

Alt+Shi&t+n Show all headin's up to *eadin' n

Ctrl+8ab >nsert a tab character

&eview Documents

FN Choose the Spellin' command "!eview tab$4

Alt+Ctrl+m >nsert a comment

Ctrl+Shi&t+e 8urn chan'e tracin' on or o<

Alt+Shi&t+c Close the !eviewin' Pane i& it is open4

Ctrl+Shi&t+M ispla- nonprintin' characters4

Alt+F1 ispla- the Selection and Kisibilit- tas pane4

Ctrl+Shi&t+' Open the Word Count dialo' bo4

rint Documents

Ctrl+p Print a document "print preview$)sc Close print preview

Arrow e-s Pa'e up /Pa'e own 5ove around the preview pa'es "with &ocus on preview pa'eM$

Ctrl+*ome/Ctrl+)nd 5ove to #rst pa'e / last pa'e "with &ocus on preview pa'e$

M)cept tabbin' there seems to be no shortcut to 7ump to preview pa'e4 Clicin' on it with the mouse is an option

%ields

Alt+Shi&t+d >nsert current date "insert A8) #eld$

Alt+Shi&t+p >nsert pa'e number "insert PA0) #eld$

Alt+Shi&t+t >nsert time "insert 8>5) #eld$

Alt+Ctrl+l >nsert %>S8G,5 #eld

Ctrl+F >nsert an empt- #eld

Ctrl+Shi&t+l >nsert a %>S8G,5 #eld

Shi&t+F Show or hide #eld code/result o& selected #eld

Alt+F Show or hide #eld codes/results o& all #elds in document

F ,pdate selected #eldsM

Alt+Shi&t+F !un 0O8O.,88OG or 5AC!O.,88OG &rom the #eld that displa-s the #eld results

F11/Shi&t+F11 0o to the net #eld/ previous #eld

Ctrl+Shi&t+FN ,pdate lined in&ormation in a 5icroso&t Word source document

Ctrl+Shi&t+F ,nlin a #eld

Ctrl+F11/Ctrl+Shi&t+F11 %oc a #eld / ,nloc a #eld

8o update all Fields select the complete document with ctrl+a then update Fields b- pressin' F$

Mail Merge

Alt+Shi&t+ Preview a mail mer'e

Alt+Shi&t+n 5er'e a document

Alt+Shi&t+m Print the mer'ed document

Alt+Shi&t+e )dit a mail@mer'e data document

Alt+Shi&t+F >nsert a mer'e #eld

Alt+Shi&t+ Preview a mail mer'eAlt+Shi&t+n 5er'e a document

Alt+Shi&t+m Print the mer'ed document

Alt+Shi&t+e )dit a mail@mer'e data document

Alt+Shi&t+F >nsert a mer'e #eld

The &est

F1 0et *elp or visit 5icroso&t Oce4com

Alt+Space Open the window menu



Excel Shortcut Keys:

Navigate "nside Wor$sheets

Arrow 9e-s 5ove one cell up down le&t or ri'ht in a worsheet4

Pa'e own/Pa'e ,p 5ove one screen down / one screen up in a worsheet4

Alt+Pa'e own/Alt+Pa'e ,p 5ove one screen to the ri'ht / to the le&t in a worsheet4 8ab/Shi&t+8ab 5ove one cell to the ri'ht / to the le&t in a worsheet4

Ctrl+Arrow 9e-s 5ove to the ed'e o& net data re'ion "cells that contains data$

*ome 5ove to the be'innin' o& a row in a worsheet4

Ctrl+*ome 5ove to the be'innin' o& a worsheet4

Ctrl+)nd 5ove to the last cell with content on a worsheet4

Ctrl+F ispla- the Find and !eplace dialo' bo "with Find selected$4

Ctrl+h ispla- the Find and !eplace dialo' bo "with !eplace selected$4

Shi&t+F3 !epeat last #nd4

Ctrl+' "or F$ ispla- the E0o 8oE dialo' bo4

Ctrl+Arrow %e&t/Ctrl+Arrow !i'ht >nside a cell; 5ove one word to the le&t / to the ri'ht4

*ome/)nd >nside a cell; 5ove to the be'innin' / to the end o& a cell entr-4

Alt+Arrow own ispla- the AutoComplete list e4'4 in cell with dropdowns or auto#lter4

)nd

Wor$ with Data Selections

Select Cells

Shi&t+Space Select the entire row4

Ctrl+Space Select the entire column4

Ctrl+Shi&t+M "asteris$ Select the current re'ion around the active cell4

Ctrl+a "or ctrl+Shi&t+spacebar$ Select the entire worsheet or the data@containin' area4 Pressin' ctrl+a a second time then selects entire worsheet4

Ctrl+Shi&t+Pa'e ,p Select the current and previous sheet in a worboo4

Ctrl+Shi&t+o Select all cells with comments4

Shi&t+Arrow 9e-s )tend the selection b- one cell4

Ctrl+Shi&t+Arrow 9e- )tend the selection to the last cell with content in row or column4

Shi&t+Pa'e own/Shi&t+Pa'e ,p )tend the selection down one screen /up one screen4

Shi&t+*ome )tend the selection to the be'innin' o& the row4

Ctrl+Shi&t+*ome )tend the selection to the be'innin' o& the worsheet4

Ctrl+Shi&t+)nd )tend the selection to the last used cell on the worsheet "lower@ri'ht corner$4Manage )ctive Selections

F: 8urn on etension o& selection with arrow e-s without havin' to eep pressin' shi&t4

Shi&t+F: Add another "ad7acent or non@ad7acent$ ran'e o& cells to the selection4 ,se arrow e-s and shi&t+arrow e-s to add to selection4

Shi&t+.acspace Select onl- the active cell when multiple cells are selected4

Ctrl+.acspace Show active cell within selection4

Ctrl+4 "period$ 5ove clocwise to the net corner o& the selection4

)nter/Shi&t+)nter 5ove active cell down / up in a selection4

8ab/Shi&t+8ab 5ove active cell ri'ht / le&t in a selection4

Ctrl+Alt+Arrow !i'ht/Ctrl+Alt+Arrow %e&t 5ove to the ri'ht / to the le&t between non@ad7acent selections "with multiple ran'es selected$4

)sc Cancel Selection4Select inside cells

Shi&t+Arrow %e&t/Shi&t+Arrow !i'ht Select or unselect one character to the le&t / to the ri'ht4

Ctrl+Shi&t+Arrow %e&t/Ctrl+Shi&t+Arrow !i'ht Select or unselect one word to the le&t / to the ri'ht4

Shi&t+*ome/Shi&t+)nd Select &rom the insertion point to the be'innin' / to the end o& the cell4"nsert and !dit Data

Undo * &edo Shortcuts

Ctrl+ ,ndo last action "multiple levels$4

Ctrl+- !edo last action "multiple levels$4

Wor$ with Clipboard

Ctrl+c Cop- contents o& selected cells4

Ctrl+ Cut contents o& selected cells4

Ctrl+v Paste content &rom clipboard into selected cell4

Ctrl+Alt+v >& data eists in clipboard; ispla- the Paste Special dialo' bo4

Ctrl+Shi&t++B >& data eists in clipboard; ispla- the >nsert dialo' bo to insert blan cells4

!dit "nside Cells

F2 )dit the active cell with cursor at end o& the line4

Alt+)nter Start a new line in the same cell4

)nter Complete a cell entr- and move down in the selection4 With multiple cells selected; #ll cell ran'e with current cell4Shi&t+)nter Complete a cell entr- and move up in the selection4

8ab/Shi&t+8ab Complete a cell entr- and move to the ri'ht / to the le&t in the selection4

)sc Cancel a cell entr-4

.acspace elete the character to the le&t o& the insertion point or delete the selection4

elete elete the character to the ri'ht o& the insertion point or delete the selection4

Ctrl+elete elete tet to the end o& the line4

Ctrl+Q "semicolon$ >nsert current date4

Ctrl+Shi&t+; "colon$ >nsert current time4

Ctrl+t Show all content as standard numbers4 "So 13;1 becomes 1342 etc &or the entire #le$ 8o undo press ctrl + t a'ain

!dit )ctive or Selected Cells

Ctrl+d Fill complete cell down "Cop- above cell$4

Ctrl+r Fill complete cell to the ri'ht "Cop- cell &rom the le&t$4

Ctrl+R Fill cell values down and edit "Cop- above cell values$4

Ctrl+E "apostrophe$ Fill cell &ormulas down and edit "Cop- above cell &ormulas$4

Ctrl+l >nsert a table "displa- Create 8able dialo' bo$4

Ctrl+@ elete Cell/!ow/Column 5enu

Ctrl+@ with row / column selected elete row / delete column4

Ctrl+Shi&t++ >nsert Cell/!ow/Column 5enu

Ctrl+Shi&t++ with row / column selected >nsert row/ insert column4

Shi&t+F2 >nsert / )dit a cell comment4

Shi&t+F1 then m elete comment4

Alt+F1 Create and insert chart with data in current ran'e as embedded Chart Ob7ect4

F11 Create and insert chart with data in current ran'e in a separate Chart sheet4

Ctrl+ >nsert a h-perlin4

)nter "in a cell with a h-perlin$ Activate a h-perlin4+ide and Show !lements

Ctrl+ *ide the selected rows4

Ctrl+Shi&t+ ,nhide an- hidden rows within the selection4

Ctrl+ "ero$ *ide the selected columns4

Ctrl+Shi&t+ "ero$ ,nhide an- hidden columns within the selectionM4

Ctrl+ "'rave accent$ Alternate between displa-in' cell values and displa-in' cell &ormulas4 Accent 'rave /not a Duotation mar4

Alt+Shi&t+Arrow !i'ht 0roup rows or columns4

Alt+Shi&t+Arrow %e&t ,n'roup rows or columns4

Ctrl+6 Alternate between hidin' and displa-in' ob7ects4

Ctrl+: ispla- or hides the outline s-mbols4

Ctrl+6 Alternate between hidin' ob7ects displa-in' ob7ects and displa-in' placeholders &or ob7ects4)dust Column Width and &ow +eight

Alt+o ca

Alt+o cw Ad7ust Columns width to speci#c value; Option Cow width

Alt+o ra Ad7ust !ow hei'ht to #t content; Option !ow Ad7ust

Alt+o re Ad7ust !ow hei'ht to speci#c value; Option !ow *ei'ht

%ormat Data%ormat Cells

Ctrl+1 Format cells dialo'4

Ctrl+b "or ctrl+2$ Appl- or remove bold &ormattin'4

Ctrl+i "or ctrl+=$ Appl- or remove italic &ormattin'4

Ctrl+u "or ctrl+3$ Appl- or remove an underline4

Ctrl+ Appl- or remove striethrou'h &ormattin'4

Ctrl+Shi&t+F ispla- the Format Cells with Fonts 8ab active4 Press tab = to 'et to &ont@sie4 ,sed to be ctrl+shi&t+p but that seems 7ust 'et to the Font 8ab in 214

Alt+E "apostrophe / sin'le Duote$ ispla- the St-le dialo' bo4Number %ormats

Ctrl+Shi&t+ Appl- the Currenc- &ormat with two decimal places4

Ctrl+Shi&t+T Appl- the 0eneral number &ormat4

Ctrl+Shi&t+U Appl- the Percenta'e &ormat with no decimal places4

Ctrl+Shi&t+V Appl- the ate &ormat with the da- month and -ear4Ctrl+Shi&t+ Appl- the 8ime &ormat with the hour and minute and indicate A454 or P454

Ctrl+Shi&t+X Appl- the Gumber &ormat with two decimal places thousands separator and minus si'n "@$ &or ne'ative values4

Ctrl+Shi&t+Y Appl- the Scienti#c number &ormat with two decimal places4

F3 !epeat last &ormattin' action; Appl- previousl- applied Cell Formattin' to a di<erent Cell)pply #orders to Cells

Ctrl+Shi&t+Z Appl- outline border &rom cell or selection

Ctrl+Shi&t+[ "underscore$ !emove outline borders &rom cell or selection

Ct l 1 th Ct l A !i ht/A % &t A b d i EF t C llE di l O b d l t d it ill h di tl th t Ct l 1

8urn E)ndE mode on4 >n )nd mode press arrow e-s to move to the net nonblan cell in the same column or row as the active cell4 From here use arrow e

move b- blocs o& data home to move to last cell or enter to move to the last cell to the ri'ht4

Ad7ust Column width to #t content4 Select complete column with Ctrl+Space #rst otherwise column ad7usts to content o& current cell$4 !emember Format Ad7ust4



Excel Shortcut Keys:

Alt+h ar Ali'n !i'ht

Alt+h ac Ali'n Center

Alt+h al Ali'n %e&t

%ormulas and Names

%ormulas

Formulas Start a &ormula4

Alt+J >nsert the AutoSum &ormula4

Shi&t+F= ispla- the >nsert Function dialo' bo4

Ctrl+a ispla- Formula Window a&ter t-pin' &ormula name4

Ctrl+Shi&t+a >nsert Ar'uments in &ormula a&ter t-pin' &ormula name4 4

Shi&t+F= >nsert a &unction into a &ormula 4

Ctrl+Shi&t+)nter )nter a &ormula as an arra- &ormula4

F3 A&ter t-pin' cell re&erence "e4'4 J)=$ maes re&erence absolute "J)3$

F Calculate all worsheets in all open worboos4

Shi&t+F Calculate the active worsheet4

Ctrl+Alt+F Calculate all worsheets in all open worboos re'ardless o& whether the- have chan'ed since the last calculation4

Ctrl+Alt+Shi&t+F !echec dependent &ormulas and then calculates all cells in all open worboos includin' cells not mared as needin' to be calculated4

Ctrl+Shi&t+u 8o''le epand or collapse &ormula bar4Ctrl+ 8o''le Show &ormula in cell instead o& values

Names

Ctrl+F= e#ne a name or dialo'4

Ctrl+Shi&t+F= Create names &rom row and column labels4

F= Paste a de#ned name into a &ormula4Manage Multipe Wor$sheets

Shi&t+F11/Alt+Shi&t+F1 >nsert a new worsheet in current worboo4

Ctrl+Pa'e own/Ctrl+Pa'e ,p 5ove to the net / previous worsheet in current worboo4

Shi&t+Ctrl+Pa'e own/Shi&t+Ctrl+Pa'e ,p Select the current and net sheet"s$ / select and previous sheet"s$4

Alt+o then h r !ename current worsheet "&ormat sheet rename$

Alt+e then l elete current worsheet ")dit delete$

Alt+e then m 5ove current worsheet ")dit move$

Manage Multiple Wor$boo$s

F6/Shi&t+F6 5ove to the net pane / previous pane in a worboo that has been split4Ctrl+F3 Close the selected worboo window4

Ctrl+n Create a new blan worboo ")cel File$

Ctrl+8ab/Ctrl+Shi&t+8ab 5ove to net / previous worboo window4

Alt+Space ispla- the Control menu &or 5ain )cel window4

Ctrl+F 5inimie current worboo window to an icon4 Also restores "Eun@maimiesE$ all worboo windows4

Ctrl+F1 5aimie or restores the selected worboo window4

Ctrl+FN 5ove Worboo Windows which are not maimied4

Ctrl+F: Per&orm sie command &or worboo windows which are not maimed4

Alt+F3 Close )cel4

'arious !xcel %eatures

Ctrl+o Open File4

Ctrl+s Save the active #le with its current #le name location and #le &ormat4

F12 ispla- the Save As dialo' bo4

F1 "or alt$ 8urn e- tips on or o<4Ctrl+p Print File "Opens print menu$4

F1 ispla- the )cel *elp tas pane4

FN ispla- the Spellin' dialo' bo4

Shi&t+FN ispla- the 8hesaurus dialo' bo4

Alt+F: ispla- the 5acro dialo' bo4

Alt+F11 Open the Kisual .asic )ditor to create 5acros4

Wor$ with the !xcel &ibbon

Ctrl+F1 5inimie or restore the !ibbon4s

Alt/F1

Shi&t+F1 ispla- the shortcut menu &or the selected command4

Space/)nter Activate the selected command or control in the !ibbon Open the selected menu or 'aller- in the !ibbon44

)nter Finish modi&-in' a value in a control in the !ibbon and move &ocus bac to the document4

F1

Data %orms

8ab/Shi&t+8ab 5ove to the net / previous #eld which can be edited4

)nter/Shi&t+)nter 5ove to the #rst #eld in the net / previous record4

Pa'e own/Pa'e ,p 5ove to the same #eld 1 records &orward / bac4

Ctrl+Pa'e own 5ove to a new record4

Ctrl+Pa'e ,p 5ove to the #rst record4

*ome/)nd 5ove to the be'innin' / end o& a #eld4ivot Tables

Arrow 9e-s Gavi'ate inside Pivot tables4

*ome/)nd Select the #rst / last visible item in the list4

Alt+c 5ove the selected #eld into the Column area4

Alt+d 5ove the selected #eld into the ata area4

Alt+l ispla- the Pivot8able Field dialo' bo4

Alt+p 5ove the selected #eld into the Pa'e area4

Alt+r 5ove the selected #eld into the !ow area4

Ctrl+Shi&t+M "asteris$ Select the entire Pivot8able report4

ispla- the list &or the current #eld in a Pivot8able report4

ispla- the list &or the current pa'e #eld in a PivotChart report4

)nter ispla- the selected item4

Space Select or clear a chec bo in the list4

Ctrl+tab ctrl+Shi&t+8ab Select the Pivot8able toolbar4

)nter then arrow down /Arrow ,p On a #eld button; select the area -ou want to move the selected #eld to4

Alt+Shi&t+Arrow !i'ht 0roup selected Pivot8able items4

Alt+Shi&t+Arrow %e&t ,n'roup selected Pivot8able items4

The &est

Dialog #oxes

Arrow 9e-s 5ove between options in the active drop@down list bo or between some options in a 'roup o& options4

Ctrl+8ab/Ctrl+Shi&t+8ab Switch to the net/ previous tab in dialo' bo4

Space >n a dialo' bo; per&orm the action &or the selected button or select/clear a chec bo4

8ab/Shi&t+8ab 5ove to the net / previous option4

A 444 5ove to an option in a drop@down list bo startin' with the letter

Alt+a 444 alt+ Select an option or select or clear a chec bo4

Alt+Arrow own Open the selected drop@down list bo4

)nter Per&orm the action assi'ned to the de&ault command button in the dialo' bo4

)sc Cancel the command and close the dialo' bo4

)uto %ilter

Alt+Arrow own On the #eld with column head displa- the AutoFilter list &or the current column 4

Arrow own/Arrow ,p Select the net item / previous item in the AutoFilter list4

Alt+Arrow ,p Close the AutoFilter list &or the current column4

*ome/)nd Select the #rst item / last item in the AutoFilter list4)nter Filter the list b- usin' the selected item in the AutoFilter list4

Ctrl + Shi&t + % Appl- #lter on selected column headin's4

Wor$ with Smart )rt -raphics

Arrow 9e-s Select elements4

)sc !emove Focus &rom Selection4

F2 )dit Selection

Select the active tab o& the !ibbon and activate the access e-s4 Press either o& these e-s a'ain to move bac to the document and cancel the access e-then arrow le&t or arrow ri'ht

0et help on the selected command or control in the !ibbon4 ">& no *elp topic is associated with the selected command the *elp table o& contents &or that pis shown instead4$

Arrow e-s to select the cell that contains the Field and then alt+Arrowown

Arrow e-s to select the pa'e Field in a PivotChart report and thenalt+Arrow own



PowerPoint Shortcut Keys:

F Start the presentation &rom the be'innin'4

G enter pa'e down arrow ri'ht arrow down or spacebar Per&orm the net animation or advance to the net slide4

P pa'e up arrow le&t arrow up or bacspace Per&orm the previous animation or return to the previous slide4

Gumber+enter 0o to slide number4

. or 4 ispla- a blan blac slide or return to the presentation &rom a blan blac slide4W or ispla- a blan white slide or return to the presentation &rom a blan white slide4

S Stop or restart an automatic presentation4

)sc or @ )nd a presentation4

) )rase on@screen annotations4

* 0o to the net slide i& the net slide is hidden4

8 Set new timin's while rehearsin'4

O ,se ori'inal timin's while rehearsin'4

5 ,se a mouse clic to advance while rehearsin'4

1+enter !eturn to the #rst slide4

Ctrl+p !edispla- hidden pointer or chan'e the pointer to a pen4

Ctrl+a !edispla- hidden pointer or chan'e the pointer to an arrow4

Ctrl+h *ide the pointer and navi'ation button immediatel-4

Ctrl+u *ide the pointer and navi'ation button in 1 seconds4

Shi&t+F1 ispla- the shortcut menu4 8ab 0o to the #rst or net h-perlin on a slide4

Shi&t+tab 0o to the last or previous h-perlin on a slide4

)nter while a h-perlin is selected Per&orm the Rmouse clicR behavior o& the selected h-perlin4

Shi&t+F Start the presentation &rom the slide -ou are currentl- on4

Wor$ with Text and (bects

Alt+shi&t+arrow le&t Promote a para'raph4

Alt+shi&t+arrow ri'ht emote a para'raph4

Alt+shi&t+arrow up 5ove selected para'raphs up4

Alt+shi&t+arrow down 5ove selected para'raphs down4

Alt+shi&t+1 Show headin' level 14

Alt+shi&t++ )pand tet below a headin'4

Alt+shi&t+@ Collapse tet below a headin'4

Shi&t+arrow ri'ht Select one character to the ri'ht4

Shi&t+arrow le&t Select one character to the le&t4Ctrl+shi&t+arrow ri'ht Select to the end o& a word4

Ctrl+shi&t+arrow le&t Select to the be'innin' o& a word4

Shi&t+arrow up Select one line up4

Shi&t+arrow down Select one line down4

)sc Select an ob7ect "with tet selected inside the ob7ect$4

8ab or shi&t+tab until the ob7ect -ou want is selected Select an ob7ect "with an ob7ect selected$4

)nter Select tet within an ob7ect "with an ob7ect selected$4

Ctrl+a "on the Slides tab$ Select all ob7ects4

Ctrl+a "in the Slide Sorter view$ Select all slides4

Ctrl+a "On the Outline tab$ Select all tet4

.acspace elete one character to the le&t4

Ctrl+bacspace elete one word to the le&t4

elete elete one character to the ri'ht4

Ctrl+delete elete one word to the ri'ht4

Ctrl+ Cut selected ob7ect4

Ctrl+c Cop- selected ob7ect4

Ctrl+v Paste cut or copied ob7ect4

Ctrl+ ,ndo the last action4

Ctrl+- !edo the last action4

Ctrl+shi&t+c Cop- &ormattin' onl-4

Ctrl+shi&t+v Paste &ormattin' onl-4

Ctrl+alt+v Paste special4

#asic Text Navigation and %ormatting

Ctrl+shi&t+F Chan'e the &ont4

Ctrl+shi&t+p Chan'e the &ont sie4

Ctrl+shi&t+Q >ncrease the &ont sie o& the selected tet4

Ctrl+shi&t+Q ecrease the &ont sie o& the selected tet4

Arrow le&t 5ove one character to the le&t4

Arrow ri'ht 5ove one character to the ri'ht4

Arrow up 5ove one line up4

Arrow down 5ove one line down4

Ctrl+arrow le&t 5ove one word to the le&t4

Ctrl+arrow ri'ht 5ove one word to the ri'ht4

)nd 5ove to the end o& a line4

*ome 5ove to the be'innin' o& a line4

Ctrl+arrow up 5ove up one para'raph4

Ctrl+arrow down 5ove down one para'raph4

Ctrl+end 5ove to the end o& a tet bo4

Ctrl+home 5ove to the be'innin' o& a tet bo4

Ctrl+enter

Shi&t+F3 !epeat the last Find action4

Ctrl+F Open the Find dialo' bo4Ctrl+h Open the !eplace dialo' bo4

Shi&t+F3 !epeat the last Find action4

8ab 5ove to the net cell in table4

Shi&t+tab 5ove to the precedin' cell in table4

Arrow down 5ove to the net row in table4

Arrow up 5ove to the precedin' row in table4

Ctrl+tab >nsert a tab in a cell in table4

)nter Start a new para'raph in table4

8ab at the end o& the last row Add a new row at the bottom o& the table in table4Change %onts and %ormatting

Ctrl+shi&t+F Open the Font dialo' bo to chan'e the &ont4

Ctrl+shi&t+p Open the Font dialo' bo to chan'e the &ont sie4

Ctrl+shi&t+Q >ncrease the &ont sie4

Ctrl+shi&t+Q ecrease the &ont sie4Ctrl+t Open the Font dialo' bo to chan'e the &ormattin' o& characters4

Shi&t+F= Chan'e the case o& letters between sentence lowercase or uppercase4

Ctrl+b Appl- bold &ormattin'4

Ctrl+u Appl- an underline4

Ctrl+i Appl- italic &ormattin'4

Ctrl+J Appl- subscript &ormattin' "automatic spacin'$4

Ctrl+shi&t++ Appl- superscript &ormattin' "automatic spacin'$4

Ctrl+spacebar !emove manual character &ormattin' such as subscript and superscript4

Ctrl+ >nsert a h-perlin4

Ctrl+shi&t+c Cop- &ormats4

Ctrl+shi&t+v Paste &ormats4

Ctrl+e Center a para'raph4

Ctrl+7 (usti&- a para'raph4

Ctrl+% %e&t ali'n a para'raph4Ctrl+r !i'ht ali'n a para'raph4

Manage (pen and Save )s dialog boxes

Alt+1 0o to the previous &older4

Alt+2 ,p One %evel button; Open the &older up one level above the open &older4

Alt+= or delete elete button; elete the selected &older or #le4

Alt+3 Create Gew Folder button; Create a new &older4

Alt+ Kiews button; Switch amon' available &older views4

Alt+% 8ools button; Show the 8ools menu4

Shi&t+F1 ispla- a shortcut menu &or a selected item such as a &older or #le4

8ab 5ove between options or areas in the dialo' bo4

F3 or alt+i Open the %oo in list4

F !e&resh the #le list4

>n 5icroso&t Oce PowerPoint move to the net title or bod- tet placeholder4 >& it is the last placeholder on a slide this will insert anew slide with the same slide la-out as the ori'inal slide4



PowerPoint Shortcut Keys:

oweroint Tas$ anes

F6 5ove a tas pane &rom another pane in the pro'ram window "clocwise direction$4 \ou ma- need to press F6 more than once

8ab shi&t+tab When a tas pane is active select the net or previous option in the tas pane respectivel-4

Ctrl+arrow down ispla- the &ull set o& commands on the tas pane menu4Arrow down or arrow up 5ove amon' choices on a selected submenuQ move amon' certain options in a 'roup o& options in a dialo' bo4

Spacebar or enter Open the selected menu or per&orm the action assi'ned to the selected button4

Shi&t+F1 Open a shortcut menuQ open a drop@down menu &or the selected 'aller- item4

*ome end When a menu or submenu is visible select the #rst or last command respectivel- on the menu or submenu4

Pa'e up pa'e down Scroll up or down in the selected 'aller- list respectivel-4

*ome end 5ove to the top or bottom o& the selected 'aller- list respectivel-4

Ctrl+spacebar c Close a tas pane4

Alt+h F o Open the Clipboard4Move around in Tables

8ab 5ove to the net cell4

Shi&t+tab 5ove to the precedin' cell4

Arrow down 5ove to the net row4

Arrow up 5ove to the precedin' row4

Ctrl+tab >nsert a tab in a cell4)nter Start a new para'raph4

8ab at the end o& the last row Add a new row at the bottom o& the table4

Alt 7 d a and then pP %aunch the Selection pane4

Manage Smart Tags

Alt+shi&t+F1

Arrow down Select the net item on a smart ta' menu4

Arrow up Select the previous item on a smart ta' menu4

)nter Per&orm the action &or the selected item on a smart ta' menu4

)sc Close the smart ta' menu or messa'e4

Microso.t (/ce basics applicable to oweroint 0112

Alt+tab Switch to the net window4

Alt+shi&t+tab Switch to the previous window4

Ctrl+w or ctrl+F3 Close the active window4Ctrl+F !estore the sie o& the active window a&ter -ou maimie it4

F6 5ove a tas pane &rom another pane in the pro'ram window "clocwise direction$4 \ou ma- need to press F6 more than once

Shi&t+F6 5ove to a pane &rom another pane in the pro'ram window "counterclocwise direction$4

Ctrl+F6 When more than one window is open switch to the net window4

Ctrl+shi&t+F6 Switch to the previous window4

Ctrl+FN

Ctrl+F:

Ctrl+F 5inimie a window to an icon "wors &or onl- some 5icroso&t Oce pro'rams$4

Ctrl+F1 5aimie or restore a selected window4

Print screen Cop- a picture o& the screen to the Clipboard4

Alt+print screen Cop- a picture o& the selected window to the Clipboard4

Wor$ with Dialog #oxes

8ab 5ove to the net option or option 'roup4

Shi&t+tab 5ove to the previous option or option 'roup4

Ctrl+tab Switch to the net tab in a dialo' bo4

Ctrl+shi&t+tab Switch to the previous tab in a dialo' bo4

Alt+arrow down Open a selected drop@down list4

First letter o& an option in a drop@down list Open the list i& it is closed and move to an option in the list4

Arrow e-s 5ove between options in an open drop@down list or between options in a 'roup o& options4

)sc Close a selected drop@down listQ cancel a command and close a dialo' bo4

Spacebar Per&orm the action assi'ned to the selected buttonQ select or clear the selected chec bo4

Alt+ the letter underlined in an option Select an optionQ select or clear a chec bo4

)nter Per&orm the action assi'ned to a de&ault button in a dialo' bo4

*ome 5ove to the be'innin' o& the entr-4

)nd 5ove to the end o& the entr-4

Arrow le&t arrow ri'ht 5ove one character to the le&t or ri'ht respectivel-4

Ctrl+arrow le&t 5ove one word to the le&t4

Ctrl+arrow ri'ht 5ove one word to the ri'ht4

Shi&t+arrow le&t Select or cancel selection one character to the le&t4

Shi&t+arrow ri'ht Select or cancel selection one character to the ri'ht4

Ctrl+shi&t+arrow le&t Select or cancel selection one word to the le&t4

Ctrl+shi&t+arrow ri'ht Select or cancel selection one word to the ri'ht4

Shi&t+home Select &rom the cursor to the be'innin' o& the entr-4

Shi&t+end Select &rom the cursor to the end o& the entr-4Wor$ with the Selection pane3

F6 C-cle the &ocus throu'h the di<erent panes4

Shi&t+F1 ispla- the contet menu4

Arrow up or arrow down 5ove the &ocus to a sin'le item or 'roup4

Arrow le&t 5ove the &ocus &rom an item in a 'roup to its parent 'roup4

Arrow ri'ht 5ove the &ocus &rom a 'roup to the #rst item in that 'roup4M "On numeric e-pad onl-$ )pand a &ocused 'roup and all its child 'roups4

+ "On numeric e-pad onl-$ )pand a &ocused 'roup4

@ "On numeric e-pad onl-$ Collapse a &ocused 'roup4

Shi&t+arrow up or shi&t+arrow down 5ove the &ocus to an item and select it4

Spacebar or enter Select a &ocused item4

Shi&t+spacebar or shi&t+enter Cancel selection o& a &ocused item4

Ctrl+shi&t+F 5ove a selected item &orward4

Ctrl+shi&t+b 5ove a selected item bacward4

Ctrl+shi&t+s Show or hide a &ocused item4

F2 !ename a &ocused item4

8ab or shi&t+tab Switch the e-board &ocus within the Selection pane between tree view and the Show All and *ide All buttons4

Alt+shi&t+1 Collapse all 'roups4

Alt+shi&t+ )pand all 'roups4

Shortcuts available with oweroint ShortcutTools )dd4inAlt + 1 Ali'n ob7ects le&t4

Alt + 2 Ali'n ob7ects center4

Alt + = Ali'n ob7ects ri'ht4

Ctrl + shi&t + = Ali'n le&t ed'e to ri'ht ed'e4

Alt + ! uplicate ob7ect to the ri'ht4

Alt + 8 >nsert tetbo4

Alt + G >nsert rectan'le4

Alt + . 5ae ob7ects same width / eDualie width4

Alt + * 5ae ob7ects same hei'ht / eDualie hei'ht4

Ctrl + = !esie/stretch ob7ect width to ri'ht ed'e4

Alt + F Select &ormat painter4

F1 Loom in ob7ect4

ispla- the menu or messa'e &or a smart ta'4 >& more than one smart ta' is present switch to the net smart ta' and displa- itsmenu or messa'e4

When a document window is not maimied per&orm the 5ove command "on the Control menu &or the window$4 ,se the arrow e-s tomove the window and when #nished press )SC4

When a document window is not maimied per&orm the Sie command "on the Control menu &or the window$4 Press the arrow e-sto resie the window and when #nished press )SC4