Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Membership List
When text wrapping addresses, phone #'s in a cell, looks right in print
preview, then prints data out of order. Thanks in advance. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Membership List
To help give guidance, give an example (e.g. is the address and phone # in
the same cell, what do you mean by 'out of order' ?) "Marge at large" wrote: When text wrapping addresses, phone #'s in a cell, looks right in print preview, then prints data out of order. Thanks in advance. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Membership List
phone numbers text wrapped in one cell as; 808-222-4444, (centered in cell)
310-444-2222 When checking it in "Print Preview" it appears correctly, when printed, it appears something like this; (left aligned) 808-222-4444 310- 444-2222 "Ron@Buy" wrote: - To help give guidance, give an example (e.g. is the address and phone # in the same cell, what do you mean by 'out of order' ?) "Marge at large" wrote: When text wrapping addresses, phone #'s in a cell, looks right in print preview, then prints data out of order. Thanks in advance. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Membership List
Unfortunately because of the constraints of this window, where we are typing,
your presentation of the #s is 'wrapping' and I am unable to ascertain what you are trying to achieve! Why are the phone #s 'wrapped'? What do you mean by 'it appears correctly'? My initial advice is to check the number of spaces between your two phone #s. If you want the second # wrapped below the first, put the cursor at the end of the first # and press Alt Enter (remove any spaces) this will place the second # on the 'line' below (then Format Centre). Also I have experienced that column widths are not always 100% truely represented in "Print Preview", try minor adjustments to your column width, this may help. Come back with further info if this doesn't work. "Marge at large" wrote: phone numbers text wrapped in one cell as; 808-222-4444, (centered in cell) 310-444-2222 When checking it in "Print Preview" it appears correctly, when printed, it appears something like this; (left aligned) 808-222-4444 310- 444-2222 "Ron@Buy" wrote: - To help give guidance, give an example (e.g. is the address and phone # in the same cell, what do you mean by 'out of order' ?) "Marge at large" wrote: When text wrapping addresses, phone #'s in a cell, looks right in print preview, then prints data out of order. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i set up a excel program for seniors membership/dues, etc | New Users to Excel | |||
Determinig Population membership percentages | Excel Worksheet Functions | |||
Help with spreadsheet to track membership dues... | Excel Discussion (Misc queries) | |||
Group membership | New Users to Excel | |||
can a membership card created in Publisher be exported to Excel? | Excel Discussion (Misc queries) |