Working with Worksheets

The Worksheet and Worksheet classes contain the methods and properties you use to perform tasks with worksheets.

Task	Procedure
Add a new worksheet to a workbook.	How to: Add New Worksheets to Workbooks
Make a copy of a worksheet in a specified location in the workbook.	How to: Copy Worksheets
Delete a specified worksheet.	How to: Delete Worksheets from Workbooks
Move the user's selection to a specified worksheet.	How to: Select Worksheets
Iterate through the collection of all worksheets.	How to: List All Worksheets in a Workbook
Preview and print a worksheet.	How to: Print Worksheets
Move a worksheet to a new location in a workbook.	How to: Move Worksheets Within Workbooks
Change the visibility of one or more worksheets.	How to: Hide Worksheets
Lock all or part of a worksheet so it cannot be edited.	How to: Protect Worksheets
Remove the lock from a worksheet so it can be edited.	How to: Remove Protection from Worksheets
Add and delete comments.	How to: Add and Delete Worksheet Comments
Show or hide all comments.	How to: Display Worksheet Comments
Create groups in worksheets.	How to: Group Rows in a Worksheet
Make a row bold only when it contains a selected cell.	How to: Change Formatting in Worksheet Rows Containing Selected Cells
Copy data and formatting across worksheets.	How to: Copy Data and Formatting across Worksheets
Check spelling in worksheets.	How to: Check Spelling in Worksheets
Sort data in named ranges and list objects.	How to: Sort Data in Worksheets Programmatically

For more information about Excel tasks and the Excel object model, see Excel Object Model Overview.

In some cases, the ways that you perform these tasks in application-level add-ins is different from the ways that you perform them in document-level customizations.

See Also

Concepts

Automating Excel by Using Extended Objects

Working with Workbooks

Working with Ranges

Using Windows Forms Controls on Excel Worksheets