How to Copy a Worksheet in Excel In 6 Easy Methods

How to Copy a Worksheet in Excel In 6 Easy Methods

February 5, 2024
0 Comments

Make a copy of an excel sheet Microsoft Excel, which is part of the Microsoft 365 suite of products, is extensively used and has evolved into an indispensable tool for everyday data management and analysis. You’ve probably worked with Excel files at some point in your life, whether you’re a student, a professional, or a business owner. 

There may be times when you need to duplicate an Excel file:

  • You want to keep the original data while changing it.
  • Give a colleague a copy without changing the original file.
  • In case of computer problems, save the Excel workbook to a different location.

Whatever the reason, knowing how to replicate an Excel file is an important skill that can save you time and effort. In this post, we will look at numerous methods on how to make a copy of an excel sheet on both Windows and macOS systems, ensuring that your data is safe and accessible. In addition, we’ll demonstrate how to make a copy of an Excel worksheet.

How make a copy of an excel sheet In 6 Easy Methods

How to Make a Copy of An Excel File on Windows PC (3 Tips)

If you are using a Windows computer or laptop, then there are three available ways to assist you in saving Excel workbook copies. Here is a brief comparison.

 Copy and PasteSave As
Operation methodManuallyManuallyAutomatically
Copy speedModerateSlowQuick
Suitable forCopy a single file or multiple filesOne file at a timeCopy a single file or copy files in bulk

Tip 1. Copy and Paste Excel Workbook to Duplicate Excel File

Tag: the most straightforward way to copy Excel files, no need to open Excel app

Step 1. Open File Explorer on your Windows computer and locate to the Excel file you want to copy.

Step 2. Right-click the Excel workbook, and choose Copy.  You can also select multiple Excel files at a time and hold your mouse cursor on them to right-click. (Or, you can simply press the shortcut “Ctrl + C“.)

Step 3. Navigate to the folder or drive where you want to save the Excel copies.

Step 4. Right-click on any black place, and select Paste. (Or, you can simply press the shortcut “Ctrl + V“.)

Tip 2. Save a Copy of the Excel File via Save As

Tag: copy the file within the Excel app, copy only one file at a time

Step 1. Open the Excel file you want to copy.

Step 2. Select File in the top-left corner > Save As.

Step 3. Choose a location to save Excel copy. It can be saved to a cloud service like OneDrive, an external hard drive, or any place on your computer. 

Tip 3. Automatically Copy Excel with EaseUS Todo Backup

Tag: automatically save Excel files to any location at the set time, save workbooks in bulk at one time

If you want to save time and don’t want to save copies manually each time after changing, then  is the best choice. It is a free and professional file auto backup software that can satisfy your needs to back up and save Excel, Word, and PowerPoint files to the designated location automatically when you set a scheduled backup time point.

  • how to make a copy of an excel sheet in 2024
  • how to make a copy of an excel sheet on phone
  • how to make a copy of an excel sheet on windows
  • how to make a copy of an excel sheet mac

Secure Download

Follow the steps to set up a way to copy Excel files once and for all.

Step 1. To initiate a backup, click the Select backup contents option.

Step 2. There are four data backup categories, File, Disk, OS, and Mail, click File.

Step 3. On the left, both local and network files will be shown. You may extend the directory to pick the backup files.

Step 4. Follow the on-screen instructions and choose a location to store the backup.

Click Options to encrypt the backup with a password in Backup Options, then click Backup Scheme to specify the backup schedule and start the backup at a certain event. There are also other additional choices you may choose to tailor the backup process to your requirements.

Step 5. The backup may be stored on a local disk, EaseUS’ online service, or NAS.

Step 6. EaseUS Todo Backup enables customers to back up data to a third-party cloud drive as well as its own cloud drive.

If you want to back up data to a cloud drive provided by a third party, choose Local Drive, scroll down to add Cloud Device, and then add and log in to your account.
You can also choose the EaseUS cloud drive. Sign up for an EaseUS Account, then click EaseUS Cloud and log in.

Step 7. Click Backup Now to begin the backup process. The backup job will be presented as a card on the left side of the panel after it has been finished. Right-click the backup job to handle it further.

How to Make a Copy of An Excel File on macOS PC (3 Tips)

MacOS computers are different from Windows, so they adopt different solutions to save a copy of an Excel file. 

Tip 1. Copy and Paste

This method is the same as Windows copy and paste, but you need to find the Excel files in Mac Finder.

Step 1. Open Finder on your Mac, and navigate to the Excel file you want to copy.

Step 2. Select the file and press Command + C to copy it.

Step 3. Locate to the destination folder, right-click, and select Paste Item. Rr press Command + V to paste the copied file.

Tip 2. Duplicate

Step 1. Open Finder and locate the Excel file.

Step 2. Right-click on the file and select Duplicate from the dropdown menu.

Step 3. A duplicate file will be created in the same folder with the suffix copy added to the file name. You can move the copied file or rename it.

Tip 3. Drap and Drop With The Option Key

Step 1. Open Finder and find the Excel file.

Step 2. Click and hold the Option key on your keyboard.

Step 3. While holding the Option key, drag the file to the desired destination folder.

Step 4. Release the Option key, and the file will be copied to the new location.

Bonus: How to Make a Copy of An Excel Sheet

In addition to copying the entire workbook, there are times when you need to replicate a specific spreadsheet, which is a sub-sheet in a workbook. It is not difficult to copy an Excel sheet. To execute it successfully, there are two options.

Tip 1. Drap and Drop (Copy to the Same Workbook)

Step 1. Locate the worksheet you want to copy.

Step 2. Press the Ctrl key on your keyboard, and use the cursor to drag the sheet to the destination. (if you are using Mac, p     ress the Option key to drag and drop the sheet.)

Situation 2. Copy and Paste (Copy to a Different Workbook)

Step 1. Add a blank new sheet on the destination workbook.

Step 2. Navigate to the sheet you want to copy, and press Ctrl + A to Select all data in the sheet, then press Ctrl + C.

Step 3. Go back to the target sheet, and move your cursor to the first row, the first column.

Step 4. Press Ctrl +V to paste the sheet, including its formats and worksheets

The Wrap Up

To sum up, knowing how to make a copy of an Excel file is a crucial ability that may help you efficiently maintain and distribute your data. There are several methods available to complete this work, depending on whether you need to keep the original file while making modifications, share a copy with colleagues, or simply create backups.
 
You may confidently replicate your Excel files on both Windows and macOS PCs by following the methods provided in this guide. The option to make copies ensures the security and accessibility of your data, allowing you to operate more efficiently and collaboratively. 

Add a comment

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

ukCorteiz Official Store

ukCorteiz Official Store

brokenplanetmarket
December 8, 2024
ukCorteiz Official Store: Welcome to the vibrant world of ukCorteiz Official Store! If you’re looking for a brand...
QAS Autos is a multi service company that was established in 2019 in New York. We provide the inventory, parts and service under one roof. We also provide shipping, container loading, half and full cut of vehicles.
Copyright © 2021. All rights reserved.