Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.