To continue our medley of right-click options: If you want to move or copy a sheet, either within the
existing workbook or to another open workbook, or sheets (we’ll soon see how to select multiple
sheets), right-click the relevant sheet tab, and select Move or Copy….You’ll see this dialog box (Figure
7–9):
Figure 7–9. Peripatetic worksheet: Where to move or copy a worksheet to another book.
As you see, you’ll need to click on the name of the sheet before which you want the sheet to be
moved. Note here that, by default, the To book: field names the workbook in which the sheet is
currently positioned. If you want to move or copy the sheet to a different book, click the down arrow by
“To book” to view the names of other open wor kbooks. Alter natively, you can click (move to end),
whereupon the sheet will be resituated at the end of the sheet collection, no matter how many sheets
you currently have on hand in the workbook. Then click OK.
Note that you can copy the sheet(s) to a different open wor kbook, too. Clicking Create a copy will do
just that, replicating the sheet (including all its data) and placing it in the first position among the
sheets (though obviously you can go ahead and move it). Copying a sheet coins a new sheet name
based on the copied sheet, e.g., Sheet 2 (2).
■ Tip You can also move a sheet by clicking the sheet tab (left button, this time), dragging it to its new position
among the tabs, and releasing the mouse when you’ve reached your destination. A small page icon will
accompany you as your drag, letting you know that sheet move is in progress.
And you can also recolor the sheet tab. Right-click the tab, select Tab Color, an d se l e ct y our hue
from the resulting color selection. (Note: Your new color won’t actually appear in the tab until you click
on a di ffe r e n t tab.)
existing workbook or to another open workbook, or sheets (we’ll soon see how to select multiple
sheets), right-click the relevant sheet tab, and select Move or Copy….You’ll see this dialog box (Figure
7–9):
Figure 7–9. Peripatetic worksheet: Where to move or copy a worksheet to another book.
As you see, you’ll need to click on the name of the sheet before which you want the sheet to be
moved. Note here that, by default, the To book: field names the workbook in which the sheet is
currently positioned. If you want to move or copy the sheet to a different book, click the down arrow by
“To book” to view the names of other open wor kbooks. Alter natively, you can click (move to end),
whereupon the sheet will be resituated at the end of the sheet collection, no matter how many sheets
you currently have on hand in the workbook. Then click OK.
Note that you can copy the sheet(s) to a different open wor kbook, too. Clicking Create a copy will do
just that, replicating the sheet (including all its data) and placing it in the first position among the
sheets (though obviously you can go ahead and move it). Copying a sheet coins a new sheet name
based on the copied sheet, e.g., Sheet 2 (2).
■ Tip You can also move a sheet by clicking the sheet tab (left button, this time), dragging it to its new position
among the tabs, and releasing the mouse when you’ve reached your destination. A small page icon will
accompany you as your drag, letting you know that sheet move is in progress.
And you can also recolor the sheet tab. Right-click the tab, select Tab Color, an d se l e ct y our hue
from the resulting color selection. (Note: Your new color won’t actually appear in the tab until you click
on a di ffe r e n t tab.)
Tidak ada komentar:
Posting Komentar