If itвЂ™s the first time youвЂ™ve imported data from that particular spreadsheet, a pop-up might appear. ThatвЂ™s important, too.ДЄfter youвЂ™ve added your IMPORTRANGE formula, you can click enter. Oh and another trick: donвЂ™t forget to add the exclamation point (!) before the data range. So for this example, the name of the original spreadsheet housing multiple datasets is called вЂњSales Revenue,вЂќ but the name of the specific tab with our data in it is called вЂњSales Revenue by Quarter.вЂќ We want to use the specific tabвЂ™s name to avoid our function breaking in the future when new sheets or tabs are created. ItвЂ™s important to note that you have to use the specific name of the tab in the sheet in the formula. =IMPORTRANGE(вЂњ','Sales Revenue by Quarter!A1:C10вЂќ) The name of the specific tab in your spreadsheet that youвЂ™re pulling information out of.The URL of the original spreadsheet (or the spreadsheet key, both options work.).The function will then ask you for three things:

Next, type =IMPORTRANGE in the cell (you can choose to use all caps or not, it doesnвЂ™t matter.). In this example, itвЂ™s named вЂњProduct Inventory.вЂќ Insert columns or rows into the spreadsheet where you want to put data.

First, click into the new spreadsheet where youвЂ™d like to add data into. Step 3: Use a Google Sheets function to port your data over. Next, before you switch to the new spreadsheet, make sure to note the range of cells where you want to pull the data from in the original spreadsheet.

Google doc merge cells