Skip to content

Organize Your Tasks in Google Sheets

Here is a great idea to help you quickly store and organize a list of tasks in a pinch.

Store Your Tasks in Google Sheets

One of the best things about Google Sheets is that it is free to use. If you have a Google account, all you have to do is navigate to your Google Drive, hit the “New” button, and select Google Sheets.

This will open up a new Google Sheets spreadsheet, and you are now ready to start listing your tasks.

Start With a Few Headings

To add clarity to your task list, it’s a great idea to type in some headings to label what type of information you plan to store in each column.

For instance, if you wanted to write down a description, due date, and priority for each task, your headings would look something like this.

It might also be a good idea to bold the headings and add a light-grey fill color to distinguish them.

Resize the Columns

The next thing to do is adjust the column widths so there will be enough space to store each type of information.

For example, task descriptions may be too long to fit in the standard 100-pixel width columns in Google Sheets. So the best thing to do would be to increase the width by perhaps a few hundred pixels.

To change the size of a column in Google Sheets, right-click on the column header and select Resize column.

You can then enter the size you want the column to be and then press Ok.

You can do the same thing in column C to make a little more room for the due date values.

List Your Tasks

The final step in storing your tasks is to type in the information. Starting with cell B2, type in the description for your first task, add a priority number, and type in the due date.

You can repeat this final step for any amount of tasks that need to be stored or listed.

Sort and Organize Your Tasks

Now that you have all your tasks listed in a Google Sheets spreadsheet, they are available for you to access from almost any location.

However, the benefits do not stop there.

Storing your tasks in a spreadsheet makes it easy to organize your task list.

Add a Filter to Your Task List

To really enhance the power of your task list, start by adding a Google Sheets filter.

You can add a filter by selecting the range that contains your list (including the headings) and then by going to Data > Create Filter.

A green border is drawn around your task list indicating that a filter has been added.

Use the Filter to Sort Your Tasks

Now that you’ve added a filter, you can easily sort your task list.

Just click on the filter button next to the heading in the column you wish to sort by, and select Sort A → Z or Sort Z → A.

For instance, if you want to sort your task list by the due date, click on the filter button and select Sort A → Z.

Filter Your Task List by Priority

You can also use the filter to change the view of your task list so that you only see certain tasks.

For example, if you only wanted to view your priority one tasks, you could click on the filter button, click on Clear, and then select the number 1.

Once you click on Ok, the filter modifies your task list showing only your priority one tasks.

And that about sums up how you can use Google Sheets to quickly store and organize your tasks in a pinch. Also, if you want to learn more about the Google Sheets filter feature, check out our post, Create a Filter in Google Sheets.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top