Keyboard Shortcuts Flashcards
1
Q
Jump to Bottom of Data
A
Ctrl-Down Arrow
2
Q
Jump to Top of Data
A
Ctrl-Up Arrow
3
Q
Go to Previous Sheet
A
Ctrl-Page Up
4
Q
Go to Next Sheet
A
Ctrl-Page Down
5
Q
Select All Data in Column
A
Ctrl-Shift-Down Arrow
6
Q
Select Whole Column
A
Ctrl-Space
7
Q
Select All Data in Row
A
Shift-Space
8
Q
Select All Data in Region
A
Ctrl-A
9
Q
Filter
A
Ctrl-Shift-L
10
Q
Find
A
Ctrl-F
11
Q
Flash Fill
A
Ctrl-E
12
Q
Select Discontinuous Cells
A
Shift-F8
13
Q
Spell Check
A
F7
14
Q
Automatically Add Sum Totals for Columns and/or Rows
A
Alt-=
15
Q
Remove Duplicates
A
Alt-A-M
16
Q
Sort A-Z
A
Alt-A-S-A
17
Q
Sort Z-A
A
Alt-A-S-D
18
Q
Delete Row / Delete Column
A
Ctrl-minus
19
Q
Copy Selected Object or Data
A
Ctrl-D
20
Q
Format Cells
A
Ctrl-1
21
Q
Create Data Table
A
Alt-A-W-T
22
Q
Autoformat Data Tables
A
Alt-O-A
23
Q
Format As Currency
A
Ctrl-Shift-4
24
Q
Format As 2 Decimal Place Number
A
Ctrl-Shift-1
25
Paste as Value
Ctrl-Alt-V-V-Enter or Alt-E-S-V-Enter
26
Paste as Formulas
Alt-E-S-F-Enter
27
Insert Row / Insert Column
Ctrl-Shift-plus
28
Things to do with Left Click & Drag (both Row & Column)
Left Click & Drag >> Move
Shift - Left Click & Drag >> Insert
Ctrl - Shift - Left Click & Drag >> Duplicate
29
Filter by Value
Keyboard Menu -E-V
30
Cycle through Excel Instance
Ctrl-Tab or Ctrl-Shift-Tab
31
Create Table
Ctrl-T
32
Copy to the right
Ctrl-R
33
Resize object sticking to the Grid
By Pressing Alt
34
Move Object by locking one of the axis
By Pressing Shift
35
View all the formulas
Ctrl - `
36
Display All Values From Top till Previous Cell
Alt - Down Arrow
37
Save As Dialog Box
F12
38
Go to Dialog Box
F5 or Ctrl-G
Go to Special From this dialog box >> Alt - S
39
Insert Hyperlink
Ctrl - K
40
Insert Default Chart
Select The Data & Alt-F1
41
Hide Row / Column
Row = Ctrl-0
Column = Ctrl-9
42
Select Visible Cell or Check if any row/column hidden
Alt-;
43
Highlights the values which doesn't have formulas in them. The values which has formulas is not highlighted.
F5 - Alt - S - O - X
44
Open User Form To Enter Data in Table
Convert the data into Table & then:
Alt - D - O
45
Create default chart
Select the data & Alt - F1
46
Select multiple cell without pressing Ctrl Key
Shift - F8
47
Rename Sheet
Alt - H - O - R
48
Delete the sheet
Alt - H - D - S
49
Autoformatting
Alt - O - A
50
Full Screen
Alt - V - U
