132
168
After adding several sheets to a workbook, you might want to reorganize
them. You can arrange sheets in chronological order or in order of their
importance. You can easily move or copy a sheet within a workbook or
to a different open workbook. Copying a worksheet is easier and often
more convenient then reentering similar information on a new sheet. If
you are moving or copying a worksheet a short distance, you should use
the mouse. For longer distances, you should use the Move Or Copy
Sheet command on the Edit menu.
Moving and Copying
a Worksheet
Move a Worksheet Within
a Workbook
Click the sheet tab of the
worksheet you want to move, and
then hold down the mouse button.
When the mouse pointer changes
to a sheet of paper, drag it to the
right of the sheet tab where you
want to move the worksheet.
Release the mouse button.
3
2
1
Did You Know?
Y
o
u
c
a
n
u
s
e
t
h
e
C
r
e
a
t
e
A
C
o
p
y
c
h
e
c
k
b
o
x
t
o
m
o
v
e
a
w
o
r
k
s
h
e
e
t
.
Clear the
Create A Copy check box in the Move
Or Copy dialog box to move a work-
sheet rather than copy it.
Y
o
u
c
a
n
g
i
v
e
y
o
u
r
w
o
r
k
s
h
e
e
t
a
d
i
f
f
e
r
-
e
n
t
b
a
c
k
g
r
o
u
n
d
.
Click the tab of the
sheet on which you want to insert a
background, click the Format menu,
point to Sheet, and then click
Background. Select the picture you
want to use as a background, and
then click Insert.
2
1
XL03S-5-4