Datasheet

Moving and Copying Data
29
An even quicker way to close your file and close Excel is to click the X on the
far-right end of your menu bar to close the file; then click the X above that on
your title bar to close Excel.
Moving and Copying Data
Often you have repetitive data that you want placed in more than one location in your work-
book, or you simply want to move your data from one place to another. Excel offers various
ways to do this. First, let’s look at simple copying and pasting.
Copy and Paste
There are various methods of copying and pasting that are specific to Excel. Something you
will notice when you copy data in Excel is a moving marquee around the copied data. This is
the way Excel shows you that something is on your Clipboard. To clear the data from the Clip-
board, you simply press the Esc key on your keyboard and the marquee disappears.
Exercise 1.15 explores the different ways to copy and paste in Excel.
8. You are now inside the Chapter One folder, which is inside the Excel 2003 MOS Projects
folder.
9. Now, it is time to name the file. In the File Name box near the bottom of the Save As box,
type Exercise 1-14 to replace what is already there.
10. As you can see, the Save As Type box contains Microsoft Office Excel Workbook (*.xls).
Click the dropdown arrow at the right end of that box. This is where you can choose a dif-
ferent format if you will be sharing this file with someone who does not have Excel 2003.
However, for this exercise you will be choosing the default, so scroll to the top of the
choices and click Microsoft Office Excel Workbook (*.xls) again.
11. Confirm that you are saving the file inside your Chapter One folder, that you have named
the file correctly, and that you have the default file type selected; then click Save.
12. Close the file by choosing File  Close; then exit Excel by selecting File  Exit.
EXERCISE 1.14 (continued)
4002book.fm Page 29 Friday, March 24, 2006 11:36 PM