Datasheet

Summary
41
There are many ways to use Auto Fill, and more of them are explained in
Chapter 4, “Editing Tools, Comments, and Hyperlinks.”
Summary
Understanding how to easily move around a workbook and quickly move to any given section
is imperative for the most effective use of the program. Knowing which menu houses which
command will also speed up your process, with less trial-and-error guesswork. Commands
can be executed in Excel by choosing a command from a menu, choosing a command from the
task pane, right-clicking and selecting a command from a shortcut menu, using the various
toolbar buttons, or using keyboard shortcuts.
An Excel file is called a workbook; workbooks can include many worksheets. You can nav-
igate through a workbook, from sheet to sheet, and navigate through a worksheet, from cell
to cell. Or you can use methods to move to specific content from anywhere in the workbook.
You can add data and edit data, add new worksheets and edit sheet names, and add and
remove cells, columns, and rows. You can also manage the size of your rows and columns.
Excel helps you manage your files and folders by using the Save As dialog box to name files,
create new folders, choose the location where you want the file saved, and specify the file type.
After data is entered in a worksheet, you can move it or copy it to another location on the
sheet, or to another sheet. Moving and copying can be done by using the cut, copy, and paste
commands or by using the mouse to drag and drop or fill.
You can select parts of the content of any cell, or the entire cell, or entire ranges, either
contiguous or noncontiguous. Once selected, the selection can be moved, copied, or deleted
in one step.
16. Select cells A9 and A10, which now contain 307 and 308. Now use the black plus sign on
the fill handle on A10 to drag both cells down to A15. When you select multiple cells,
Excel recognizes the series and fills the series by default.
17. Click the Options button and choose Copy Cells. Now instead of filling the series, Excel
just copies 307 and 308 over and over.
18. Continue to explore different ways to use the different mouse pointers to move, copy,
and fill data. When you are done, close the file and close Excel. You do not need to save
this one.
EXERCISE 1.20 (continued)
4002book.fm Page 41 Friday, March 24, 2006 11:36 PM