Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: making individual entries into labels

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a spreadsheet with several fields (columns), and I want to put each row onto a separate label. Problem is, the labels are the size of address labels, so rather than printing out a row: Col A Col B Col C Col D

    each entry needs to print out like this:
    Col A
    Col B
    Col C Col D

    in a table of entries. Is this possible? Should I give up now?

    Thanks for your help

    -wtreseder

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm not grasping your layout exactly, but with all of the formatting possibilities available within Excel, I'm most certain you can make it fit the way you want...
    What does your data look like?
    Thanks,
    Tom

  3. #3
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    My layout now has each row as a separate 'entry', with 7 columns of data going across. I'd like to put it in a format with the first two columns on row 1, the next three on row 2, and the last two on row 3, and then have the next entry start on row 5. Basically I need to change from:
    ABC
    ABC

    to:

    A
    B
    C
    A
    B
    C

    so that the data is organized differently when the spreadsheet is printed.

    Does this make any sense?

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sort of, but it's late...
    It seems that you should be able to refer to these column on another sheet to put them in the order you need.
    If you'd like, send me a sheet...
    Make sure there is a clear-cut example of before and after and I'll fix it up for you.
    Tom

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •