Learning how to link a specific sheet in Google Sheets is useful to share specific sheets with other users without compromising the whole Google Sheets file.
The beauty of using Google Sheets is the ability to share sheets or work collaboratively among many people. It is convenient and accountable as it has the function to track all changes made in the sheet.
Google Sheet is used globally by all ages, from students to working adults. Having the skill to navigate and master the functionality of Google Sheets is vital. Sometimes, you may have several Google Sheets or tabs and want to link a specific sheet for use of reference.
Here are some tips and tricks to easily link to a specific sheet in Google Sheets!
You may make a copy of the spreadsheet using the link I have attached below.
Table of Contents
Copy and Paste Link of Specific Sheet
The simplest way is to copy and paste the specific link of the Google Sheet or tab. You can either copy the URL from the top of your browser window or through the share button.
For example, you are planning to attract more capital for your business. Potential investors have requested some business information to better understand your company.
However, all the information is scattered in different tabs and even in different Google Sheets files.
By linking to a specific sheet in Google Sheets, we can create a table of content to link all the main information into one tab for clarity. This way, potential investors can view different aspects of your company in an organized manner.
- The easiest way is to copy the URL from the top of your browser window.
- The great thing about this is that the URL would be specific to it, whichever tab in a Google Sheets.
- Another way to copy the specific link would be through the Share button.
- You can copy the link from the Get Link section by clicking Copy.
- Using this method, you can restrict the person with the link to only view the Google Sheets file or tab without editing it.
- Once the content tab is done, all the important tabs or Google Sheets are linked. Now, potential investors can easily access specific sheets from one tab.
Some of you may feel that the sheet looks messy with tons of links on the preview. Here is a beautified way to link specific sheets in Google Sheets.
- First, right-click on the desired cell, and click Insert Link.
- Once clicked, a pop-up box would appear. Insert the word you want the cell to show and paste the specific sheet link.
- Once you click Apply, it would appear like this:
This way, the spreadsheet looks cleaner and more professional with no exposing links shown.
Import Data from Specific Sheet Into New Google Sheets
Imagine that you have a business idea and plan to get a loan from the bank. The banker has requested a detailed business plan for them to peruse. A business plan will help them decide if the business idea is viable and able to get back repayment for the loan given.
Your business information is usually scattered in different tabs and Google Sheets files. Moreover, you want to compile all the information into one business plan proposal using Google Sheet.
Instead of only inserting a link or linking the cell to a specific sheet, we can import the data in the specific sheet into a new Google Sheets.
We will be using the
IMPORTRANGE function to make this happen. What this function does is it copies data from one spreadsheet to another. You may wonder, what is the difference with manually copying the data into a new Google Sheets then?
The beauty of using the
IMPORTRANGE function is that the function will copy any changes made in the original spreadsheet. Hence, there is no need to constantly copy the data into the sheet whenever there are updates.
If you are not familiar with the
IMPORTRANGE function, don’t hesitate to check out the anatomy of the function and other examples of how to use it!
- First, we select the cell we want to input the function in. In this case, it is C13.
- Begin your function with an equal sign
=, followed by the name of the function,
IMPORTRANGE, then an open parenthesis
- Now, we will open and close with quote signs
", within would be the link to the specific sheet.
- Right after the quote symbol
", add a comma
,followed by a quote sign
- Add the range string that you want to copy. It should look like this,
'Projected Revenue'!A1:H10. This means that we will be importing the data from a sheet named Projected Revenue that covers cells A1 to H10.
- Add a quote sign
"again followed by a closing parenthesis
)and hit enter.
- Your sheet will look like this:
Do note that the cells are just imported with data. The font size, borders, and other elements will not or might not be copied. Also, the imported data will use the default settings of the new spreadsheet.
Hence, we can spruce up the data by bolding the headers or adding lines to the cells.
How to Protect and Hide Specific Sheets
As you are already aware, by sharing links to specific sheets or using the
IMPORTRANGE function, our original sheet’s URL is exposed.
This means that other important data within the specified sheet would also be shared or viewed with others. Besides, viewers can also edit the original Google Sheets if the tabs or cells are not protected using the Protect Sheet Tool.
It is crucial to learn how to safeguard our Google Sheets and data through these three methods.
There you go! Two different ways to link a specific sheet in Google Sheets to bring you convenience!
Don’t forget to check out other cool functions in Google Sheets to enhance and simplify work for your everyday use!