Microsoft Office Tutorials and References
In Depth Information
4. Modifying Worksheets and Workbooks
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
Set Up for Personal Templates
Create a Personal 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 work-
sheet. You can rename worksheets to better show the theme of your workbook. When using
your workbook, there may be times when you’ll want to hide certain worksheets due to
sensitive or confidential information. You can also freeze the column and row headings to
ease viewing a long list of data.
On any worksheet, you can insert and delete cells, rows, and columns. You can adjust
column width and row height so that you can structure the worksheet exactly the way you
want. It’s easy to make changes because Microsoft Excel updates cell references in existing
Search JabSto ::




Custom Search