HOWTO DELETE UNLOCK CELLS
 

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.

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.

HOWTO DELETE UNLOCK CELLS
 

Of course!!! I can not believe I did not think of that, but that does not
take the credit out of you, thanks a lot for the solution and for the
interest in my and averyone questions, keep up the good work. Thanks again
Bill.

"Bill Kuunders" wrote:

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.

HOWTO DELETE UNLOCK CELLS
 

You're too kind.
thanks for the feed back.
It's a hobby and a challenge for me. I always check whether the real excel
guru's
are going to come up with a better answer. That way I learn and I hope, so
do others.
So, the thanks should go to all the experts who take time to give us the
right solutions again and again.

Bill

"FC" wrote in message
...
Of course!!! I can not believe I did not think of that, but that does not
take the credit out of you, thanks a lot for the solution and for the
interest in my and averyone questions, keep up the good work. Thanks again
Bill.

"Bill Kuunders" wrote:

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.