Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 345
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 345
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i set up a excel program for seniors membership/dues, etc completely confused New Users to Excel 1 February 6th 08 03:22 AM
Determinig Population membership percentages Michele Excel Worksheet Functions 1 June 30th 06 05:57 PM
Help with spreadsheet to track membership dues... bigtime Excel Discussion (Misc queries) 0 May 3rd 06 03:07 PM
Group membership jamex New Users to Excel 2 March 9th 06 01:07 PM
can a membership card created in Publisher be exported to Excel? cq2 Excel Discussion (Misc queries) 2 March 10th 05 03:25 AM


All times are GMT +1. The time now is 11:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"