 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007Line Spacing
I have a user that has a problem with line spacing that I cannot figure out. She has an Excel document that is emailed to her, and every so often, she has a line spacing that is about twice the size of the rest of the spacing in the document. I have tried to resize, but it doesn't save. Any ideas? Thanks.  SignatureManzy Hi, We really need more info, like the file when the problem is occuring. It could be that the is a macro in the file which is causing the problem. It could be that one cell on the row has word wrap applied automatically or manually. SignatureCheers, Shane Devenshire > I have a user that has a problem with line spacing that I cannot figure out. > She has an Excel document that is emailed to her, and every so often, she has > a line spacing that is about twice the size of the rest of the spacing in the > document. I have tried to resize, but it doesn't save. Any ideas? Thanks. I have checked for word wraping, but could not find any, and I selected the whole document, and tried to get the line spacing set, just the way I always do. I figured it has a Macro in the document that causes line 11, and line 52 to doublespace itself, but could not find the Macro. How do I see if Macros are in the document? Thanks... SignatureManzy > Hi, > [quoted text clipped - 8 lines] > > a line spacing that is about twice the size of the rest of the spacing in the > > document. I have tried to resize, but it doesn't save. Any ideas? Thanks. Perhaps those cells have a linefeed in them caused by Alt + Enter. Do you see a small square box in those cells? If so go to Edit>Replace What: ctrl + j With: nothing Replace all. Gord Dibben MS Excel MVP >I have checked for word wraping, but could not find any, and I selected the >whole document, and tried to get the line spacing set, just the way I always >do. I figured it has a Macro in the document that causes line 11, and line 52 >to doublespace itself, but could not find the Macro. How do I see if Macros >are in the document? Thanks... I did not see a small square box, but will go back and try that. Thanks so much. SignatureManzy > Perhaps those cells have a linefeed in them caused by Alt + Enter. > [quoted text clipped - 15 lines] > >to doublespace itself, but could not find the Macro. How do I see if Macros > >are in the document? Thanks... You keep saying document, and line spacing. These are not Excel terms but Word terms. This makes me wonder if you are looking at Excel or Word? In word we have Workbooks or worksheets and row height. Looking for small square boxes in cells does not always work, generally you see these squares if you have used Alt Enter but turned off word wrap. Also remember that Alt Enter can be done on an empty cell. Try selecting all blank cells on one of these rows and choosing Edit, Clear All. SignatureCheers, Shane Devenshire > I did not see a small square box, but will go back and try that. Thanks so > much. [quoted text clipped - 18 lines] > > >to doublespace itself, but could not find the Macro. How do I see if Macros > > >are in the document? Thanks...
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.