back arrowAll articles

How to Add Checklists in Google Sheets

Last Updated: Tue Aug 13 2024

In 4 very easy steps, this Supatool guide will show you how to add checklists in Google Sheets.

Streamlining your workflow and keeping tasks organized will be easier once you learn this.

So let’s dive in and add checklists in Google Sheets!

Steps:

  • Open the Google Sheet.
  • Click on the desired cell.
  • Click ‘Insert’ From Navigation Menu.
  • Select ‘Checkbox’ from the drop-down menu

Step 1: Open the Google Sheet

Go to google sheets. Click on the ‘+’ icon to open a new spreadsheet.

red arrow pointing to plus icon in google sheet

Or you can open an existing Google Sheet where you want to add your checklist by using the search bar.

red arrow pointing to search bar in google sheet

Step 2: Click on the desired cell

Click on the cell where you want to add a checklist.

red arrow pointing to a cell on google sheet

Step 3: Click ‘Insert’ From Navigation Menu

On top left of Google Sheet, right under the title, you’ll see the navigation menu.

red arrow pointing to Insert option in google sheet top navigation menu

Step 4: Select ‘Checkbox’ from the drop-down menu

After you click insert, a dropdown menu will appear. Select "Checkbox" from the drop-down menu to insert the checkbox on that cell.

red arrow pointing to ‘Checkbox’ in dropdown menu

You can repeat this step for each item you want to add to the checklist.

But I’ll share a shortcut method with you.

If you want to add every item to the checklist then select the cell where you just added the checkbox.

red arrow pointing to a cell with checkbox

Now place your cursor on the round dot to the right bottom of the cell.

red arrow pointing to round dot to the right bottom of a selected cell

This time here you will see a ‘+’ icon.

red arrow points to the cursor when it has a plus shape

Double click on it. Checkboxes will automatically be placed besides every item on the left column.

red rectangle highlights the checkboxes

That’s it!

Creating a checklist in Google Sheets is a straightforward process that can significantly improve your task management and organization.

By following these steps, you can create a checklist quickly and easily.

Whether you're using it for personal tasks, team projects, or any other purpose, a well-designed checklist in Google Sheets can help ensure that all steps are completed in the correct order and nothing is overlooked.

Back

Finished!

Vector