Wokr

Question 1

How to select only one column on pdf

Answer 1

alt select

Question 2

insert work sheet

Answer 2

shift f11

Question 3

freeze

Answer 3

alt w f

Question 4

zoom control

Answer 4

alt v z

Question 5

Remove border

Answer 5

ctrl shift -

Question 6

Autocolor cell

Answer 6

ctrl alt e

Question 7

AutoColor sheet

Answer 7

ctrl alt s

Question 8

Vertical alignement

Answer 8

ctrl shift v

Question 9

Horizontal alignement

Answer 9

ctrl shift H

Question 10

Date spread

Answer 10

ctrl alt D

Question 11

Zoom in out

Answer 11

ctrl alt = or -

Question 12

smart transpose

Answer 12

ctrl alt T

Question 13

Formatting

Answer 13

ctrl shift +
1 = number
2 = date
4= currency
5= %

Question 14

creat newbook

Answer 14

ctrl n

Question 15

Increase decrease font

Answer 15

ctrl shift F / G

Question 16

Binary

Answer 16

ctrl shift Y

Question 17

to do touble subset

Answer 17

ctrl shift I

Question 18

Wrap

Answer 18

Ctrl shift W

Question 19

Full border

Answer 19

ctrl shift B

Question 20

border

Answer 20

ctrl alt shift and arrow

Question 21

Highlight

Answer 21

alt shift &

Question 22

Increase table size

Answer 22

ctrl alt shift f or G

Question 23

Change the case

Answer 23

alt shift C

Question 24

comment resize

Answer 24

More tools in factset / sheet formatting / comment resize

Question 25

auto size row

Answer 25

alt shift page up / down

Question 26

auto size column

Answer 26

alt shift ctrl page up / down

Question 27

bookmark setup / kill

Answer 27

ctrl alt b or x

Question 28

bookmaker next

Answer 28

ctrl alt n or p

Question 29

you can copy past factset grpaghs

Answer 29

excel charting tools

Question 30

you can add easy CAGR

Answer 30

modelling tool

Question 31

Clear formatting

Answer 31

alt eaf

Question 32

rename tab

Answer 32

alt h o r

Question 33

Check formula

Answer 33

shift f3

Question 34

Delete sheet

Answer 34

Alt → H → D → S