Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make/Edit words in a row - how
Hi
I have a spreadsheet with the title of a painting in col a, medium in col b, artist name col c and price in col d. I use this spreadsheet as a data scource to create postcards, a single one for each painting, into Publisher. Problem is, some of the painting titles are too long to fit on one line in Pub and when they break, they either don't look right or make sense. I can't adjust the line breaks in Pub I need to adjust/break some of the painting titles over two lines while keeping the other relevant info associated Another prob is that I don't know which titles are going to need adjusted until I have actually completed a merge Anyone know how to make/setup the painting titles that are too long to automatically break across two lines please I do hope this is possible -- Martin ©¿©¬ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make/Edit words in a row - how
Try using <Alt <Enter to create line breaks of your own choosing.
-- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- <Martin ©¿©¬ @nohere.net wrote in message ... Hi I have a spreadsheet with the title of a painting in col a, medium in col b, artist name col c and price in col d. I use this spreadsheet as a data scource to create postcards, a single one for each painting, into Publisher. Problem is, some of the painting titles are too long to fit on one line in Pub and when they break, they either don't look right or make sense. I can't adjust the line breaks in Pub I need to adjust/break some of the painting titles over two lines while keeping the other relevant info associated Another prob is that I don't know which titles are going to need adjusted until I have actually completed a merge Anyone know how to make/setup the painting titles that are too long to automatically break across two lines please I do hope this is possible -- Martin ©¿©¬ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make/Edit words in a row - how
On Sun, 13 May 2007 08:15:39 -0700, "Ragdyer"
wrote: Try using <Alt <Enter to create line breaks of your own choosing. Thank you very much Ragdyer So easy when one knows how -- Regards Martin ©¿©¬ |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make/Edit words in a row - how
You're welcome, and appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- <Martin ©¿©¬ @nohere.net wrote in message ... On Sun, 13 May 2007 08:15:39 -0700, "Ragdyer" wrote: Try using <Alt <Enter to create line breaks of your own choosing. Thank you very much Ragdyer So easy when one knows how -- Regards Martin ©¿©¬ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make it so only specific words can be typed in a cell | Excel Discussion (Misc queries) | |||
How do i make certain words automatically bold themselves. | New Users to Excel | |||
Make words imported into numbers, ex SMRC=303 | Excel Discussion (Misc queries) | |||
Help to edit (bold, colour etc) words in a text box created by control toolbox | Excel Discussion (Misc queries) | |||
Can you make a crossword puzzle by putting the words in? | Excel Discussion (Misc queries) |