Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Commas in Excel textbox moves my sentence to the next row
I am using Excel 2007. When I create a textbox in Excel and write several
paragraphs, what happens is that in a sentence with lots of commas, my text gets moved to the next row, even though there is plenty of room for some of the words to fit on that previous line. For example, if I write, "I am going to the store to buy fruits, veggies, candy, milk, ..." the part "fruits, veggies, candy, milk" all get moved to the next row. That leaves a huge gap in the previous line. What I do now is going to that line and pressing "Enter" to create a breakpoint. But the problem is, as my text gets editted, I have to go back and re-space all my sentences again. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Commas in Excel textbox moves my sentence to the next row
On Jan 25, 9:26 pm, Monica wrote:
I am using Excel 2007. When I create a textbox in Excel and write several paragraphs, what happens is that in a sentence with lots of commas, my text gets moved to the next row, even though there is plenty of room for some of the words to fit on that previous line. For example, if I write, "I am going to the store to buy fruits, veggies, candy, milk, ..." the part "fruits, veggies, candy, milk" all get moved to the next row. That leaves a huge gap in the previous line. What I do now is going to that line and pressing "Enter" to create a breakpoint. But the problem is, as my text gets editted, I have to go back and re-space all my sentences again. Hi. Are there spaces between your commas? If not then Excel will treat the whole thing as one continuous string. Regards, Matt Richardson http://teachr.blogspot.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link a value into a sentence in Excel? | Excel Worksheet Functions | |||
How to chose bold text in a sentence in Excel? | Excel Worksheet Functions | |||
Is it possible to insert a function within a sentence in Excel 200 | Excel Worksheet Functions | |||
How do I highlight a word or sentence within Excel? | Excel Discussion (Misc queries) | |||
Textbox moves position when Printing? | Excel Discussion (Misc queries) |