Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Clearing all Active Cells
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 . "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Clearing Check Boxes and Cells | Excel Worksheet Functions | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
REVISED ?? - populate limited cells w/ set value | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |