How do I reset a sheet completely?

  • Thread starter Thread starter Kenji
  • Start date Start date
K

Kenji

I have one sheet on my excel workbook that I would like to completely reset.

I want all cells to be cleared and all the rows/height to be default.

How can I do this? Thanks!

Kenji
 
Kenji, why not just insert a new sheet? You could use a macro like this

Sub Reset()
Cells.Select
Selection.ClearContents
Selection.ColumnWidth = 8.43
Selection.RowHeight = 12.75
Range("A1").Select
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Thanks Paul.

Kenjiro Yagi

Paul B said:
Kenji, why not just insert a new sheet? You could use a macro like this

Sub Reset()
Cells.Select
Selection.ClearContents
Selection.ColumnWidth = 8.43
Selection.RowHeight = 12.75
Range("A1").Select
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How Do I Upload? 3
How can I call a Excel Macro from VB? 1
How do I reset a sheet completely? 4
Oh no~ I set a password and forgot 2
Reset Button 4
How do I call an excel macro from outside the workbook? 1
How do I get rid of alerts? 1
Is there a way to add a reference? 3

Back
Top