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


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 the O’Reilly learning platform.

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