Page.
înhoduchon to spreacsloet 2010, gotiog Starkd wth
komula) Funchon input ceureFeron C math operatrs anc
ce, Formahng Pinanaal
oYdors cxdors cf oparchonsimpertan cl,.
calculabors pockent lchcnge Tncrecuse decrecse perceotage
Qumer pOXMaog relhne and absoute aU rererene
copied pormwas shyush FXmatthog ye anc apps c
Shottcut keys in Spreacsheet
Prcel
Store Raw
Date
Page
formulas
Moue to praviowA Sheet
Ctrl tpa MOue to nert shoot
Ctil t up arrou key Echreme up content
Short
Ctrl tdouun arow key Pcheme douon cooent tuts
Chl t Le£t arrOw REyis Pocheme eft content
Sum (rangc) dcihicn
E min Crange)
nar (ranee) Maci mumoi Adcihon Hack
aueroge (ronge) Att t
Average
minuy Crange)
Upar iche Ke
product (roge,) Mulhpicahion Paste
E ugper (seledt content) Uppercse trtrDy
E (ower (select conkent) lousercase
propex Pomat
=cOunt(range) o count of number ce
Counta(range) ao count of non empty (e
countblank (ronge) o Countof emphy cel
Caunis (Yange, select iHem) couotcertaun ilems
Sumif (ange, vaueJ Addihon of(ecfaun iterog
Paxestaesis.
PoclooatS
NumLer Pacnkd
Divicle NumlerPadovo
Add Numle Podo
Nme Pad
Pamal teEt ofBackspace
Grealer han 2SShuett
Less ha Shiett
than eYieaual toror <E 2 characers nect to each ofher
Not S2characers nect to each cHher
Join
mares ostainedtoko maes Percentage
E Rank (Q Ki k53, KS4: K$53, o) Rank
qracle
)
Sratus
ExCEL SHORTCUT LIST
Formatting Shortcuts Function Key Shortcuts
CTRL+ 1 Format Box F2 Edit Cells
JALT +E +S+T Copy Format F4 Anchor Cells
JALT + H +0 Increase Decimal F7 Spell Check
|ALT + H +9 Decrease Decimal F12 Save As
CTRL +SHIFT +7 Boxing SHIFT + F2 Insert a Comment
|ALT +O +C+A Fit Column Width SHIFT + F8 Add to Selection
ALT +H +0 +R Change Tab Name |SHIFT +F10 Right Click
ALT + W +F (Un)Split Panes CTRL + F3 Name a Cell
ALT + W +S (Un)freeze windows Windows Flag +D Minimize Programs
SHIFT + CTRL + # Date Format
|SHIFT+ CTRL +$ $ Dollar Format
|SHIFT +CTRL +% % Percentage Format Navigation Shortcuts
JALT +"=" Sum Function Arrows Move
CTRL + Arrows Go to End of Continuous Range
SHIFT + Arrows Select ACell Range
|CTRL Shortcuts CTRL + SHIFT + Arrows Highlight AContinuous Range
CTRL + A Select AII ALT +Tab Switch Programs
|CTRL + B Bold CTRL +Pg Up/Down Switch Worksheets
CTRL+ C Copy Enter Move below
|CTRL + D Fill Down Shift +Enter Move Up
|CTRL +F Find Home Move to Beginning of Line
CTRL +I Italic CTRL + Home Go to Cell A1
|CTRL + N New Workbook ESC Cancel
|CTRL +O Open |Alt +Enter (when in a cell) Add a Line
CTRL+ P Print
JCTRL + R Fill Right
CTRL+ S Save Workbook |Columns & Rows Shortcuts
lCTRL+ U Underline Hide Row
|CTRL + 9
|CTRL +V Paste SHIFT + CTRL +9 Unhide Row
CTRL +W Close Window CTRL +0 Hide Column
|CTRL + X Cut |SHIFT +CTRL+0 Unhide Column
CTRL +Z Undo SHIFT + Spacebar Highlight Row
CTRL + Spacebar Highlight Column
SHIFT + CTRL + Plus sign Insert Blank Cells
CTRL+ Minus Sign Delete Selected Cells
|SHIFT + ALT + Left Arrow Group Rows/Columns
SHIFT +ALT +Right Arrow Ungroup
Rows/Columns
