INTRODUCTORY MICROSOFT EXCEL Lesson 3 Organizing the Worksheet

1
INTRODUCTORY MICROSOFT EXCELLesson 3
Organizing the Worksheet
2
Objectives

• Copy data to other cells.
• Move data to other cells.
• Insert and delete columns and rows.
• Freeze titles.
• Split a workbook screen.
• Use print options when printing a worksheet.
• Check the spelling of words in a worksheet.

3
Terms Used in This Lesson

• Filling
• Freezing
• Splitting

4
Copy Data to Other Cells

• There are several ways to copy data in a
  worksheet
• Copy and paste
• Drag-and-drop
• method
• Fill cells

5
Move Data to Other Cells

• You can move data in two ways.
• Cutting and pasting
• Drag-and-drop method

6
Insert and Delete Columns and Rows

• When you want to delete a row or column
• Place the highlight in the row or column you want
  to delete.
• Choose Delete on the Edit menu.

7
Insert and Delete Columns and Rows (cont.)

• When the Delete dialog box appears, choose Entire
  row to delete the row, or choose Entire column to
  delete the column.

8
Freeze Titles

• Freezing keeps row or column titles on the screen
  no matter where you scroll in the worksheet.
• To freeze titles
• Place the highlight below the row you want to
  freeze or to the right of the column you want to
  freeze.
• Select Freeze Panes on the Window menu.
• All rows above the highlight and columns to the
  left of the highlight will be frozen.

9
Split a Workbook Screen

• Splitting is particularly useful when you want to
  copy data from one area to another in a large
  worksheet.
• Splitting divides the screen into two or four
  parts.

10
Use Print Options

• The Page Setup command on the File menu allows
  you to set
• page margins
• page lengths
• page widths
• page numbers
• The Print Preview button
  will display the page
  as it is to be
  printed.

11
Check the Spelling of Words

• The Excel dictionary tool checks the spelling of
  words on a worksheet.
• To spell-check a worksheet
• Select the Spelling command on the Tools menu.
• Click the Spelling button on the Formatting
  toolbar.

12
Summary

• The data in a worksheet can be moved or copied to
  another location.
• Inserting or deleting rows and columns can change
  the appearance of the worksheet.
• You can keep the titles on the screen at all
  times by freezing them.

13
Summary (cont.)

• The Page Setup command controls the page size and
  the margins that will be printed.
• Check the spelling of words in a worksheet by
  using the Spelling command in the Tools menu.