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

Save a Workspace Layout

Create Custom Views

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 ...

Get Microsoft Office Excel 2007 On Demand now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.