How to Copy & Paste an Excel Document

Save

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

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

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