text won't extend to adjacent cell

G

Guest

Hello, I am using Excel 2002. I have made my own payroll spread sheet in
excel, so I have text in a few of the various cells. My problem is this:
sometimes when I am typing text it will print all the text even if it goes
into the next cell. This is what I want. Other times my text printed is cut
off, like it is hiding the part of the text that would extend into the next
cell. I never know what cell is going to behave this way, its hit & miss. I
want it to type any text I enter, even if it goes into the next cell
(provided there are no numbers or formulas in the adjacent cell), so how do I
make it do this even when it doesn’t want to?
 
D

Dave Peterson

If the cell to right has something in it--including any formula, then the text
won't overflow.

If you have formatted your cell to wrap text (format|cells|alignment tab) is
checked, then the text won't overflow, either.

If you think that the adjacent cell is empty, select that cell and hit the
delete key on the keyboard.
 
G

Guest

The cell to the right had a blank space from the space bar typed in it. So
that fixed my problem, thank you so much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top