HOWTO DELETE UNLOCK CELLS
Give the collection of all unlocked cells a name
click onto the first, hold cntr button and klick onto the others,
while highlighted give this collection of cells a name by entering a name in
the area just above cell a1 and push "enter"
select the name and press delete button
--
Greetings from New Zealand
"FC" wrote in message
...
I'm looking for a way to delete unlocked cells in a worksheet without
using
formulas,macro... This is the thing : locked cells are written and don't
change,
unlocked cells are to write on them, print and erase the context to write
again of course.Also the sheet is protected with the purpose of keeping
the
locked cells with the text that does not change. My 2 options :1- copy the
worksheet with the empty unlocked cells and write in them everytime in
different sheet or 2- do what I call tab-delet, tab-delete, tab-delete
until
all unlocked cells are deleted ( effective but long proccess). Is there a
better 3er options or I'm asking too much from excel ?TX.
|