HOW TO KEEP TEXT FROM MOVING OUT OF A CELL?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im using Excel to just put text in cells for a label im printing.
The problem im having is if i am in the cell and use the space bar to move
the text to the right it goes into the next cell and cuts it off. ( ie. Text
in cell C moving into cell B ).
Is there a way to lock the cell border so the text wont go into the other
cell and just drop down a line etc. ?
 
You can force new lines within a cell by hitting alt-enter where you want the
line to break.

If you want excel to determine where the line would break, then just turn on
wraptext.

Format|cells|alignment tab|check that wrap text box.
 
Back
Top