Clearing all Active Cells

  • Thread starter Thread starter JohnHill
  • Start date Start date
J

JohnHill

I've got a spreadsheet that has a range of active cell in which to inpu
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,

Joh
 
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.
 
The GOTO Special feature allows you a number of ways to choose cells e.g.
highlight all cells that contain constants that are numbers or text etc. Once
selected you can then delete them all. Hopefully this helps a bit. You can
watch a video clip on how to use the GOTO special command on
http://www.auditexcel.co.za/othertools.html .
 
You must log in or register to reply here.

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

Excel Macro to use cells as a autofilter 0
clear all sheets code 4
How do I prevent Crtl+End moving to a cleared cell? 1
Excel Cannot delete empty cells/rows 4
#N/A In Cells 7
Input Text Upon Click Of Cell 4
Determining if a number got hit before another 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2

Back
Top