Cell entry carryover to next cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick - 23 Dec 2007 17:29 GMT

I have created a four cell header on a worksheet. I entered the title of the
header in the second cell expecting it to carryover into the third cell but
it didn't, nor can I figure out how do it. On other cells it carries over
fine. I tried formatting the cell to general but that didn't work.
Suggestions please. Thanks, Rick

Reply to this Message

Gary''s Student - 23 Dec 2007 17:32 GMT

A cell will accept a carry-over only if it is empty. So if you have text in
A1 and want it to caarry-over to B1, clear B1.

Signature

Gary''s Student - gsnu200762

> I have created a four cell header on a worksheet. I entered the title of the
> header in the second cell expecting it to carryover into the third cell but
> it didn't, nor can I figure out how do it. On other cells it carries over
> fine. I tried formatting the cell to general but that didn't work.
> Suggestions please. Thanks, Rick

Reply to this Message

Rick - 23 Dec 2007 17:50 GMT

B1 was clear. I cleared it again to be sure but it still didn't carry. What
else can I try?

> A cell will accept a carry-over only if it is empty. So if you have text in
> A1 and want it to caarry-over to B1, clear B1.
[quoted text clipped - 4 lines]
> > fine. I tried formatting the cell to general but that didn't work.
> > Suggestions please. Thanks, Rick

Reply to this Message

Bernard Liengme - 23 Dec 2007 18:27 GMT

Select the cell with the text and the next cell; use Edit | Clear | all
Gary's Student is correct in what he told you so it must work.
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> B1 was clear. I cleared it again to be sure but it still didn't carry.
> What
[quoted text clipped - 12 lines]
>> > fine. I tried formatting the cell to general but that didn't work.
>> > Suggestions please. Thanks, Rick

Reply to this Message

RobN - 24 Dec 2007 10:46 GMT

Maybe the text in that cell is not left aligned?

Rob

> Select the cell with the text and the next cell; use Edit | Clear | all
> Gary's Student is correct in what he told you so it must work.
[quoted text clipped - 15 lines]
>>> > fine. I tried formatting the cell to general but that didn't work.
>>> > Suggestions please. Thanks, Rick

Reply to this Message

Dave Peterson - 23 Dec 2007 21:23 GMT

Make sure you don't have wrap text turned on, too.

And if your header is a number, precede it with an apostrophe or preformat the
cell as text.

Signature

Dave Peterson

Reply to this Message