Microsoft® Excel 2010 On Demand

4 Modifying Worksheets and Workbooks

What You’ll Do

Select and Name a Worksheet

Insert and Delete a Worksheet

Move and Copy a Worksheet

Hide and Unhide Worksheets and Workbooks

Select a Column or Row

Hide and Unhide a Column or Row

Insert a Column or Row

Delete a Column or Row

Adjust Column Width and Row Height

Freeze and Unfreeze a Column or Row

Split a Worksheet into Panes

Show and Hide Workbook Elements

Zoom the View In and Out

Create Custom Views

Save a Workspace Layout

Create a Template

Open and Change a Template

Introduction

At times, you’ll need to reorganize a workbook by adding additional worksheets, moving their appearance order within the workbook, or even deleting an unused or outdated worksheet. You can rename worksheets to better ...