Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I want to write text or numbers that are larger than the specified space in the Excel form. I would like them to continue appearing onto the next cell, next to the first one. Actually, it just hides when it has no more space. How would that be possible? Thx! Jean-Jérôme Doucet -- Message posted via http://www.officekb.com |
#2
![]() |
|||
|
|||
![]()
I found the way to do it myself hehe. The answer is the amalgamate cells
function. You select the two cells and in the properties, you notch this option. Bye! JJD -- Message posted via http://www.officekb.com |
#3
![]() |
|||
|
|||
![]()
If you're typing text into a cell and it's too large for that cell, then it
overflows to the adjacent cells (to the right)--unless there's something in that adjacent cell (Or you have Text Wrap turned on). If you're typing numbers, they have to fit into the cell. (You can precede the number with an apostrophe or preformat the cell as text--but then the number isn't a number--it's text.) "Jean-Jerome Doucet via OfficeKB.com" wrote: Hi, I want to write text or numbers that are larger than the specified space in the Excel form. I would like them to continue appearing onto the next cell, next to the first one. Actually, it just hides when it has no more space. How would that be possible? Thx! Jean-Jérôme Doucet -- Message posted via http://www.officekb.com -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
Syntax for inferred cell references | Excel Worksheet Functions | |||
Cell addressing using the content of another cell. | Excel Worksheet Functions | |||
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions |