How to copy a Google Sheet on your computer in 3 different ways

Glamorous Persona
2020-02-26T18:12:00Z
  • You can easily copy a Google Sheet into a new or existing spreadsheet with a few clicks on your desktop.
  • You can either right-click on the sheet that you'd like to duplicate or select "Edit" from the top menu bar.
  • You use basically the same method to copy a Google Sheet on either a Mac or PC.
  • Visit Business Insider's homepage for more stories.

It's easy to duplicate a Google Sheet and copy it onto a new spreadsheet or an existing one.

Google Sheets is a great way to create and share spreadsheets with friends, family, and coworkers. Depending on your project, you may find it helpful to copy a sheet onto a new or existing sheet.

Here's how to copy a Google Sheet in two ways.

Check out the products mentioned in this article:

MacBook Pro (From $1,299.99 at Best Buy)

Microsoft Surface Pro 7 (From $699.99 at Best Buy)

How to copy a Google Sheet into a new or existing Google spreadsheet

1. With a Google Sheet open, right-click on a sheet name at the bottom of the document and select "Copy" from the menu.

Copy to a new or existing spreadsheet. Marissa Perino/Business Insider

2. Select either "New spreadsheet" or "Existing spreadsheet." If you select "Existing spreadsheet," select the sheet from your Drive and then click "Select."

Copy either to an existing or new spreadsheet. Marissa Perino/Business Insider

3. Once your sheet has been copied, a pop-up will appear. Click "Open spreadsheet" to view the copied spreadsheet or the green "OK" to view it later.

Open the spreadsheet. Marissa Perino/Business Insider

How to duplicate a Google Sheet on your computer

1. Open Google Sheets on your Mac or PC and open the spreadsheet that you want to copy.

2. Right-click on a sheet name at the bottom of your document and select "Duplicate" from the pop-up menu.

Open the menu and click "Duplicate." Marissa Perino/Business Insider

3. This will immediately create a copy of the sheet, labeled as such, with all of the original contents.

A copy of your sheet. Marissa Perino/Business Insider
Apple Macbook Pro 13-Inch Display with Touch Bar Check price at Best Buy Check price at Apple Microsoft Surface Pro 7 Check price at Best Buy

 

Related coverage from How To Do Everything: Tech:

spanMarissa Perino is a former editorial intern covering executive lifestyle. She previously worked at Cold Lips in London and Creative Nonfiction in Pittsburgh. She studied journalism and communications at the University of Pittsburgh, along with creative writing. Find her on Twitter: @mlperino./span Marissa Perino Marissa Perino is a former editorial intern covering executive lifestyle. She previously worked at Cold Lips in London and Creative Nonfiction in Pittsburgh. She studied journalism and communications at the University of Pittsburgh, along with creative writing. Find her on Twitter: @mlperino. Read more Read less

Insider Inc. receives a commission when you buy through our links.

Watch: 45 ways to eat eggs

ncG1vNJzZmivp6x7o8HSoqWeq6Oeu7S1w56pZ5ufonyowcidnKxnpJqwqXvHqK5mrJ9isLC82GaYZp%2BfpLStsYysn56dpA%3D%3D