[PDF]Go Skills Microsoft Excel Shortcuts

Excel Shortcuts
Cheat Sheet


O


GENERAL EXCEL
Open
a spreadsheet y ka G 2
Create new
spreadsheet 2 3 À
Save
a spreadsheet t 3 5
Save "as" F12 | FE | ale S
Print a file + P] JE P
Close a workbook + g Ww
Open print preview + i P
Open VBA Editor ee + ial ‘ ğ m
option
GENERAL CELL CONTROL
Undo previous
«on x tz
Redo previous
action i 38 X
Copy +
selected cells . 3 C
Paste
T
clipboard content ii 3e y
Cut cell + 3 X
Display "paste
special" dialog m Ea " pa control 3 y
Dis play find
and replace dialog ü 3 Í
entire row shift space
weon ES
$ Ctrl S Space
entire column control space
Toggle the , | |
ft
autofilter a k E Sm shift F


ADDING DATA TO CELLS


Insert or edit


+
shift
alt
+


option


| return


a comment |

Insert new line at P Enter

within cell control
Edit the contents z

of the active cell


+ ia
control


Skills


PC


NAVIGATING AND SELECTING CELLS


Move to the right
edge of data range


Move to the left
edge of data range


Move to the top
edge of data range


Move to the bottom
edge of data range


Navigate to the
beginning of row


| oo
oo


E
1
t


Move to end cell + E
Show active cell +
space
ROW AND COLUMN SELECTION
Select entire om EE
spreadsheet i
Add nearby : ;
cells to selection + Click
Add any ;
cell to selection + Click
Select entire row + [Berra


Select entire
column


Cancel selection


o g


Esc


GROUP SELECTION


Extend selection
to the right


Extend selection
to the left
Extend
selection down


Extend
selection up


Extend selection
to the last right cell


Extend selection
to the last left cell


Extend selection to
the last bottom cell


Extend selection to
the last upper cell


4


}
=}
oe
oe


BEng


+
control


se +
—
+
shift


gogg


gop g


pan


gog g


A


g s E


+ =>
shift
—
ae <-
shift
+) 4
shift
qe |i
shift
+ =>
control shift
le am
control shift
+
control shift t
Cc
E
control shift


RIBBON CONTROL FORMULAS AND FUNCTIONS
Slee OC oe
+]. + R Alt +
collapse ribbon id cull all selected cells Som + ey + | i |
Add function i
Ctl fame Shift Ea A + + | A |
OPERATING WITHIN A CELL arguments soon) Snt
Enter the same Toggle formula bar + + | J + | U |
ctl -+ ‘
data in multiple coal + tenn cone ail
Insert current date EA | Mis Openname + ge l+
into a cell control A manager imaisi
Insert current time ‘ Toggle + lnis 4 [
into a cell cr i * u control u shift | + | s cell formulas gontrol
tai A JE
lyperiin lalog DOX control VI EW
DIALOG BOXES Insert rows + one |
Open macro at ES r + lire Insert columns cr ies
dialog box option i sh control x m
Delete rows GHE + -
FORMATTING TEXT AND NUMBERS control
ace å o me B ic
Cells' dialog box cenre —
Group rows
At [am Shift > 4
are Ungroup rows ‘ | |
At ES shit a <— + +
Toggle italics 36 er colunine i 3 shift l
Toggle m U
underscore R
|S) == WORKSHEETS AND WORKBOOKS
Toggle p —
strikethrough Insekt shift E FTI +] rn
. — new worksheet shift
-a | ce BE “ics
ri
. — next worksheet iii corel gon
Align content L —
Align content ——— previous worksheet control
to right R Navigate forward H 8
between workbook! control tab
Format value j 2 +/ §
as currency control shift Navigate back cu shir ES Tab D
Format value between workbook control shift tab
Ctrl = 9
as percentage i enra Id shift * ie
Format valve 4 + +| ¢# PIVOT TABLES
as date control shift
F ormat value o A ske Add pivot chart to a ES N/A
as time control shift current spreadsheet
Format value Add pivot chart
c E + + i F1
as a number control shift to new spreadsheet
Format value s T Pige
as general control shift


Q goskills


www.goskills.com