Excel – How to clear the contents of an entire Sheet

Scenario

How to clear the contents of an entire sheet.

I want to delete the contents of the sheet1. without deleting the sheet.

Solution

To clear all use:

Sheet1.Cells.Clear

To clear only content (no formats) use:

Sheet1.Cells.ClearContents

To clear only formats use:

Sheet1.Cells.ClearFormats

To clear only cell comments use:

Sheet1.Cells.ClearComments

Then there is also:

Sheet1.Cells.ClearNotes

and

Sheet1.Cells.ClearOutline
SOURCE

LINK

LANGUAGE
ENGLISH