ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Writing beyond the cell specified size (https://www.excelbanter.com/excel-discussion-misc-queries/31512-writing-beyond-cell-specified-size.html)

Jean-Jerome Doucet via OfficeKB.com

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

Jean-Jerome Doucet via 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

Dave Peterson

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