Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jean-Jerome Doucet via OfficeKB.com
 
Posts: n/a
Default 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
  #2   Report Post  
Jean-Jerome Doucet via OfficeKB.com
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Function syntax to compare cell contents ES Excel Worksheet Functions 2 May 18th 05 03:53 PM
Syntax for inferred cell references donesquire Excel Worksheet Functions 4 April 4th 05 09:29 PM
Cell addressing using the content of another cell. De Jandon Excel Worksheet Functions 5 April 1st 05 10:59 PM
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. PboB Excel Discussion (Misc queries) 3 March 16th 05 06:17 PM
Returning a Value to a Cell Based on a Range of Uncertain Size amc422 Excel Worksheet Functions 7 November 14th 04 03:03 PM


All times are GMT +1. The time now is 02:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"