Share via


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: Create Groups in Worksheets

Clear groups in worksheets.

How to: 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.

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

Hide a worksheet.

Hidden Worksheets

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

Working with Cells

Using Windows Forms Controls on Excel Worksheets