Clear All Information from Spreadsheet

[Sue]

I am using Excel to load values from an Access table to
create a scheduler. I want to clear all values from the
sheet each time I load it. I can do it cell by cell or
use entire column or row but the cursor 'zings' around
the screen while it is clearing and it looks awful. Is
there a quick way to clear the whole sheet back to the
state that Excel would normally show on opening a new
sheet?

Thanks in advance.

 

[Guest]

do the following:
Click the intersection square where row and column
headers meet. This selects all cells in the sheet. Press
the Delete key.
These steps will work in a macro, too.

Good luck.

 

[hgrove]

Sue wrote...

I am using Excel to load values from an Access table to create scheduler. I
want to clear all values from the sheet each time I load it. I can d it cell by cell
or use entire column or row but the cursor 'zings' around the scree while it is
clearing and it looks awful. Is there a quick way to clear the whol sheet back
to the state that Excel would normally show on opening a new sheet?

Do you mean doing this from a macro?

Someworksheet.Cells.Clear

If interactively, click on the box at the top-left of the workshee
frame where the column letters and row numbers intersect, then Edit
Clear > All