![]() |
Writing beyond the cell specified size
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 |
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 |
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 |
All times are GMT +1. The time now is 02:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com