Wokr Flashcards
(34 cards)
1
Q
How to select only one column on pdf
A
alt select
2
Q
insert work sheet
A
shift f11
3
Q
freeze
A
alt w f
4
Q
zoom control
A
alt v z
5
Q
Remove border
A
ctrl shift -
6
Q
Autocolor cell
A
ctrl alt e
7
Q
AutoColor sheet
A
ctrl alt s
8
Q
Vertical alignement
A
ctrl shift v
9
Q
Horizontal alignement
A
ctrl shift H
10
Q
Date spread
A
ctrl alt D
11
Q
Zoom in out
A
ctrl alt = or -
12
Q
smart transpose
A
ctrl alt T
13
Q
Formatting
A
ctrl shift +
1 = number
2 = date
4= currency
5= %
14
Q
creat newbook
A
ctrl n
15
Q
Increase decrease font
A
ctrl shift F / G
16
Q
Binary
A
ctrl shift Y
17
Q
to do touble subset
A
ctrl shift I
18
Q
Wrap
A
Ctrl shift W
19
Q
Full border
A
ctrl shift B
20
Q
border
A
ctrl alt shift and arrow
21
Q
Highlight
A
alt shift &
22
Q
Increase table size
A
ctrl alt shift f or G
23
Q
Change the case
A
alt shift C
24
Q
comment resize
A
More tools in factset / sheet formatting / comment resize
25
auto size row
alt shift page up / down
26
auto size column
alt shift ctrl page up / down
27
bookmark setup / kill
ctrl alt b or x
28
bookmaker next
ctrl alt n or p
29
you can copy past factset grpaghs
excel charting tools
30
you can add easy CAGR
modelling tool
31
Clear formatting
alt eaf
32
rename tab
alt h o r
33
Check formula
shift f3
34
Delete sheet
Alt → H → D → S
