[vip_students] Excel Tutorial:Lesson 21,The Windows Clipboard Versus the Microsoft Office Clipboard.

The Windows Clipboard Versus the Microsoft Office Clipboard.  

In Excel 2002 and 2003 , you can access the Microsoft Office clipboard. The
Office clipboard allows you to copy and paste multiple items. You will learn
how to use the Office clipboard later in this lesson.
You need to have the "sales.xls" file open for this exercise.

Exercise Objectives.  In the following five exercises, you will copy data in
a cell and copy a range of cells using the Copy and Paste commands. 


Exercise: Copying a Cell
The Copy command appears on the Edit menu. This tutorial always directs you
to use the keyboard shortcut Ctrl-C when using the Copy command. 

Complete the following two steps to copy a cell.

Step 1:  Press Ctrl-Home to move to the first cell in the worksheet. JFW
announces, "First Cell  Pedicure Products  A1."

Step 2:  Press Ctrl-C to activate the Copy command. JFW announces, "Copied
Selected Text to Clipboard."

When you activate the Copy command, Excel places a copy of cell A1's
contents on the clipboard and changes the selection cursor around the cell
to a dotted selection cursor.

 
Exercise: Pasting the Contents of the Clipboard
The Paste command appears on the Edit menu. This tutorial always directs you
to use the keyboard shortcut Ctrl-V when pasting the contents of the
clipboard.

Complete the following four steps to paste the contents of cell A1 into a
different location in the worksheet.

Step 1:  Move to cell A14 by pressing the Down Arrow key until JFW
announces, "Blank  A14." (Remember, when you copied the contents of cell A1,
Excel placed a dotted selection cursor around cell A1.)

Step 2:  Press Ctrl-V to paste the contents of the clipboard into cell A14.
JFW announces, "Pasted Text from Clipboard."

Excel inserts the data you copied from cell A1 into cell A14.

Note:  The dotted selection cursor remains around cell A1 until you press
Enter to accept the information in the cell to which you pasted the data.

Step 3:  Press Enter to accept the information in cell A14. JFW announces,
"Enter."

Step 4:  Verify the copied data was pasted into cell A14 by pressing the
Numpad 5 key to read the contents. JFW announces, "Pedicure Products." Then,
press Insert-C to verify cell A14 is selected. JFW announces, "A14."

The words "Pedicure Products" are now in cells A1 and A14.


Exercise: Copying Data Within a Cell
Complete the following twelve steps to copy part of the data in one cell to
another cell.

Step 1:  Press Ctrl-Home to move to cell A1.

Step 2:  Select cell A4 by pressing the Down Arrow key until JFW announces,
"Quarterly Totals  A4."

Step 3:  Press F2 to activate the edit mode. JFW announces, "Edit." The
insertion point appears after the word "Totals."

Step 4:  Press Home to move the insertion point before the word "Quarterly."
Then, press Insert-Numpad 5 to verify.

Step 5:  Press Shift-End to select the words "Quarterly Totals." Press
Shift-Insert-Down Arrow to verify the selection. JFW announces, "Select
Quarterly Totals."

Step 6:  Press Ctrl-C to copy the data to the clipboard. JFW announces,
"Copied Selected Text to Clipboard."

Step 7:  Press Enter to accept the information in the cell.

Step 8:  Press the Down Arrow key to select cell A14. 

Step 9:  Press F2 to activate the edit mode. JFW announces, "Edit." The
insertion point appears after the word "Products."

Step 10:  Press the Spacebar to insert a blank space after the word
"Products." 

Step 11:  Press Ctrl-V to copy the contents of the clipboard. JFW announces,
"Pasted Text from Clipboard  Edit." Then, press Insert-Up Arrow to verify.

The words "Quarterly Totals" now appear after the words "Pedicure Products."

Step 12:  Press Enter to accept the information in the cell. Then, press the
Up Arrow key to return to cell A14. JFW announces, "Pedicure Products
Quarterly Totals  A14."


Exercise: Copying a Range of Cells
Complete the following nine steps to copy the contents of cells A7 through
A11 and paste it in cells A16 through A20.

Step 1:  Press Ctrl-Home to move to cell A1. JFW announces, "First Cell
Pedicure Products  A1."

Step 2:  Move to cell A7 by pressing the Down Arrow key until JFW announces,
"Happy Hooves Callus [Gel]  A7."

Step 3:  Select cells A7 through A11 by pressing Shift-Down Arrow four times
until cells A8, A9, A10, and A11 are selected. JFW announces, "Select,"
followed by the cell data.

Step 4:  Press Shift-Insert-Down Arrow to verify the selected data. JFW
announces, "Selected Range A7 Through A11 Happy Hooves Callus [Gel]  Happy
As A Hog Foot Cream  Welcoming Wallow Heated Foot Massager  Smells Like The
Barnyard Foot Mud  Piggies Polish."

Step 5:  Press Ctrl-C to copy the data in the selected cells. JFW announces,
"Copied Selected Text to Clipboard."

Step 6:  Select cell A16 by pressing the Down Arrow key until JFW announces,
"Blank  A16."

Step 7:  Press Ctrl-V to paste the contents of the clipboard into cells A16
through A20. JFW announces, "Pasted Text from Clipboard."

Excel inserts the data you copied from cells A7 through A11 into cells A16
through A20.

Note: When pasting data from a range of cells, you do not need to select all
of the cells where the range data will be placed before you activate the
Paste command.

Be aware, however, if any of the cells where you pasted the data contain
data, that data will be overwritten by the new data. If you want to insert
the copied data without replacing existing data, use the Insert command on
the Edit menu rather than the Paste command.

Step 8:  Press Enter to accept the information in cells A16 through A20. JFW
announces, "Enter."

Step 9:  Press Home to remove the selection cursor, and then press the Up
and Down Arrow keys to verify the data was copied.


Exercise: Copying and Pasting Data to Another Workbook
Complete the following twelve steps to copy and paste data from Sales.xls to
a new workbook.

Step 1:  Press Ctrl-Home to move to cell A1.

Step 2:  Move to cell A6 by pressing the Down Arrow key until JFW announces,
"New Products  A6."

Step 3:  Press Shift-Down Arrow six times to select cells A6 through A12.

Step 4:  Press Shift-Insert-Down Arrow to verify the selection. JFW
announces, "Selected Range  A6 Through A12  New Products  Happy Hooves
Callus [Gel]  Happy As A Hog Foot Cream  Welcoming Wallow Heated Foot
Massager  Smells Like The Barnyard Foot Mud  Piggies Polish  Total."

Step 5:  Press Ctrl-C to copy the data in the selected cells. JFW announces,
"Copied Selected Text to Clipboard." A dotted selection cursor appears
around the selected range.

Step 6:  Press Ctrl-N to create a new workbook. JFW announces, "Book2
Sheet1  Blank  A1."

Step 7:  Press Insert-C to verify cell A1 is selected.

Step 8:  Press Ctrl-V to paste the copied data in the new workbook. JFW
announces, "Pasted Text from Clipboard."

Step 9:  Press Ctrl-Home to move the selection cursor to cell A1. Then,
press the Down Arrow key repeatedly to read all the data in the current
worksheet.

Tip:  If JFW seems to be reading extra data, press Insert-Escape to refresh
the screen.

Step 10:  Press Ctrl-F4 to close Book2. A dialog box appears prompting you
to save the changes you made to Book2. Press N to close the Book2 without
saving it.

When you close Book2 the focus returns to Sales.xls. 

The dotted selection cursor remains around the selected range of cells.

Step 11:  Press Escape to remove the dotted selection cursor from the range
of cells. JFW does not indicate the selection cursor was removed.

Important!  Be sure to always remove the dotted selection cursor from the
selected range. Otherwise, JFW will not read the data properly.

Step 12:  Press Ctrl-Home to move to cell A1.


What You Learned.  In this topic, you learned:

You can copy data in a selected cell by pressing Ctrl-C to activate the Copy
command. Excel copies the data and places it on the clipboard. JFW
announces, "Copied Selected Range." 

When you copy cell data, Excel places a dotted selection cursor around the
cell. The dotted selection cursor remains around the cell until you press
Enter to accept the pasted information in the cell or press Escape to remove
the dotted selection cursor.

After you position the selection cursor where you want the copied data to
appear, you can press Ctrl-V to activate the Paste command. Excel inserts
the copied data. JFW announces, "Pasted Selected Range." (You should always
remove a dotted selection cursor. Otherwise, JFW will not be able to read
the data properly.)

When pasting data from a range of cells, you do not need to select all the
cells where the range data will be placed before you activate the Paste
command. If any of the cells where you pasted the data contain data, that
data will be overwritten by the new data. (To insert the copied data without
replacing existing data, use the Insert command on the Edit menu rather than
the Paste command.)




********************************************************************

NOTICE: The information contained in this email and any attachments 
is confidential and may be privileged.  If you are not the intended 
recipient you should not use, disclose, distribute or copy any of 
the content of it or of any attachment; you are requested to notify 
the sender immediately of your receipt of the email and then to 
delete it and any attachments from your system.

NCBI endeavours to ensure that emails and any attachments generated 
by its staff are free from viruses or other contaminants.  However, 
it cannot accept any responsibility for any such which are 
transmitted.  We therefore recommend you scan all attachments.

Please note that the statements and views expressed in this email 
and any attachments are those of the author and do not necessarily 
represent the views of NCBI


********************************************************************




Other related posts:

  • » [vip_students] Excel Tutorial:Lesson 21,The Windows Clipboard Versus the Microsoft Office Clipboard.