HOW TO KEEP TEXT FROM MOVING OUT OF A CELL?
 

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. ?

HOW TO KEEP TEXT FROM MOVING OUT OF A CELL?
 

format/cell/alignment tab/check wrap text.
Bob Umlas
Excel MVP

"Briguyy" wrote in message
...
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. ?

HOW TO KEEP TEXT FROM MOVING OUT OF A CELL?
 

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.



Briguyy wrote:

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. ?

--

Dave Peterson