How to Fill Down in Google Sheets Using Fill Handle

Cursor changes to plus icon when you hover on the fill handle

Fill handle in Google Sheets can save you a lot of time when doing data entry or working with data. It works by recognizing a pattern and then allows you to quickly use the pattern to fill down the data. For example, suppose you have 1 in cell A1 and 2 in cell A2, you […]

Continue Reading >>

Calendar Template in Google Sheets (Monthly and Yearly)

You can easily create a simple static calendar template in Google Sheets. However, you would need to update it every time the month or the year changes. To save you some time (and using the power of Google Sheets), I have created a template that would automatically update the calendar when you change the month […]

Continue Reading >>

How to Get the Word Count in Google Docs [in less than 5 seconds]

Google Docs is an amazing word processor tool that allows you to write from anywhere or from any device. I write all my blog posts in Google docs and then move it to WordPress later. Using Google Docs means that I can write using my mobile phone when I am traveling, in a coffee shop, […]

Continue Reading >>

The Ultimate Guide to Google Sheets VLOOKUP Function (with Examples)

Google Sheets VLOOKUP function can be used to look for a value in a column and when that value is found, return a value from the same row from a specified column. Now if that description sounds nerdy and difficult, here is another way to understand what this function does. Suppose you have gone to […]

Continue Reading >>

Named Ranges in Google Sheets – All You Need to Know

Named Ranges Option in the Data Drop Down

Named Ranges in Google Sheets can be used to define a cell or a range of cells and give it a name. Now, instead of using the cell references, you can use the name of the named range in calculations. For example, suppose I have sales transaction data for a store, and I need to calculate […]

Continue Reading >>

How to Quickly Insert Multiple Rows in Google Sheets

5 new rows inserted in Google Sheets

What do you do when you want to insert multiple rows in Google Sheets? Do you insert one row at a time? While this can be a valid way to do this, it is time-consuming and inefficient. Let me show you a faster way to insert multiple rows in Google Sheets. Suppose you have a […]

Continue Reading >>

How to Rotate Text in Google Sheets (in less than 5 seconds)

Rotate Text in Google Sheets

Google Sheets has some great data formatting tools. One such formatting feature is the ability to rotate text within a cell in Google Sheets. Something as shown below: Here are the two ways you can rotate text in Google Sheets: Using the Toolbar Using the Format Options Using the Toolbar Here are the steps to rotate […]

Continue Reading >>

How to Count Cells If Not Blank in Google Sheets

Count Cells If Not Blank in Google Sheets - Countif

Sometimes you may have a dataset where some of the cells or rows are blank. In such a case, if you want to count cells that are not blank, then you need to rely on Google Sheets count functions. In this tutorial, I will show you how to count cells if not blank in Google […]

Continue Reading >>

How to Quickly Apply Strike-through Format in Google Docs

Apply Strike-through format in Google Docs - Format

The strike-through format is useful when you want to mark some task or activities as complete. It can also be useful if you’re reviewing someone’s work and want to change something without completely removing it. Strike-through Format in Google Docs If you’re working with Google Docs, here are the ways you can quickly apply the strike-through […]

Continue Reading >>

How to Print Google Calendar [Explained Step-by-Step]

How to Print Google Calendar - Print

While most of us access calendars through our smartphones, sometimes you may want to print Google Calendar and have it as a hard copy. This could be useful if you’re traveling or when your phone battery acts unreliable. In this tutorial, I will show you how to quickly print your Google Calendar. Steps to Print Google […]

Continue Reading >>