Stay on top of your projects, manage your time efficiently, and make the most of Google Sheets and Slides.
1. Manage to-do listsOverview: Manage your to-do lists with Tasks and Keep
Manage your tasks and project lists with Google Tasks and Google Keep.
Tasks is a simple way to create personal lists of daily tasks with due dates. It integrates seamlessly with Gmail and Calendar, and syncs on all your devices.
Working with a team on a project? Use Keep collaboratively with your team, from creating shared color-coded task lists to reminders that are integrated in Gmail and Calendar.
On the web
On Android devices
- Tap Play Store to open Google Play.
- Install the Tasks app.
On Apple iOS devices
Install the Tasks app for Apple iPhone or iPad.
On the web:
In your web browser, go to keep.google.com.
On mobile devices
On the web
- Choose an option:
- Click Take a note and enter a note.
- Click New List and add items to your list.
- (Optional) To add a title, click Title and enter your title.
- Click Close.
On a mobile device
- Choose an option:
- Tap Take a note and enter a note.
- Tap New List and add items to your list.
- (Optional) Add a title.
- Tap Back to save the note or list and go back to the Notes page.
Tag your Keep notes with a hashtag and label by using the "#" symbol then typing a label name. You can then search all relevant notes under that hashtag.
- Click or tap Menu Create new label.
- Enter a label name and click or tap Done.
Tip: To create a label, type #newlabel. To apply a label, type # and then select the label you want.
On the web
- Hover over the note or list and click Collaborator .
- Enter a person's name or email address. As you enter text, you get suggestions you can select.
- Next to each name, click Add collaborator to add the person.
- (Optional) To add more people, repeat steps 2–3.
- Click Save.
On a mobile device
- Tap the note or list you want to share and tap More Collaborator.
- Enter a person's name or email address. As you enter text, you get suggestions to pick from.
- Tap Save.
You can quickly create Keep notes out of existing images, texts, or data. The new note will include a link back to the source document.
- Open a Slides or Docs file.
- Select and right-click an image or text.
- Click Save to Keep.
- (Optional) Edit your note or add it to a list.
- Click Done.
Tip: You can also add a Keep note to a document. From Docs, Sheets, or Slides, open the Keep sidebar and drag the note into your document.
You can drag an email to Tasks, and it appears as a task in a list. You can then edit the task, add details, and schedule recurring or one-time reminders.
- Open Gmail and drag an email into the Tasks window. The task is the email subject.
- In the task, a link appears so you can easily reopen the message.
As a member of a room in Google Chat, you can create and manage group tasks and assign tasks to other room members. Tasks display in the room where they're created and in the assignee’s personal tasks in Google Tasks. When someone creates or updates a task, such as assigning or completing the task, a notification appears in the room.
If you can’t find the Tasks tab in a room, check back over the next few weeks as these changes roll out.
- Open Gmail.
- Select the room where you want to create a task.
- At the top, click the Tasks tabAdd room task.
You might have to expand the room to see the Tasks tab.
- Enter the task title.
- (Optional) To add a description or more details, click Add details and enter the information.
- (Optional) To add a date and time, click Add date/time, select themclick OK.
If you add a date and time to your task, you'll get notifications at the scheduled dates and times.
- (Optional) To assign the task to a member of the room, click Assignthe name of the person. To assign the task to someone who isn't a member of the room, you need to invite them to the room first.
If the assignee leaves the room, the task remains in the room and in their personal task list in Google Tasks.
- Click Add.
After you create a task, a notification displays in the room to let everyone know.
You can set deadlines for Tasks and add recurring reminders. Adding a due date also adds the task to Calendar.
- Click Add a task, and enter a task.
- Click Edit Add date/time.
- Select a date and time.
- Click Repeat and select the recurrence for the task.
- Click OK.
Note: You can also set reminders in Keep.
2. Become a spreadsheet masterAdd checkboxes to your spreadsheets
- In Sheets, open a spreadsheet and select the cells where you want checkboxes.
- Click InsertCheckbox.
- (Optional) To delete checkboxes, select the checkboxes you want to remove and press Delete.
Note: In formulas, unselected checkboxes have a value of FALSE (exclude) and selected checkboxes have a value of TRUE (include). You can see the value in the Formula bar. You can also change this value.
- Open Sheets and in a spreadsheet, highlight the range of data you want to create a chart for.
- Click InsertChart.
- (Optional) In the editor, change the chart type and other aspects.
- (Optional) In the editor, to tailor axes, styles, titles, and more, click Customize.
To learn more, see Chart and graph types.
- Open the sheet.
- At the bottom of your spreadsheet, on the sheet’s tab, click the Down arrow .
- Select Delete or Duplicate.
Change the color of tabs on a spreadsheet to quickly tell them apart.
- On a sheet tab, click the Down arrow .
- Click Change color and select a color.
- (Optional) To choose a custom color, click Custom and select a color using the sliders or by entering a color number.
You can easily remove duplicate values from your sheet, without having to write an app script or manually removing the data.
- In Sheets, open a spreadsheet.
- Select the data range that you want to remove duplicate data in.
- Click DataRemove duplicates.
- Select which columns to include and whether the data has headers.
- Click Remove duplicates.
- In the status window, click OK.
- In Sheets, open a spreadsheet and click ToolsMacrosRecord macro.
- Select the type of cell reference to use.
- Complete the task you want to record and click Save.
- Name the macro and click Save.
- Click ToolsMacrosyour macro to run the macro.
Prevent others from making changes to sheets and ranges:
- Open the sheet and click Data > Protected sheets and ranges.
- Click +Add a sheet or range.
- Click Range to protect a range of content or Sheet to protect a whole sheet.
- Click Set permissions and choose whether to show a warning or restrict who can edit the content.
- Click Done.
Hide a sheet:
- On the tab for the sheet you want to hide, click the Down arrow .
- Click Hide sheet.
Note: People with Edit access can unhide a sheet. People with View access won't see the sheet, but they can make a copy of the spreadsheet and can unhide the sheet.
To filter data in a spreadsheet for all viewers, create a filter. To create filters that don't affect anyone else's view, create filter views.
Create a filter:
- Select a range of cells.
- Click DataCreate a filter.
- Go to the top of the range and click Filter to see the filter options.
Create a filter view:
- In Google Sheets, open the spreadsheet where you want to create a filter view.
- Click a cell that has data.
- Select DataFilter viewsCreate new filter view.
- Click a drop-down list in a column header and select the data you want to filter. Your filter view is saved as you make changes.
- (Optional) To search for data, enter text in the search box.
- After you select the data to filter, click OK.
- Repeat steps 4–6 for each column you need to filter.
- In the Name box, enter a name for your filter view. If you don’t enter a name, the filter view is saved as Filter number, where number corresponds to the number of filters you’ve created.
Your saved filter view now appears in DataFilter views. Filter views have dark gray highlights in the column and row headers.
3. Give impactful, interactive presentationsCreate a presentation with Docs editors templates
Choose an option:
You can skip slides you don't want to show to others when you're presenting. People you've shared the slide with will still be able to see the slide.
- At the left, right-click the slide.
- Click Skip Slide.
- (Optional) To show a skipped slide, click Skip Slide again.
Copy text or cell formatting:
You can quickly copy the formatting of text you like to other areas.
- In a Sheet, Doc or Slide, format your text or cell the way you want it.
- Highlight the text or cell and click the paint roller icon in the top left corner.
- Click a cell or highlight text. The cell or highlighted text will pick up the same formatting.
Copy a theme to a new presentation:
You can also copy a Slides theme you like to an existing or new presentation.
- In Slides, create a new presentation. Or, if you’re modifying an existing presentation, click SlideChange theme.
- Click Import theme.
- Choose a presentation from Google Drive or choose a presentation to upload from your computer.
- Click Select.
- Choose a theme and click Import theme to apply it to your current presentation.
Add a Sheets chart to your presentation:
Add suggested content, including documents in Drive:
- In Slides, open a presentation and click Explore .
- In the Explore window, next to Search , enter your query and press Enter.
- Choose an option:
- To open a web result, under Web, click a link.
- To add an image, click Images. Hover over an image and click Add .
- To open a Drive file, click Drive and then click a file.
Create a flowchart, diagram, or other type of drawing:
- Open Google Drive.
Click NewMoreGoogle Drawings.
Use the menu options and buttons to design diagrams, paint an image, and create flowcharts and other types of drawings.
Add your drawing to a document or presentation:
- Open Drive.
- Open a saved Google drawing.
- Select the entire drawing.
- Click EditCopy.
- Open the document or slide where you want to insert the drawing.
- Click EditPaste.
Insert other types of diagrams:
- Click InsertDiagram and choose an option:
- After you select a diagram, customize it further by choosing an option at the top of the diagram window.
You can add speaker notes to presentations that only you will see when you present. People you share the presentation with will be able to see the notes. When you present your slides, your speaker notes show in a separate window.
Below the slide, click Click to add speaker notes, and add your text. If you don't see the Click to add speaker notes section, at the top, click ViewShow speaker notes.
You can use automatic captions during your presentation to display your words in real time at the bottom of the screen.
Your computer microphone needs to be on and working and you need to be using Chrome. This feature is only available in U.S. English.
Get questions from the audience:
- In Slides, at the top right corner next to Present, click the Down arrow Presenter view.
- In the pop-up, click Audience Tools.
- Click Start New.
A new short URL for the presentation shows up at the top of the slides as you're presenting. Audience members can enter the URL in their browser and ask a question. You'll see questions in the Presenter view window.
Present questions from the audience:
- In Slides, go to Audience Tools.
- Under the question you want to display, click Present.
- (Optional) To change the question, find a different question and click Present.
- (Optional) To stop showing the question that you want to display, click Hide.
Ask or vote on questions:
- In Slides, at the top of the presentation, click the link (for example, goo.gl/slides/a1b) to ask a question. Or, enter the link in a browser window.
- Click Ask a question and enter your question.
- (Optional) To submit a question anonymously, check the Ask anonymously box.
- Under a question, click Thumbs up or Thumbs down to vote on it.
- Click Submit.
Google, G Suite, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.