How to Copy and Paste Multiple Cell Contents in Microsoft Excel 2003

Sreadsheet software applications have many household usages. The most common of those is budgeting and expense tracking. Many people like to spice up their spreadsheets by adding borders to cells and even by dropping in color fills. In turn, quite often the need arises to copy and paste the multiple contents of cells into other cell blocks.

Instructions

1. Highlight the cells that you wish to copy. Simply left-click on a cell and hold the mouse button as you drag the cursor over the multiple cells you wish to copy. Then let go of the mouse button and the cells will stay highlighted.

2. Copy the cells. To do this, scroll to the “Edit” tab on the command bar and select “Copy.”

3. Highlight the cells you wish to paste into. Find the group of cells that you wish to paste into; they must number the same as the cells you copied. Highlight the cells that you wish to paste into by following the directions in Step 1.

4. Paste into the cells. To paste your cells into the new cells, scroll to the “Edit” tab on the command bar and select “Paste.”

Tips & Warnings

• Copying and pasting multiple cell contents will also copy the existing formulas from those cells and replace any current formulas within the cells you paste them into.