How to copy and paste Excel sheet with formulas

Copying and pasting an Excel sheet with formulas means duplicating a sheet that contains formulas and pasting it onto a new sheet. This process copies both the formulas and the cell references to other cells. The overall importance of copying and pasting Excel sheets with formulas lies in its ability to save time and reduce errors when creating multiple sheets with similar calculations. 

Our dataset below consists of a class result containing the names of students along with their scores in three subjects, the sum of these scores, and the average of these three scores. The sum is calculated using a basic addition formula and the average is calculated using a basic division formula. We want to duplicate this sheet along with its formulas without making any changes. To accomplish this, we have three methods.

Method 1: Copy and Paste the Sheet using the keys

Step 1 – Select the complete sheet

• Click on the top left corner of the sheet to select the complete sheet.

Step 2 – Copy the Sheet

• After selecting the complete sheet, pres  the CTRL+C keys to copy the sheet

Step 3 – Select the Cell

• Click on the cell where you want to paste the Copied sheet

Step 4 – Paste the Sheet

• After selecting the cell, press the CTRL+V keys to paste the copied sheet

Method 2: Copy and Paste the Sheet using the ENTER key

Step 1 – Select the complete sheet

• Click on the left corner of the sheet to select the complete sheet

Step 2 – Copy the Sheet

• After selecting the complete sheet, pres  the CTRL+C keys to copy the sheet

Step 3 – Select the Sheet 

• Select the sheet where you want to paste the copied sheet by clicking on the top left corner of that sheet

Step 4 – Press the Enter key

• After selecting the sheet where you want to paste the copied sheet, press the ENTER key to get the required result. All the copied data will be pasted into the new sheet as shown below.

Method 3: Copy and Paste the Sheet using the Move or Copy option

Step 1 – Click on the Sheet Name

• Click on the Sheet name at the bottom of the sheet, and an upside menu will appear

Step 2 – Click on the Move or Copy option

• From the upside menu, click on the Move or Copy option and a dialog box will appear

Step 3 – Click on the Move to End option

• In the dialog box, click on the Move to End option

Step 4 – Tick the Create a copy checkbox

• Click on the Create a copy checkbox at the end of the dialog box

Step 5 –  Click on OK

• After clicking on the check box, click on OK to get a copy of the sheet