Google Sheets IMPORTRANGE: Prevent clever editors from accessing other ranges of your imported sheet

Note! This is part of a series on using IMPORTRANGE in Google Sheets. If you don’t know how to use IMPORTRANGE or what it is, I encourage you to head back to the first tutorial here:

Importing Range Data From One Google Sheet to Another

And here is a link to the sample data that I am importing if you want to play along:

Template – Project Tasks (IMPORTRANGE)

You’ve grabbed data from a source Google Sheet and used the IMPORTRANGE function to insert it into your destination sheet carefully selecting the range and sheet tab of the data that you want to display.

So you might be thinking, Great! I’ve managed to only display the content from my original Google Sheet that I want my users to see and hidden the rest from them. 

While this may be the case if you are only providing ‘View’ or ‘Comment’ permission to a Google Sheet, I do have an ugly little surprise for you if you.

via GIPHY

Are you sitting down? Are you comfortable? Do you have a support network nearby?

Let’s have a look at the IMPORTRANGE docs:

IMPORTRANGE editors can access other parts of the original Google Sheet - What to do
Click to Expand!

So basically, if you have other editors on your new sheet editing your document, they can access anything in the imported Google Sheet by copying the access granted IMPORTRANGE. All they need to do is change the Sheet tab and the range location.

Continue reading “Google Sheets IMPORTRANGE: Prevent clever editors from accessing other ranges of your imported sheet”

Google Sheets Beginners: Grouping Rows and Columns (36)

When your Google Sheet spreadsheet starts to grow in complexity it is often a good idea to group similar parts of your data so you can easily collapse and expand them as you need them. Fortunately, Google Sheets has your back with the Grouping tool.

In this tutorial, we will look at how to group rows and columns in Google Sheets. We’ll also look at a few advanced capabilities and show you how to avoid some common traps.

Check it out!

This tutorial covers:

  1. 00:00 Intro
  2. 00:28 Example of grouped data
  3. 01:44 How column and row groupings work.
  4. 02:52 How to create groupings in Google Sheets
  5. 02:59 Grouping columns
  6. 04:03 Grouping adjacent columns and rows
  7. 05:13 undo grouping
  8. 05:38 Grouping rows
  9. 06:27 Sub or secondary groupings.

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

Google Sheets Beginners – Change Your Current Workbook’s Timezone Date & Currency (16)

Google Sheets

As we increasingly start to work from home and work with clients globally, it is vital that we prepare our Google Sheet for the country that our users and clients are from.

In this tutorial, we will cover how to quickly change your current Google Sheet’s timezone, date and currency for the entire document.

In this tutorial, I’ll cover,

Continue reading “Google Sheets Beginners – Change Your Current Workbook’s Timezone Date & Currency (16)”

Google Sheets Beginners: Insert Columns and Rows (12)

Google Sheets: Insert and Shift Columns and Row

Even if you are a veteran Google Sheets users you might find a great little tip in this tutorial.

Here we will cover how to insert columns and rows in Google Sheets spreadsheets. Oh, and how to cheat at connect 4.

In this tutorial, I’ll cover,

  1. Inserting columns and sheets from the menu bar.
  2. Insert columns and sheets by right-clicking cells and row and columns references.
  3. Inserting multiple columns and rows at one time.
  4. Shifting a cell set up, down left and right by one or many cells.

 

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

Google Sheets Beginners: Freeze Rows and Columns(11)

Google Sheets: Freeze

Have you ever wanted to lock those pesky rows of headers or columns so that when you scroll the titles are still there? In Google Sheets, this is done easily.

You can either got to View > Freeze and select your preferred depth of freeze. Or you can do my favourite approach, click and drag that thick line just above and to the left of cell A1 and drag it to your preferred location.

Easy as that.

Check out the video tutorial below for more tricks on using Freeze in Google Sheets. It will cover:

  1. What Freeze does in a Google Sheets spreadsheet.
  2. How to freeze single or multiple columns and rows by using the menu bar.
  3. How to freeze using right-click on columns and cells.
  4. Some common issues you may face with freeze.

 

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

%d bloggers like this: