in all the 2007 Microsoft applications
you'll see a clipboard group on the Home
tab which is where you'll find the cut
copy and paste commands these commands
make it very easy to copy or cut and
then paste information from cell-to-cell
so that you don't have to type and
retype information let's take a look at
how this works
I'm happy with my spreadsheet that I've
created but I do think I'd like to add
the column back here so I can mark
whether I've paid my bills or not let's
say I want to mark everything from cell
c9 to c-13 as paid instead of typing yes
in each cell I can type yes and c9 and
copy and paste it in all the other cells
to do this left click the cell to select
it then click the copy command the
border of the copied cell now looks like
marching ants now select the cell or
cells where you want to paste the
information if you just want to paste
the information into one cell all you
have to do is left-click that cell to
select it if you want to paste the
copied information and more than one
adjoining cell just left-click one of
the cells and drag your cursor until all
the cells are selected now release the
mouse button and click the paste command
the copied cell will stay selected until
you perform your next task or you can
always double click it to deselected the
cut command is different from the copy
commands because it actually removes
information from the selected cell and
moves it to another cell
for example let's move yes from cell c9
to c15 select cell c9 and click the cuts
command now select the blank cell and
click paste the word yes now appears in
C 15 and c9 is empty so now you see how
the cut command works I actually do want
to leave the word yes in c9 let me paste
that into the cell I can use the paste
command or press the keyboard shortcut
for paste which is the ctrl key and the
V key another way to move information
from one cell to another is to use the
drag and drop method
drag and drop moves the text and numbers
in the cells and any formulas associated
with those cells let's take a look at my
net income for January you can see in
the formula bar that there is an
addition formula associated with this
cell when I drag all of my income
information to a new location in the
worksheet this formula will come along
let's take a look at how drag-and-drop
works let's select all the cells at the
top with my income information now
position your mouse pointer near one of
the outside edges of the selected cells
the mouse pointer changes from a large
white cross to a black cross with four
arrows keep the mouse pointer on the
edge of the selected cells now
left-click and hold the mouse button and
drag the cells to the new location
release the mouse button and the
information appears in the new location
see how easy it was to drag all this
information and drop it into a new
location now the really great thing
is that not only did it bring all my
text and numbers it also transferred the
formulas and changed them to represent
their new location now instead of a
formula saying cell c3 plus cell c4 it
shows the new cell addresses in the
formula one last thing that is worth
showing you in addition to the copy cuts
and paste commands and the drag-and-drop
feature the fill handle is another way
you can quickly enter data into cells
for example let's say I wanted to mark
this group of bills as not paid
I can type know into cell c16 and then
use the fill handle to fill the other
cells with the word know the fill handle
is this little square that appears in
the bottom or right corner of the cell
to use it just position your cursor over
it until the large white cross becomes a
thin black cross now left-click your
mouse and drag it until all the cells
you want to fill are highlighted release
the mouse and all the selected cells are
filled with the word no you can use the
fill handle to fill sales horizontally
as well I can do that here for my fixed
expenses you can imagine how this can be
a really useful tool now that you know
some of the ways you can copy cuts and
paste and move data around in a
spreadsheet why don't you give it a try
you