MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Is word wrap the only Solution?

  Asked By: Vernon    Date: Dec 16    Category: MS Office    Views: 963

I'm very very new to excel VBA.
I want to maintain an excel sheet for all the Application Support i'm dealing
I want to protect some coloumn's in a row .i.e.If someone deletes the whole row
, the values in some Column must not be deleted

I hope this description explains my problem.....

One more doubt is that, inside a cell if we want to write in 2-3 lines like a
paragraph, how do we do that. Is word wrap the only Solution?

If you have an answer please help me.......



1 Answer Found

Answer #1    Answered By: Lori Wood     Answered On: Dec 16

Protection is on by default for cells. You need to unprotect the cells you
want two be able to type into.

Then you need to turn protection on for the workbook to allow it to work.

Re paragraphs ... Alt-Enter will put a return into the text in a cell.

Didn't find what you were looking for? Find more on Is word wrap the only Solution? Or get search suggestion and latest updates.