The fill handle can be used as a copy & paste tool. This allows you to quickly autofill the information from one cell into multiple cells.

To use the fill handle:

• Select the cell that contains the information you want to use. Look for a small square (fill handle) in the bottom-right corner of the cell.

• Hover over the fill handle, which will change it to a cross.

• Click and drag the fill handle over the cells you want to be included. 

• Release the mouse to fill the selected cells. 

The fill handle can also be used to continue a sequential series (such as numbers 1, 2, 3, and so on or days/dates.

Google sheets has a default height and width for columns and rows. 

To change the column width/row height: 

• Bring the mouse to the line between the two columns/rows, which turns the cursor into a double arrow.

• Click and drag the column/row border to the right to increase width/height or to the left to decrease width/height.

Google sheets also has an autosizing feature, which allows you to automatically fit the column's width to its content. 

• Bring the mouse to the line between the two columns, turning it into a double arrow.

• Double click the mouse, which will autosize the column to fit the text. 

• To  hide a row or column, right-click on the row number or column letter -> Hide

• To group rows/columns, select the rows or columns to include. Click Data -> Group rows or Group Columns

• To freeze header rows and columns, click View -> Freeze and choose from the options included. 

Wrapping text means ensuring all of the text fits in the column.

To wrap text:

• Select the cell(s) to wrap

• Click Format -> Wrap Text

• There is also a text-wrapping button in the top toolbar, which will resize the content.

To merge cells:

• Select the cells to merge

• Click Format -> Merge Cells

• There is also a Merge cells button in the top toolbar

Google Sheets does not allow you to press enter to create a space in a cell. To create space within a cell, press ctrl + enter. This will move the cursor to a new line within the same cell. This allows you to enter more text that goes along with that row rather than creating separate cells. 

At the bottom of the spreadsheet, you will find all of the sheets included in the spreadsheet. 

To create a new sheet:

• Click the + Add sheet button

• Another option is to click Insert -> New sheet

To rename the sheet:

• Click on the down arrow next to the sheet, then click rename.

• Rename the sheet to the name you want

There may be spreadsheets that you want people to view some sheets and edit other sheets. You can protect specific sheets within one spreadsheet. 

To protect a sheet: 

• Click on the down arrow next to the sheet.

• Click protect sheet

• A window will pop up on the side, allowing you to set permissions for specific sheets within an entire spreadsheet