Rows And Columns Flashcards
1
Q
Display Insert Dialog box
A
CTRL + +
2
Q
Insert selected number of rows
A
CTRL + +
3
Q
Insert selected number of columns
A
CTRL + +
4
Q
Display delete dialog box
A
CTRL + -
5
Q
Delete selected number of rows
A
CTRL + -
6
Q
Delete selected number of columns
A
CTRL + -
7
Q
Delete contents of selected cells
A
DELETE
8
Q
Hide columns
A
CTRL + 0
9
Q
Hide rows
A
CTRL + 9
10
Q
Unhide rows
A
CTRL + SHIFT + 9
11
Q
Group rows or columns (with rows/columns selected)
A
ALT + SHIFT + >
12
Q
Ungroup rows or columns (with rows/columns selected)
A
ALT + SHIFT + <
13
Q
Open Group Dialog Box (no rows/cols selected)
A
ALT + SHIFT + >
14
Q
Open Ungroup Dialog Box
A
ALT + SHIFT + <
15
Q
Hide or show outline symbols
A
CTRL + 8
