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: 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