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. |
|
Make a copy of a worksheet in a specified location in the workbook. |
|
Delete a specified worksheet. |
|
Move the user's selection to a specified worksheet. |
|
Iterate through the collection of all worksheets. |
|
Preview and print a worksheet. |
|
Move a worksheet to a new location in a workbook. |
|
Change the visibility of one or more worksheets. |
|
Lock all or part of a worksheet so it cannot be edited. |
|
Remove the lock from a worksheet so it can be edited. |
|
Add and delete comments. |
|
Show or hide all comments. |
|
Create groups in worksheets. |
|
Make a row bold only when it contains a selected cell. |
How to: Programmatically Change Formatting in Worksheet Rows Containing Selected Cells |
Copy data and formatting across worksheets. |
How to: Programmatically Copy Data and Formatting across Worksheets |
Check spelling in worksheets. |
|
Sort data in named ranges and list objects. |
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.