Grid Flashcards
group selected rows/columns OR display “group” dialog box
Alt + A + G + G
hide grouped rows/columns
Alt + A + H
show grouped rows/columns
Alt + A + J
ungroup selected rows/columns OR display “ungroup” dialog box
Alt + A + U + U
merge and center cells
Alt + H + M + C
wrap text
Alt + H + W
delete selected rows/columns OR display the “delete” dialog box
Ctrl + -
delete worksheet rows
Alt + H + D + R
delete worksheet columns
Alt + H + D + C
delete table rows
Alt + H + D + L
delete table columns
Alt + H + D + M
display the “row height” dialog box
Alt + H + O + H
autofit row height
Alt + H + O + A
display the “column width” dialog box
Alt + H + O + W
autofit column width
Alt + H + O + I
display the “standard width” dialog box to change the default column width
Alt + H + O + D
lock active cells
Alt + H + O + L
hide active columns
Ctrl + 0
alternate between hiding/displaying outline symbols for grouped rows/columns
Ctrl + 8
hide active rows
Ctrl + 9
insert rows/columns above/to the left of the selected row/column OR display the “insert” dialog box
Ctrl + Shift + +
insert table rows above the active cell
Alt + H + I + A
insert table columns to the left of the active cell
Alt + H + I + L
insert worksheet rows above the active cell
Alt + H + I + R
insert worksheet columns to the left of the active cell
Alt + H + I + C
unhide any hidden columns within selection
Ctrl + Shift + 0
unhide any hidden rows within selection
Ctrl + Shift + 9