Unprotect the worksheet (Tools/Protection/Unprotect Sheet)

Select all cells by clicking in the gray box to the left of cell A1.
Click Edit/Clear/All

Be sure to back up in case this isn't what you want.


"JohnHill" wrote:


I've got a spreadsheet that has a range of active cell in which to input
data. How do I clear all active cells to end up with a fresh sheet ?

The spreadsheet is protected.

I assume this is an easy one.

Thanks,

John


--
JohnHill
------------------------------------------------------------------------
JohnHill's Profile: http://www.excelforum.com/member.php...o&userid=25171
View this thread: http://www.excelforum.com/showthread...hreadid=390038