Category Archives for Google Sheets Tips

Using IMPORTFEED in Google Sheets to Fetch Feed from URL

Fetch only the title from the feed of a website

IMPORTFEED function in Google Sheets can be used to import the RSS feed in the worksheet. This can be useful if you want to keep track of new blog posts or news items on your favorite website. For example, you can create a list of websites that you want to follow and quickly get the […]

Continue Reading >>

Using Query Function in Google Sheets – Examples

Data arranged in ascending order in Query Function in Google Sheets

QUERY function is one of the best and most useful functions in Google Sheets. When used to its full potential, it can do some really amazing things in Google Sheets. In this tutorial, I will explain the Query function and show you a lot of practical examples of how you can use it in Google […]

Continue Reading >>

Concatenate in Google Sheets – Combine Cells Using Formula

If you have content in different cells and you want to combine it, Google Sheets provide a couple of useful functions – such as CONCATENATE and JOIN. In this tutorial, I will cover examples of how to concatenate in Google Sheets. Before we jump to examples, let’s first learn about the concatenate operator and the […]

Continue Reading >>

How to Zoom In and Zoom Out in Google Sheets

One of the basic features that is missing in Google Sheets (at least at the time of writing this article) is that ability to Zoom In and Zoom Out in Google Sheets. That’s one point to the Microsoft Excel team! Now, since there is no option to zoom in Google Sheets, how can we avoid […]

Continue Reading >>

How to Quickly Transpose Data in Google Sheets

Use the Paste Transpose Option

While working with data, sometimes you may need to transpose data in Google Sheets. But you don’t need to do this manually. In this tutorial, I will show you two great ways to transpose data in Google Sheets: Using Paste Special. Using Transpose function. Transpose Data Using Paste Special Suppose you have a dataset as […]

Continue Reading >>

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 >>

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 >>