Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make text in Excel overflow? 1

Status
Not open for further replies.
jsteph

jsteph

Technical User
Oct 24, 2002
2,562
US
Hi,
I have a table in excel. I inserted a row above the column header-row of the table. I want to type some text in the new cell A1, and all it does is show the first word, since the width of the column A is the width of the first table's column--which I want to stay that way.

I've tried Format-->Cells--> merge text (with row 1 selected), I've tried Wrap text. I can't get it to overflow. The most frustrating thing is that at home, my copy of excel does that automatically (both are version 11), and I don't want it to do that in a particular sheet at home. At home I type and it just keeps going across the page, which is what I want here at the office.

Anyway, I looked at the Format of both the home and work spreadsheets, and all format properties seem identical.

Please help.
--Jim
 
Sort by date Sort by votes


Hi,

TEXT will display over adjacent COMPLETELY EMPTY cells.

NUMERIC data will not (including Date/Time)

What, specifically, are you entering in A1?

What is in B1?

What is the FORMAT of A1?

Skip,

[glasses] [red][/red]
[tongue]
 
Upvote 0 Downvote
Skip,
The format of a1 is Text, and there is nothing in any other columns of row 1--this is a newly inserted row.

I'm putting a long sql statement in this cell, and I just get the ############## for the width of the cell. Then I tried checking Wrap Text, and still the same.

I did get it to work, but it is a workaround--I selecte just the first row, columns a through h, and did merge cells, then pasted and it worked. But what I want is not to have to select these cells and click Merge--my text has line-breaks so I know how long horizontally the text should go, so I shouldn't have to wrap or arbitrarily choose columns a-h to get it to fit.

Am I missing some 'default' format here? Thanks,
--Jim
 
Upvote 0 Downvote


This is not JUST TEXT.

It is a FORMULA that contains your TEXT -- Correct?

Please EDIT the cell (don't just copy the cell), copy the contents and post.

I want to see EXACTLY what is in the Formula Bar.

Skip,

[glasses] [red][/red]
[tongue]
 
Upvote 0 Downvote
Oddly, I can't get it to reproduce. I'm thinking that maybe after all my fiddling I must have set some global option to the 'correct' way, or whatever way makes it work now.

Does it make a difference if it had been pasted into the formula bar as opposed to directly into the cell? I ask because when I was trying to reproduce I noticed it seemed to format differently when I pasted to the formula bar instead of the cell, but it still didn't give me the ####'s
Thanks,
--Jim
 
Upvote 0 Downvote
The ##### is just Excel's way of telling you the contents of the cell do not fit in the cell. If you increase the column width the #### should be replaced by a number.
 
Upvote 0 Downvote



??????

EXACTLY WHAT is in the Formula Bar?????

Please post.

Skip,

[glasses] [red][/red]
[tongue]
 
Upvote 0 Downvote
Below is exactly what I pasted into the formula bar:
Code: 
SELECT VCheckSumm.CsuPayPeriod, VCheckSumm.CsuEmpNumber, VCheckSumm.CsuSocNumber, VCheckSumm.CsuFlxIDEb, VCheckSumm.CsuFirstName, VCheckSumm.CsuLastName, VCheckSumm.CsuPSID, VCheckSummDed.CsdDedDesc, VCheckSummDed.CsdDedCurr FROM VCheckSumm INNER JOIN VCheckSummDed ON VCheckSumm.CsuFlxID = VCheckSummDed.CsdFlxIDCsu WHERE csupayperiod = '2006290' and (VCheckSummDed.CsdDedCode='PRSAV' Or VCheckSummDed.CsdDedCode='PRWD')
I don't know how tt will parse this, but there were no line breaks, just a long sql statement. When it was pasted in, it all went into one cell, and there was just a string of '#' as wide as the cell, but it did not flow to the next cell, even though, as it was a newly inserted row, all cells started empty.
--Jim
 
Upvote 0 Downvote
Text entries of 256 characters or more display as #### when formated as Text. Try General format
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
2K
Andrzejek
Andrzejek
BugZap13
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
444
bs6600
bs6600
techguy2010
  • Question
Excel macro to send e-mail to multiple agents with a different body for each 1
Replies
3
Views
367
techguy2010
techguy2010
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
1K
shytott
shytott
renigar
  • Question
Having trouble with Excel Lookup
Replies
5
Views
494
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top