| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge cells
I have an excel spreadsheet where the first column is frozen. In cell A1 we
enter our project name which always ends up overflowing into the next cell. This is what we want but when we scroll to the right the rest of the text from cell A1 stays in A2. How can I have the text in cell A1 continue inot the proceeding cell even if I scroll to the right? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge cells
Hi,
It won't do this if you Wrap your Text, but it will make you row height larger. -- Regards Warren If this helps please click the Yes button. "Hollister" wrote: I have an excel spreadsheet where the first column is frozen. In cell A1 we enter our project name which always ends up overflowing into the next cell. This is what we want but when we scroll to the right the rest of the text from cell A1 stays in A2. How can I have the text in cell A1 continue inot the proceeding cell even if I scroll to the right? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge cells
Is there a formula I can enter that will carry the remaining text into the
next cell? "Warren Easton" wrote: Hi, It won't do this if you Wrap your Text, but it will make you row height larger. -- Regards Warren If this helps please click the Yes button. "Hollister" wrote: I have an excel spreadsheet where the first column is frozen. In cell A1 we enter our project name which always ends up overflowing into the next cell. This is what we want but when we scroll to the right the rest of the text from cell A1 stays in A2. How can I have the text in cell A1 continue inot the proceeding cell even if I scroll to the right? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge cells
Can you give an example?
-- Regards Warren If this helps please click the Yes button. "Hollister" wrote: Is there a formula I can enter that will carry the remaining text into the next cell? "Warren Easton" wrote: Hi, It won't do this if you Wrap your Text, but it will make you row height larger. -- Regards Warren If this helps please click the Yes button. "Hollister" wrote: I have an excel spreadsheet where the first column is frozen. In cell A1 we enter our project name which always ends up overflowing into the next cell. This is what we want but when we scroll to the right the rest of the text from cell A1 stays in A2. How can I have the text in cell A1 continue inot the proceeding cell even if I scroll to the right? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge cells
Your A1 text spills over into B1........correct?
Column A is frozen in view..........correct? You scroll across and the text overflow disappears..........correct? That is because B1 is no longer visible. To see all the text in A1 either make column A wider or set wrap text in A1 Gord Dibben MS Excel MVP On Wed, 5 Nov 2008 08:41:02 -0800, Hollister wrote: I have an excel spreadsheet where the first column is frozen. In cell A1 we enter our project name which always ends up overflowing into the next cell. This is what we want but when we scroll to the right the rest of the text from cell A1 stays in A2. How can I have the text in cell A1 continue inot the proceeding cell even if I scroll to the right? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I merge cells into one then delete the original cells? | Excel Worksheet Functions | |||
| Merge of cells | Excel Worksheet Functions | |||
| Merge Cells | Excel Discussion (Misc queries) | |||
| Merge Cells | Excel Discussion (Misc queries) | |||
| How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
Linear Mode
