How to Copy & Paste an Excel Document


The copying and pasting process isn't just for single spreadsheet cells or blocks of text -- you can also copy entire sheets of a Microsoft Excel document or even an entire Excel file. Copying Excel documents can be particularly helpful when you're working with a template. You can copy a master sheet or Excel file and fill it in with new information, while preserving the original file to use again in the future.

Copy and Paste a Sheet

  • Open the Microsoft Excel document containing the sheet you want to copy.

  • Right-click on the sheet name, such as "Sheet 1."

  • Click "Move or Copy."

  • Select the location in the Excel document where you want the new sheet to appear, such as "at the end."

  • Check the "Create a Copy" box.

  • Click "OK."

Copy and Paste a File

  • Click "Start," then click "Documents." Navigate to the folder containing the Excel spreadsheet you want to copy.

  • Right-click on the Excel file.

  • Select "Copy."

  • Navigate to the folder where you want to paste a copy of the original file, if you do not want it in the same directory.

  • Right-click in the folder window, and choose "Paste."

Tips & Warnings

  • If you paste the copy of an Excel file into the same directory as the original, the new file will have "Copy" in its name. Right-click on the file and choose "Rename" to change the name of the file.
Promoted By Zergnet


You May Also Like

Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!