 |
 | 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 / May 2008Column Formatting Question
Hello, Using an older version, MS Excel 97 Some simple stuff, but I have a single column of numbers that for some reason, is taking up two row spaces, while everything else is taking up the normal single row. Probably due to my playing around with the formatting, somehow How do I get this column to look like everything else ? Thank you very much, Bob Bob, Text will extend into the cell on the right if the cell on the right is blank. Cell formatting includes a "Wrap Text" setting that forces text into multiple lines. Check for this in... Format (menu) | Cells | Alignment (tab) | "Wrap text" checkbox When entering text in a cell, Alt + Enter forces text into a new line.  SignatureJim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Robert11" <rgsrose@comcast.net> wrote in message Hello, Using an older version, MS Excel 97 Some simple stuff, but I have a single column of numbers that for some reason, is taking up two row spaces, while everything else is taking up the normal single row. Probably due to my playing around with the formatting, somehow How do I get this column to look like everything else ? Thank you very much, Bob Hi, Thanks for help. Wrap Text box is Unchecked. The problem is not the number going into the adjacent right column. It is a vertical two rows in (just that) column that appears, and is taken up by the small numbers Other columns have the normal single line spacings; the number column is two row spacings high. Thoughts on ? Thanks again, Bob > Bob, > Text will extend into the cell on the right if the cell on the right is blank. [quoted text clipped - 20 lines] > Thank you very much, > Bob Columns have width, Rows have height. The column width is always the same for the entire column. The row height is always the same for the entire row. However, two or more cells can be "merged" resulting in the appearance of a single large cell that extends across rows or columns. You can check for that in the same place as Wrap Text. (select one of those "large cells" before checking) For what it is worth... posting unaltered email addresses in newsgroups can speed spam to your inbox. SignatureJim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Robert11" <rgsrose@comcast.net> wrote in message Hi, Thanks for help. Wrap Text box is Unchecked. The problem is not the number going into the adjacent right column. It is a vertical two rows in (just that) column that appears, and is taken up by the small numbers Other columns have the normal single line spacings; the number column is two row spacings high. Thoughts on ? Thanks again, Bob On May 19, 9:34 am, "Jim Cone" <james.cone...@comcast.netXXX> wrote: > Bob, > Text will extend into the cell on the right if the cell on the right is blank. [quoted text clipped - 20 lines] > Thank you very much, > Bob Hi, Yup, that did it. The unchecking of the "Merge Cells" box did the trick. Much thanks. Really appreciate your time and help. Bob |
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.