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. | |
Clear groups in worksheets. | |
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. | |
Check spelling in worksheets. | |
Sort data in named ranges and list objects. | |
Hide a worksheet. |
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.
