Google Sheets steps
Neisha Coutlee
11 steps
49 seconds
Google Docs
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"
Google Sheets steps
Neisha Coutlee
11 steps
49 seconds
Google Docs
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"
