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 ********************************************************************