How To Use The IMPORTRANGE Function In Google Sheets To Transfer Data From One Sheet To Another

Since Google Sheets are files in the cloud, not on your desktop, you can’t click on a cell in a different Sheets file to connect them.

Instead, you use the IMPORTRANGE function in Google Sheets to connect Google Sheet files and import data from one Sheet file into another.

Once set up, the function will automatically sync with the source data so that changes are reflected in the destination Sheet.

IMPORTRANGE In Google Sheets

If you look closely, you’ll see a URL in the formula — the URL of the source Google Sheet file, where the data is being imported from.

Continue reading How To Use The IMPORTRANGE Function In Google Sheets To Transfer Data From One Sheet To Another

How To Copy Only Visible Cells In Google Sheets

In this post, you’ll learn how to copy only visible cells in Google Sheets so that you only paste the results you want and don’t include any hidden data.

For this tutorial, we’ll use this dataset, shown in full to begin:

Data in Google Sheets

Now suppose that columns B and C, and rows 6 – 9, are hidden so the data looks like this:

Hidden data in Google Sheets

If you just highlight this data and copy it, then when you paste it elsewhere the hidden data shows up.

So, how do you copy only visible cells?

Continue reading How To Copy Only Visible Cells In Google Sheets

How To Draw The Sierpiński Triangle In Google Sheets

The Sierpiński triangle is a fractal set in the shape of an equilateral triangle, divided into smaller triangles infinitely.

Graphically, we can draw an approximation of the Sierpiński triangle in Google Sheets:

Sierpinski Triangle In Google Sheets

🔗 Get this example and others in the template at the bottom of this article.

It is named after the Polish mathematician Wacław Sierpiński and is also known as the Sierpiński gasket or Sierpiński sieve.

It has the property of being self-similar, meaning it looks the same at any magnification.

See Wikipedia for more on the Sierpiński triangle.

Continue reading How To Draw The Sierpiński Triangle In Google Sheets

The LARGE Function In Google Sheets

The LARGE function in Google Sheets returns the n-th largest value from a dataset.

For example, you could use large to determine the 5th largest value in a dataset, the 10th largest, the 50th largest, etc.

LARGE Function In Google Sheets

The formula to find the 5th largest value in this example is:

=LARGE(A1:A10,5)

🔗 Get this example and others in the template at the bottom of this article.

Continue reading The LARGE Function In Google Sheets