How to Copy From One Excel Spreadsheet to Another Without Creating Links
Save time and reduce effort by copying and pasting Excel spreadsheets. When you've already created one spreadsheet and want to reuse it, take advantage of Excel's quick copy and paste techniques to transfer data. Copying and pasting Excel spreadsheets is like copying and pasting something in real life -- no links are created to tie the copied material back to its origins. Create link-free copies using Excel.
Open Microsoft Excel. Click the "File" tab and select "Open." Browse to the spreadsheet to copy and double-click the file name, opening the spreadsheet in the main work view.
Open another instance of Microsoft Excel by double-clicking the icon again. If you have dual monitors, drag one copy of Excel onto the second monitor. If you are copying the first spreadsheet into another existing spreadsheet, repeat the "File" and "Open" process to open that spreadsheet in this second copy of Excel. Otherwise, a blank spreadsheet awaits the copy.
Click back to the spreadsheet to copy. Click the "Select All" button. The unlabeled button is the square with a small arrow that sits to the left of the "A" in the first column and above the "1" in the first row. The entire spreadsheet is highlighted. Press "Ctrl" + "C" on the keyboard to copy the spreadsheet.
Click the other spreadsheet, which will receive the copy. If the spreadsheet is new, press "Ctrl" + "V" to paste in the copy of the first spreadsheet. If you opened an existing spreadsheet, scroll to the place where the copy should be pasted, click and press "Ctrl" + "V." The copy pastes in with no links back to the original.
Click the "File" tab and select "Save As." Type a name for the newly copied and pasted spreadsheet, and then click the "OK" button.
Tips & Warnings
- If the original spreadsheet to copy has hyperlinks in it, remove them before copying the spreadsheet. Scroll to the cell with the hyperlink, right-click it and select "Remove Hyperlink." Repeat this for all linked cells so only the text copies, not the link. When closing the original spreadsheet, click "No" when Excel asks whether to save the changes. This will ensure the hyperlinks remain associated with the original.