Moving a Worksheet
Excel provides a very easy way to move a sheet from one place to another in the same workbook.
You are watching: The process of moving within a worksheet or workbook:
Click the sheet tab you want to move. While holding down the mouse button, drag the sheet tab to its new location. When you drag a sheet, a small worksheet icon appears at the tip of your pointer arrow, another tiny black arrow appears at the beginning of the sheet tab. This tiny black arrow indicates where the sheet will be inserted in the tab order. release your mouse button and the sheet will be inserted into the placement indicated. Using this same technique, you can move several sheets at one time.
Select the first sheet you want to move, while holding down the Shift key, click on the next sheet. This will indicate a range of sheets to move i.e. sheet1:sheet2. You can then drag the range of sheets to their new location.
copying a Worksheet
Using similar mouse techniques as above,
First select the sheet or sheets you want to copy Then hold down the Ctrl key while you drag the sheet or sheets to the new location.
When you copy an entire sheet, the identical sheet appears in the new location.
A number will appear in parentheses to the copy”s to distinguish it from the original sheet.
Moving and copying Sheets Between Workbooks
Excel has the ability to move and copy sheets from a current workbook to another open workbook by simply dragging. Very neat isn”t it.
Moving Sheets Between Workbooks
You can use the same methods as above to move a worksheet to another workbook.
Open both workbooks you will be working in. Click on the sheet tab you wish to move from workbook 1 to workbook2. Drag the sheet from workbook 1 to where you want it to be in workbook 2.
** Note **
The entire sheet from workbook 1 will be moved to workbook 2. It will no longer be in workbook 1.
copying Sheets Between Workbooks
To copy rather than move sheets from one workbook to another follow the steps above but simply press the Ctrl key while dragging the sheet tab from workbook 1 to workbook 2.
Filling Across Worksheets
When working with multiple worksheets within a single workbook, you may find that there is some data on sheet1 that you want to appear on sheet2 and 3. Excel allows you to copy row and column headings, cell contents, and formats to other worksheets in the workbook. It will copy the data to the same cells in every worksheet you select,
Follow these easy instructions:
Select the worksheets you want to fill across.
u If the worksheets you want to fill across are continuous, hold down the Shift key, click on the first sheet tab, and select the last sheet you want. Excel selects all worksheets in between as well.
u If the worksheets you want are not continuous, hold down the Ctrl key, click on the first sheet tab, and select the remaining sheets. Excel selects only those sheets whose tabs you clicked.
Select the range that contains the cells you want to display on the other sheets. Click on the Edit menu, point to Fill, and click on Across Worksheets.
Excel will display the Fill Across Worksheets dialog box:
Do one of the following:
cIf you want to copy only contents, click on Contents.
cIf you want to copy only the format, click on Formats.
cIf you want to copy both content and format, click on All.
Click on OK.
Excel will display the contents of the cells you selected to the same cells on the worksheets you chose.