How to Automate Repetitive Tasks in Google Sheets With Macros

Advertisement

Record a task, save that task, and run the task whenever you want.

Macros are finally available to Google Sheets users. Macros allow you to automate repetitive tasks in documents and spreadsheets without having to learn to write code.

They have been a core productivity tool in Microsoft Office for a long time. Excel users have long been able to use macros to save time and now you can bring the same time-saving benefits to Google Sheets.

While Google Sheets has long allowed users to write their own Apps Script functions, macros open up this kind of functionality to all Google Sheets users—no […]

4 Ways to Find the Best Google Sheets Templates

Advertisement

When it comes to creating a spreadsheet, one of the best ways to start is with a template. Whether it’s for a family budget, company invoice, or academic calendar, a template gives you the foundation for your data.

If you use Microsoft Excel, then you probably already know that websites with templates

3 Excellent Sites to Get Free Document Templates
[…]

How to Automatically Log Your Daily Life to Google Sheets

Life can blind us with its routine. Let’s turn to Google and open up new opportunities to improve your life? The simple act of life logging with Google Sheets can uncover details which often go unnoticed. You don’t have to sweat because you can do it automatically. There’s no special knowledge required.

In this article, we’re going to cover five specific examples of how a daily log of your life activities can be used to identify opportunities. These might uncover opportunities to improve your health, saving money, or even your relationships.

The examples used here require only simple Google Script code to […]

How to Insert a Checkbox in Google Sheets

Why is the humble checklist such a powerful tool? Well, it helps you keep track of anything—step-by-step or even as a random to-do list. Also, it is so simple to create. If you love checklists, then you will like the news that it is just as easy to insert a checkbox (or a “tick box”) in Google Sheets.

How to Insert a Checkbox in Google Sheets

Until now, to insert a checkbox in Google Sheets, you had to use the CHAR function and a number associated with the special character resembling a checkbox. This older process is complicated for something as simple as a checkbox, so […]

How to Use Google Sheets to Keep Every Part of Your Life Organized

You don’t need shiny new apps and websites if you’re looking to get your life organized. All you need is the trusty spreadsheet. With Google Sheet’s sharing capabilities and some solid, easy-to-use templates, you can stay on top of your budget, schedule, to-do list, and more.

Why Google Sheets?

While you can easily use Microsoft Excel to manage your life, there are several good reasons to use Google Sheets.

You can share and collaborate: By its very nature, Google Drive is all about sharing. Whether you’re using Google Sheets for personal or work purposes, you can easily share everything with your family or […]

How to Insert Special Symbols and Characters in a Google Spreadsheet

From copyright symbols to plain checkmarks, special characters are needed now and then. So, you may be surprised to know that Google Sheets has no way to insert a special character in its menu.

But there are two workarounds that will help you jump the hurdle and work better on Google Drive

10 Google Docs Tips that Take Seconds & […]