Writing beyond the cell specified size

  • Thread starter Thread starter Jean-Jerome Doucet via OfficeKB.com
  • Start date Start date
J

Jean-Jerome Doucet via OfficeKB.com

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
 
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
 
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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top