How do I clear all cells from all rows except the first row in Sheet1?

  • Thread starter Thread starter Michael
  • Start date Start date
"Michael" askes...
How do I clear all cells from all rows except the first row in Sheet1?
Click to expand...

Select cell A2
press Ctrl + Shift + End
menu Edit --> Clear --> All

HTH,

Sybolt
 
Hi,

You could for example copy/insert the first row to a different sheet, then
clear the whole sheet and recopy the first row back . (and delete the one on
the other sheet)

There are other methods as well, such as selecting all rows except the first
one and clearing, or creating a new sheet, then copying first row to it and
then deleting the old sheet (only of no other sheets are referring to the
cells, otherwise you may run into problems...).

Hope this helps,
Erny
 
Back
Top