How to Copy & Paste Into Multiple Worksheets

You can copy your worksheet data to multiple documents.

The ability to copy and paste data between worksheets can greatly reduce the amount of time it takes to build even the most complex spreadsheet scenarios. Once the initial data is in place, all you need to do is copy the data into each subsequent worksheet. That makes it easy to create a number of different documents in a fraction of the time it would take to create each worksheet by hand.

Instructions

1. Log on to your computer and open your spreadsheet program. Open the worksheet you want to copy.

2. Hold the Ctrl key down and press the A key to highlight all the data in the worksheet.

3. Release the keys and press the Ctrl and C keys to copy the highlighted data to the clipboard.

4. Open a new worksheet and place the cursor at the top left-hand corner of the screen. Hold the Ctrl key down and press the V key to copy all the data from the clipboard to the new worksheet.

5. Create as many additional worksheets as you wish, pressing Ctrl and V to paste the data to each new worksheet. Save each worksheet to your hard drive or network share.