Subscriber only lesson.
Sign up to this course to view this lesson.
About this lesson
How to create a new Google spreadsheet and introduction to ‘file, edit, view’ options.
The exercises below will open in a new tab. When signed in to your Google account, go to File --> Make a copy to get an editable copy of the file.Google Sheets Basic Controls
Link Google Sheets Basic Controls Solution
Link Google Sheets Basic Controls Solution Template
Creating sheets and basic controls
Google Sheets is a spreadsheet editor app for organizing information.
When to use
Google Sheets has many uses, including organizing finances, scientific data, lists, and calendars.
Creating a spreadsheet with a template
- Create a new Google Sheets file
- Click the green symbol in the top left corner to open “Sheets Home”
- Click “more” in the dark area at the top of the screen
- Scroll down to see all the templates and click on the template you want to use
Cells, Rows, and Columns
- A box is called a “cell”
- A horizontal line of cells is called a “row”
- A vertical line of cells is called a “column”
- Rows have numbers and columns have letters
- Click and drag cells to select them
Changing the sizes of cells
- Click the line between two rows or columns where it displays the column letters or row numbers
- Drag the line to change the size of the row or column
- Double click the line to resize the row or column to fit the cell with the most text
- Share - Share the file
- New - Create a new file
- Open - Open a file from Google Drive
- Rename - Change the file name
- Make a copy - Make a copy of the file
- Move to - Move the file to a different folder
- Move to trash - Remove the file from Drive
- Import - Add data from another spreadsheet
- See revision history - See all changes made to the file over time
- Spreadsheet settings
- Locale: Changes format of functions, dates, currency, etc.
- Time zone: Changes time zone for all time-related functions
- Recalculation: Changes when the NOW, TODAY, RAND, and RANDBETWEEN functions are updated.
- Download as - Download the file as various file types
- Publish to the web - Make the file available to view publicly online
- Email collaborators - Email the people the file has been shared with
- Email as attachment - Send the file as an attachment to an email
- Document details - See where a file is located in Drive, who created the file, when, and when it was last edited
- Print - Print the presentation
- Undo - Undo the last action
- Redo - Undo an undo
- Cut - Cut text
- Copy - Copy text
- Paste - Paste text
- Paste special
- Paste values only: Paste text and numbers in the format of the destination cell
- Paste format only: Apply the format of the copied cell to the destination cell
- Paste all except borders: Paste text and numbers and format, but keep the borders of the destination cell
- Paste column widths only: Apply the width of the copied cell to the destination cell
- Paste formula only: Paste the formula of the copied cell to the destination cell
- Paste data validation only: Paste the data validation rules of the copied cell to the destination cell
- Paste conditional formatting only: Paste the conditional formatting rules of the copied cell to the destination cell
- Paste transpose: Paste the copied cells, but make rows into columns and columns into rows
- Find and Replace - Find text and replace it with different text
- Delete values - Delete the contents of the selected cell, but not the formatting or borders
- Delete rows - Delete selected rows
- Delete columns - Delete selected columns
- Clear notes - Delete notes made on the selected cells
Lesson notes are only available for subscribers.