Microsoft® Office 2007 On Demand

9. Creating a Worksheet with Excel

What You’ll Do

View the Excel Window

Select Cells

Move Around the Workbook

Enter Labels and Values on a Worksheet

Enter Values Quickly with AutoFill

Edit and Clear Cell Contents

Insert and Delete Cell Contents

Select Rows, Columns, and Special Ranges

Select and Name a Worksheet

Insert and Delete a Worksheet

Move and Copy a Worksheet

Hide and Unhide Worksheets and Workbooks

Hide and Unhide a Column or Row

Insert and Delete a Column or Row

Adjust Column Width and Row Height

Split a Worksheet into Panes

Freeze and Unfreeze a Column or Row

Show and Hide Workbook Elements

Introduction

At times, you’ll need to reorganize a workbook by adding additional worksheets, moving their appearance order within the workbook, ...