Word Wrapping in Excel

I am having trouble with Word Wrapping in Excel.  It does not adjust th
row height properly.  I have tried Format, Rows, AutoFit and it stil
doesn't work.

Help, pleas

Mandy11's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1300
View this thread: http://www.excelforum.com/showthread.php?threadid=27632

11/8/2004 6:31:27 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 4

do you experience this with merged cells. If yes->nothing you can
really do about this without using vBA

Frank Kabel
Frankfurt, Germany

Mandy11 wrote:
> I am having trouble with Word Wrapping in Excel.  It does not adjust
> the row height properly.  I have tried Format, Rows, AutoFit and it
> still doesn't work.
> Help, please

frank.kabel (11126)
11/8/2004 6:49:50 PM

Similar Artilces:

Excel No Longer Working
Ok. This one has me stumped. I have adding the compatibility pack to systems in my office with no problem, until yesterday. Added the pack to an Office 2003 Pro system. Everything works great except for Excel. Now when we start excel it acts like it is trying to do an initial setup, then says it needs the disc. I put the disc in, but it will not find the CAB file. Weirder than that is every time I retry it the CAB designation changes. I have tried to do a repair and the same thing happens. I have tried a reinstall and the same thing happens. Anyone have ANY ideas???? I don't know...

Excel Mass Email
Does anyone know of anyway or program to do the following: We have Excel file that contains 3 columns- ID, password and email address. We need to email each ind email address their ID and password. Is there a program that we can use that will do this email merge? Thanks! Hi Jill Try this example on my site http://www.rondebruin.nl/mail/folder3/message.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jill" <anonymous@discussions.microsoft.com> wrote in message news:09b701c49fdc$32c52960$a601280a@phx.gbl... > Does anyone know of anyway or program to do the follow...

scale to page error in Excel 2007
somehow something has changed in my Excel 2007 setup where my "fit to scale" does not work appropriately. When I choose print preview, the preview screen changes to a very small preview and my document is a few thousand pages. This document used to print fine on one page. Even on my other computer it prints fine. The funny thing is, when I change it back to 100% scale the preview is large again but still cuts off a few columns. I must have changed some setting that I need to reset but cannot find it. Any help is appreciated. Have you checked your setting of print ...

How do I have excel highlight days before & after a date on a cale
How do have excel highlight 15 days prior to a chosen date on the calendar below & 30 days after? 2010 JANUARY FEBRUARY S M T W T F S S M T W T F S 1 2 1 2 3 4 5 6 3 4 5 6 7 8 9 7 8 9 10 11 12 13 10 11 12 13 14 15 16 14 15 16 17 18 19 20 17 18 19 20 21 22 23 21 22 23 24 25 26 27 24 25 26 27 28 29 30 28 31 MARCH APRIL S M T W T F S S M T W T F S 1 2 3 4 5 6 1 2 3 7 8 9 10 11 12 13 4 5 6 7 8 9 10 14 15 16 17 18 19 20 11 12 13 14 15 ...

Excel chart-y axis title question
Everytime I have a y axis title and it will not show up the end of the title. I tried to use small font but it doesn't help. Does anyone ever have similar problem? Thanks. Many people have reported this problem, and the following post by Jon Peltier may help you: http://groups.google.ca/groups?&threadm=OviGl8Z3EHA.208%40TK2MSFTNGP12.phx.gbl springwinterfall wrote: > Everytime I have a y axis title and it will not show up the end of the title. > I tried to use small font but it doesn't help. Does anyone ever have similar > problem? Thanks. -- Debra Dalgleish Ex...

Tabbing to non sequenced cells in Excel 2000
Can I tab over to only cells that need info input, and skip over other cells? If you protect the worksheet that will happen. While holding down the CTRL key, use the mouse to select the cells you wish to tab through Select Format/Cells and unselect "Locked" on the "Protection" tab Then go into Tools/Protection and select Protect Sheet Now, if you don't use a password, anyone will be able to simply unprotect the sheet as needed and have the "tabbing" capability. "cwalton" <cwalton@discussions.microsoft.com> wrote in message news:1783FC04...

Can I draw a tangent to a line in graph in Excel?
I want to draw a tangent to the beginning of a line in my graph, and then get the gradient of that tangent. Can Excel do that? I trust that you're using an XY chart, not a line chart, for this exercise. One approach, if you want to manually draw your own "bets" line, would be to add an XY series with two points, the first point being at the point of the first series where you want the tangent. Select the other point of this added series (two single clicks: one to select the series, one to select the point). When the cursor goes over the point, it becomes a four-headed arr...

Open Word Document With Modify Password
Using VBA to open Word documents. I get a prompt if the document requires a password to modify. I would like to use VBA code to open read only and search the document without being prompted -- going through hunders of documents and if certain info is found the file is logged. Current code: Dim rstDoc As New ADODB.Recordset Dim objWDApp As New Word.Application Dim objDoc As Word.Document rstDoc.Open "FileList", Application.CurrentProject.Connection, adOpenKeyset rstDoc.MoveFirst On Error GoTo DocumentErrors Do While Not rstDoc.EOF ...

Can Excel 2003 Do This?
Thanks in advance for anybody that can help me with this... Here's what I want to do: I have a workbook that I have recreated in excel for my boyfriends work. One of the sheets is a weekly production report that he sends in to his employer to get paid. There is a separate sheet that has a list of available units with three columns; 1)Unit ID, 2) Description, 3)Unit price. I would like to somehow make it so all he has to do is type in the Unit ID on the corresponding cell on the production report and have it automatically fill in the correct description, unit price & when he enters t...

Excel URL's
I'm reposting this message as the recommended action didn't work, and I cannot reply to his post ... ========================================================== Hi, If I have an Excel s/s that contains multiple fields with live URL links, is there a way to deactivate the link? I'm working with such a s/s presently, and its frustrating as I inadvertently trigger URL links constantly!! Public Sub DeleteHyperlinks() ActiveSheet.Hyperlinks.delete End Sub -- Regards, Tom Ogilvy "Don Niall" <donniall@aol.com> wrote in message news:09ad01c37d3a$44e9e420$a001280a@p...

Excel Macro Conversion
Hi, I'm going to be teaching Excel VBA to an organization who currently uses the older Excel macro language. I know Excel and I know VBA and but I don't the pre-VBA language. The company has emailed me a workbook that contains a sales spreadsheet. Their goal is to convert the older macros to VBA. I'm looking at the spreadsheet now and I don't see any macros except this long string out to the side. Looks like this: /WTC{HOME}{PGDN}{GOTO}A18~{GOTO}A20~/WTH{GOTO}A19~{END} {DOWN}{DOWN}@DATE({?},{?},{?})~{RIGHT}{?}{RIGHT}{?}{RIGHT} {?}{RIGHT}@DATE({?},{?},{?})~{RIGHT 3...

CDs and learning excel
Can anyone advise on a good/better/best instructional CD to learn Excel? ...

In Excel
-- Jerry ...

I have lost my menu bars in Excel?
I am not sure if I have opened a corrupt excel file or what but now when I open my excel there are no menu or tool bars (not hidden from view, but gone) I have tried re-installing excel but this did not fix the problem. What is going on? View / Full Screen perhaps? Try finding and deleting your *.xlb file which is the toolbar customisation file -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to b...

Adding highlighted cells only -Excel 2000
Anyone know if there is a way to add only cells that are highlighted? I would like to see quick sums of only the cells I have highlighted and hoping there might be a way to do this quickly and easily. I have to do this many times with various cells with differing number values. Thanks in advance K By "highlighted" do you mean colored or simply selected? If the latter, use the Sum on the Status Bar. If the former..................... You will have to use VBA to grab the colorindex of the cells. Do you want to do that? See Chip Pearson's site for UDF's for working with co...

Missing function in Excel 2003 #2
I have a user that is complaining about a missing function in Excel 2003. He calls it a "Coalition matrix", I have never heard of it before. He used to have it in Excel 2000. Any ideas? Hi never heard about this. Maybe he has to install the Analysis Toolpak Addin ('tools - addins'). "Galldrian" wrote: > I have a user that is complaining about a missing function in Excel > 2003. He calls it a "Coalition matrix", I have never heard of it > before. He used to have it in Excel 2000. Any ideas? > Never heard of a coalition matrix. The Analysi...

EOMonth function V. 2002 excel
I just recently starter using Excel 2002. I was using Excel 2000. My spreadsheets that use the function "EOMONTH" no longer work . It's not even available the list of functions. Is an addin available? Thanks Tools>add-inns, check analysis toolpak, keep the cd handy and follow the instructions -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "JohnD" <anonymous@discussions.microsoft.com> wrote in message news:06d301c4be20$0d732f60$a501280a@phx.gbl... >I just recently sta...

How can I convert a number to english text in Excel
Is there a way to convert an certain number, to english text in Excel. For eg. An invoice total of $1000 shoul also appear in words (Dollars One Thousand) Hi, See the following: http://longre.free.fr/english/ http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704& http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360 http://www.bygsoftware.com/examples/examples.htm http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip Also check out the following add-in by astien Mensink http://www.asap-utilities.com/ Super utility one of the functions converts numbers to text lik...

HyperLinking PDF files in Excel
Can anyone offer any help on 1. is it possible to import pdf files into excel as hyperlinks? and 2. if it is possible, how do you do it? =) A hyperlink is as it says, a link to a file either on the local drive or a network which is mapped to the local pc. It is not an imported file, just an address which when pressed will open the relevant PDF document with a PDF Viewer. To insert a hyper link, select from the top menus. Insert\Hyperlink (Hyperlink is at the bottom of the insert menu itme) This will then show a pop up box which will allow you to identify where the PDF file is to be ...

Excel is defaulting to Number format instead of General format
The programme for 2007 has recently been installed, and my cells are all formated to Number instead of General, and Excel won't let me change it back to General. We tried to uninstall and re-install but this did not help. Maybe you have a workbook template file named book.xlt (or .xltx or .xltm) in your XLStart folder. This template file is used as the basis for starting new workbooks. You could try to edit it (and change the number format) or move it (or delete it). Then restart excel to test. Kim wrote: > > The programme for 2007 has recently been installed, a...

opening a word 2003 document with word 2007
I created some documents on Word 2003 and have been unable to open them with Word 2007. I tried saving them as .docx and .rtf on Word 2003 with no luck. The posts that I have seen thus far have not helped. Does anyone have any suggestions? What happens when you try? Word 2007 should have no difficulty opening Word 2003 documents or RTF documents. Word 2003 can only save docx format if it has the compatibility pack installed. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word...

Excel Cell Formatting, multiple lines
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Is there a way to force a line wrap within a cell in Excel, similar to the way Shift^Return forces a line wrap in a table cell in Word? Control+Command+Return as well as Control+Option+Return. Have a look in Excel Help for others: Keyboard shortcuts used in Excel. HTH |:>) Bob Jones [MVP] Office:Mac On 5/22/10 1:51 PM, in article 59bb8db7.-1@webcrossing.JaKIaxP2ac0, "IHS@officeformac.com" <IHS@officeformac.com> wrote: > Version: 2008 Operating System: Mac OS X 10.6 (S...

Word document format marks
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel How do I hide format marks in my Word documents. Docs show paragraph marks, tab marks, etc. They do not print when I print the document. One day I was typing and accidentally hit a key or key combo and there they were. You can simply click on the �-icon in the Standard toolbar (it looks like an inverted "P"), or, if you prefer using the keyboard, hit Cmd+8. On 30/03/10 15:52, DrJ117@officeformac.com wrote: > Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel > How do I h...

How do I change the words that pop up when curser is over pic?
I am using Publisher and when I am sending the document words are poping up over different sections and pictures when the curser is over it. How can I change the hidden words and or remove them? Thanks for your help Is the publication a Web page? -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx "Avi" <Avi@discussions.microsoft.com> wrote in message news:A7A43858-44DB-420B-97C7-EC87213F7AC3@microsoft.com... >I am using Publisher and when I am sending...

Excel: How do I group columns?
How do I group columns? And how do I compare data in columns, highlighting like data? Thx Steve Hi Steve not sure what you mean by 'group' - there is an option under the data menu called group & outline / group which is basically an alternative to hiding columns? is this what you're after? as for comparing data in columns - check out http://www.cpearson.com/excel/duplicat.htm -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Steve" <Steve@discussions.microsoft.com> wrote in message news:4C4C5B35-9A81...