How to Use IMPORTRANGE Function to Preserve Formatting in Google Sheets Spreadsheets

In today’s article, Officehabit will introduce the IMPORTRANGE function to help you manipulate data in Google Sheets. Additionally, we will reveal how to use this function to copy a sheet while preserving the formatting. Let’s explore together.

Introduction to the IMPORTRANGE Function in Google Sheets

The IMPORTRANGE function in Google Sheets serves the purpose of importing a range of cells from a specified spreadsheet using the following formula:

=IMPORTRANGE(spreadsheet_url; range_string)

Where:

vbnetCopy codespreadsheet_url is the URL of the spreadsheet containing the data you want to import into Google Sheets.
range_string is a string specifying the range of cells to import in the format "[sheet_name!]range," for example, "Sheet1!A1:B10" or "A1:B10" where sheet_name is an optional part.

Some notes about the IMPORTRANGE function in Google Sheets:

When using the IMPORTRANGE function to import data into Google Sheets, consider the following points:

vbnetCopy codeThe Google Sheets spreadsheet must be granted permission to copy the sheet while preserving the formatting. You will be prompted to grant permission the first time a spreadsheet retrieves data from a source spreadsheet. Afterward, any editor can use the IMPORTRANGE function to retrieve data from the source spreadsheet. Access permissions will remain effective until the access-granting individual is removed from the source.
If the data range you want to import into the target spreadsheet is too large, Google Sheets may encounter errors.

How to Use the IMPORTRANGE Function to Preserve Formatting in Google Sheets

In this section, we will walk through a simple example of copying and pasting in Google Sheets. Let’s explore how to copy a sheet while preserving the formatting for a new spreadsheet.

Step 1: Duplicate the source spreadsheet by clicking on the arrow next to the spreadsheet name > Duplicate.

Step 2: Clear the content of the new Google Sheets spreadsheet.

Step 3: Use the IMPORTRANGE function for the data range you want to import to preserve the data formatting in the new spreadsheet. Enter the URL link of the source spreadsheet and the range of cells to copy into the target spreadsheet.

This way, all the data is preserved, including both values and formatting. We have completed the copy sheet while preserving the formatting.

Through today’s article, you have learned about the IMPORTRANGE function—a function for handling spreadsheet data in Google Sheets.

Leave a Comment

Your email address will not be published. Required fields are marked *

Shopping Basket
Scroll to Top