LESSON 4: Working with Cells, Columns, Rows, and Sheets

 

 

Size

Duration

            EXERCISE LESSONS

4-1

Insert Worksheets

 

 

4-2

Move and Delete Worksheets

 

 

4-3

Insert Cells

 

 

4-4

Delete Cells

 

 

4-5

Use AutoComplete

 

 

4-6

Use Pick From List

 

 

4-7

Cut and Paste Cell Contents

 

 

4-8

Copy and Paste Cell Contents

 

 

4-9

Use Drag and Drop

 

 

4-10

Use the Office Clipboard

 

 

4-11

Insert Rows

 

 

4-12

Delete Rows

 

 

4-13

Insert and Delete Columns

 

 

4-14

Hide and Unhide Columns and Rows

 

 

4-15

Freeze and Unfreeze Rows and Columns

 

 

4-16

Change the Horizontal Alignment

 

 

4-17

Use Center Across Selection

 

 

            SKILLS REVIEW

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

            LESSON APPLICATIONS