INTRODUCTORY MICROSOFT EXCEL Part 3 Organizing a Spreadsheet

1
INTRODUCTORY MICROSOFT EXCELPart 3 Organizing
a Spreadsheet
2
Objectives

• Move data by cutting and pasting.
• Move data by dragging.
• Copy data by copying and pasting.
• Copy data by dragging.
• Copy data into multiple adjacent lower cells by
  filling down.

3
Objectives (continued)

• Delete data.
• Copy data by filling right.
• Enter sequential data by using AutoFill.

4
Terms Used in This Part

• Filling

5
Copy Data to Other Cells

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

6
Move Data to Other Cells

• You can move data two ways
• Cut and paste
• Drag-and-drop

7
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.
• When the Delete dialog box appears, choose Entire
  row to delete the row or Entire column to delete
  the column.

8
Summary

• The data in a worksheet can be moved or copied to
  another location by using the Cut, Copy, Paste,
  and Fill commands on the Edit menu.
• Deleting rows and columns can change the
  appearance of the worksheet.