Google Sheets Tutorials

1. Select the first "cell" where you wish to enter the formula (for example, G5).

2. Enter the desired "formula" (for example, =F5*$H$14).

3. Press the "Enter" key on your keyboard. The result will display in the cell.

4. Select the cell you wish to copy (for example, G5). The "fill handle" will appear.

5. Click, hold, and drag the "fill handle" over the cells you wish to fill.

6. Release the "mouse". The formula is copied to the selected cells, and the values are calculated in each cell.

1. Move Your Cursor To Paint Bucket Symbol, Then Click

2. Move Your Cursor Down To The Color You Want The Shading To Be.

3. Next, Move Cursor To the Right Where It Has The Icon For Borders, Then Click.

4. Finally, Choose The Type Of Border Then Choose Color.

1. Highlight the cell or range of cells that you want to apply formatting rules to.

2. Click the "Format" menu and select "Conditional formatting"

3. In the window that appears, define the conditions for specific text colors and/or cell background colors.

4. Click "Save rules".

SORT

1. Highlight the group of cells you'd like to sort. To sort the entire sheet, click the top left corner of the sheet to select all cells.

2. From the Data menu, select "Sort range".

3. Check Data has header row if your columns have titles.

4. Select the column you'd like to be sorted first and whether you would like that column sorted in ascending or descending order.

5. Click "+Add another" if you'd like another sorting rule added.

6. Click "Sort" and your range will be sorted.

FILTER

1. Select the range of cells you’d like to apply the filter to.

2. From the "Data" menu, select "Filter". Alternatively, you can select the Filter toolbar icon in the toolbar.

3. The filter will be applied to your selected range of cells.

4. To help you see what cell ranges have a filter applied, the column and row labels are colored green. Additionally, the filter toolbar icon will also change to green if a filter has been applied to any column in your spreadsheet.

5. Clicking the drop down icon in the header row will give you a set of filtering options.

6. From the drop-down menu, you can uncheck the data points that you want to hide from view and check data points that you want to keep in view. Once you’ve done so and clicked "OK", the icon in the header row will change to a filter.

1. Under "Format" cells, you can choose to vertically align the text in the cell to be positioned at the top, center, bottom, or to have the text justified or distributed

1. Place your cursor at the outlying border, next to either the number or label, of the row or column you'd like to re-size.

2. Adjust your cursor so that it rests on the dividing line between the row or column you'd like to change, and the next row or column. When this is done, your cursor will turn into a double-sided arrow.

3. Left-click your mouse and drag the arrow in the direction you'd like your row or column to expand or contract.

1. Move Your Cursor To "Insert", Then Click.

2. Move Your Cursor Down To "Chart", Then Click.

3. Next, Choose The "Ranges", Then Choose The Style Of Chart.

4. Finally, Customize Your Chart The Click "Insert".

1. Move Your Cursor To "Format", Then Click.

2. Move Your Cursor Down To "Number", Then Click.

3. Finally, Move Cursor To The Right, And Then Move Courser To "Percent" Or "Currency".

1. Move Your Cursor To "Insert", Then Click.

2. Move Your Cursor Down To "Function", Then Click.

3. This Would Give You Opinions To Insert Different Formulas (Sum, Average, Count, Max, Min).

1. Move Your Cursor To A Cell, Then Click.

2. Next, Insert For Example "=(B2 + C4)" Then Click "Enter" On Keyboard.

1. Go to Insert Picture. You can select from online or upload an image you have on your computer.

2. You can also do a drawing on your Sheets and Insert over the Cells.

Text within a cell is wrapped by default in Google Sheets. If text extends past the length of the cell in your spreadsheet, it will wrap onto a second line in the cell.

If you want to turn this feature off, and allow the text to get clipped off in a cell if it's too long, click the wrap text icon in the toolbar.

To turn text wrapping back on, simply click the icon again.

1. Move Your Cursor To The Top Bottom Left Hand Corner "+", Then Click.

2. This Would Insert A New Sheet.

3. Right Click On The Tab Then Click "Delete".

1. Move Your Cursor To "Format", Then Click.

2. Move Your Cursor Down To "Number", Then Click.

3. This Would Give You Opinions To Look At Different Styles Of Inserting Decimals.

1. Highlight The Cells You Want To Merge.

2. Move Your Cursor To "Format", Then Click.

3. Move Your Cursor Down To "Merge Cells", Then Click "Merge All".

1. Move Your Cursor To The Top Left Where It Says "Untitled Sheet", Then Click.

2. Next, Rename The Document. It will automatically save

1. Move your cursor to the Bottom Left to where it says, 'Sheet1' select the DropDown menu.

2. Select 'Rename'

3. Type the name of the Sheet that you want. Press Enter.