Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell entry carryover to next cell
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell entry carryover to next cell
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. -- Gary''s Student - gsnu200762 "Rick" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell entry carryover to next cell
B1 was clear. I cleared it again to be sure but it still didn't carry. What
else can I try? "Gary''s Student" wrote: 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. -- Gary''s Student - gsnu200762 "Rick" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell entry carryover to next cell
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 -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Rick" wrote in message ... B1 was clear. I cleared it again to be sure but it still didn't carry. What else can I try? "Gary''s Student" wrote: 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. -- Gary''s Student - gsnu200762 "Rick" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell entry carryover to next cell
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. Rick wrote: 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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell entry carryover to next cell
Maybe the text in that cell is not left aligned?
Rob "Bernard Liengme" wrote in message ... 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 -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Rick" wrote in message ... B1 was clear. I cleared it again to be sure but it still didn't carry. What else can I try? "Gary''s Student" wrote: 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. -- Gary''s Student - gsnu200762 "Rick" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a separate cell entry for every individual line in a cell | Excel Discussion (Misc queries) | |||
Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
stop cell entry being copied to other cell | Excel Worksheet Functions |