How To Use Importrange on Google Sheets on PC or Mac

You can learn how to use the IMPORTRANGE function in the web version of GOOGLE SHEETS.

Step 1: You can go to sheets.google.com in a web browser.

If you aren't already signed in to your account, sign in now.

Step 2: Click the file you want to import.

This opens the file.

Step 3: Make a note of the data you want to import.

The sheets are listed at the bottom of the screen.Write down or memorize the range if you click the sheet name.A2:D11.The IMPORTRANGE formula requires this information.

Step 4: Click the menu to open it.

It is on the left side of the screen.

Step 5: Click to share.

Step 6: Click the link to share it.

The link to the spreadsheet is in the clipboard.

Step 7: Click Done.

Step 8: Click on the icon to go to the Sheets home page.

The green button is at the top left corner of the screen.Adding the link to a formula in the sheet where you want the data to appear is the next step.

Step 9: In a web browser, go to sheets.google.com.

You can skip this step if you already see a list of your files.

Step 10: Click on the file you want to see the data in.

The formula will be entered on this spreadsheet.

Step 11: The range can be seen by clicking the cell where you want it to appear.

Step 12: The type isIMPORTRANGE.

There is a list of matching functions.

Step 13: You can click IMPORTRANGE.

The cell reads "IMPORTRANGE".

Step 14: You can type a ".

Step 15: If you want to press Cmd+V, you have to use the keyboard.

The link is put into the blank.

Step 16: "Type another"

Step 17: There is a way to type a comma.

Step 18: The path to the data should be typed.

If the data in the first spreadsheet is on a sheet called Sheet1, type "Sheet1!A2:D11"

Step 19: There's a type.

You should see something like this.

Step 20: Press Enter or Return.

The data will be imported using the IMPORTRANGE formula.The data from the first spreadsheet will appear in the second.

Related Posts:

  1. How do I export Asana tasks to Google Sheets?
  2. Which is better Excel or Google Sheets?
  3. Does Google Sheets have an app?
  4. How many types of sheets are there?