Excel Flashcards
1
Q
Change links in sheet (e.g. when copying a sheet from another file)
A
- Data > Queries and Connections > Workbook Links
- Select More Commands (…) next to the required workbook > select Change source
- e.g. link the Excel file to itself
2
Q
Access settings
A
Alt + T + O
3
Q
Format as number
A
Shift + CTRL + !
4
Q
Hide whole Excel file
A
Alt + W + H
4
Q
Format as date
A
CTRL #
5
Q
Preferred way to hide columns/rows
A
Grouping
6
Q
Create group
A
Shift + Alt + Left/Right Arrow
7
Q
Copy right
A
CTRL + R
8
Q
Copy down
A
CTRL + D
9
Q
To copy data from a PDF
A
Use Adobe, hold down ALT, then select with box data, then copy paste
10
Q
Shift cells around, e.g. push all cells down or up
A
CTRL + “+” or CTRL + “-“
11
Q
Select e.g. all hardcoded numbers from a couple of cells
A
F5 + Special
12
Q
blue that banks use?
A
00255
13
Q
The shortcut to re-calculate all formulae in the current workbook is
A
F9
14
Q
Keyboard shortcut to save as is …
A
F12
