|  

» Copying/Moving a Sheet in Excel 2007

There is a difference between copying all the cells in a sheet and copying the sheet itself.

To copy and paste all cells in a sheet:

1. Select all cells in the sheet by pressing Ctrl+A>, or if the selected cell is in a Current Region/List range, press Ctrl+A+A.
Or
Click Select All at the upper-left intersection of rows and columns.
2. Press Ctrl+C.
3. Press Ctrl+Page Down to select another sheet, then select cell A1.
4. Press Enter>.

To copy the entire sheet:

Copying the entire sheet means copying the cells, the page setup settings, and the defined Names range.
Option 1:
1. Click on a sheet tab.
2. Hold down the Ctrl key, and drag the sheet to a different location.
3. Release the mouse button and then the Ctrl key.
Option 2:
1. Right-click the appropriate sheet tab.
2. From the shortcut menu, select Move or Copy. The Move or Copy dialog box enables to copy the sheet either to a different location in the current workbook, or to a different workbook. Make sure to mark the Create a copy checkbox.
Option 3:
1. Select View -> Arrange (in Window Group).
2. Select Tiled.
3. Use Option 1 above (dragging the sheet while pressing the Ctrl key) to copy or move a sheet.

Caution: Moving a sheet from a workbook with defined Names range or linked formulas will create links in the new workbook.


Rate This Tip
12 34 5
Rating: 2.00     Views: 4595
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments