Freezing Columns and rows
1
FREEZE COLUMNS: Move your mouse to the base of the columns (grey boxes) until it turns to a "Mickey Hand". Click and drag the boarder down to the rows you want to freeze or always see when scrolling.
2
FREEZE ROWS: Move your mouse to the side of the row numbers (grey boxes) until it turns to a "Mickey Hand". Click and drag the boarder over to the Columns you want to freeze or always see when scrolling.
Rotate Text
3
Click the cell or cells you want to rotate the text in.
4
Click "Format"
5
Click whichever format you want for that text.
Size rows and columns to perfectly fit text
6
Double-click the right edge of a column. In this photo I want to resize column B; I double clicked where B and C meet. (Your mouse will look like an arrow in both directions when you are in the right spot.)
7
Voila
Select multiple cells without dragging
8
In this example, I want to select cells B2-E11. I click on B2 since it is a corner cell. Then I hold my shift key and click on E11 (opposite corner of cells I want).
9
Viola! The blue area shows everything that is selected. B2-E11
Insert Checkboxes
In this example I am inserting checkboxes to the cells I selected in the previous section but you can do this one cell, column, or row at a time.
10
Have the Cell or Cells selected where you want Checkbox, then click "Insert".
11
Select "Checkbox"
