Share via

Excel Columns to 3/5 index card

Anonymous
2022-08-04T05:08:04+00:00

I'm trying to accomplish what I thought would be a very simple and straight forward action. But, it's proving me wrong, very wrong.

I have an excel spreadsheet consisting of a list of museums (one per row). There are columns containing: name, address, URL, phone, hours of operation, comments.

I want to print this information on 3/5 index cards, one museum per card.

I tried using mail merge and I can get pretty close but I can't step over the finish line.

I can get the labels to appear in the word document the way I want. When I print them, from the manual feed tray with standard sized paper, the text is shifted to the right. I need it centered because when I load the tray with the actual 3x5 index card, it's going to be in the center of the printer's paper path.

Is there an easier way of building a cell in Excel? There's one Word feature I'd like to use but I don't think Excel has it. On one row I'd like to put the phone number (aligned from the left margin) and the hours of operation (aligned from the right margin).

Thanks.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

15 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-08-06T20:33:39+00:00

    I figured it out. I don't know what was blocking me all this time. I think I tried to solve my issue by using page size and I couldn't get the printer and Microsoft to agree on printing it correctly.

    So, I fooled both into thinking they were printing on standard 8 1/2 x 11 paper and just played with the margins to get the page to the size and position I needed.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2022-08-06T12:58:05+00:00

    Dear Norman

    Regarding,

    "... I tried using mail merge and I can get pretty close but I can't step over the finish line." ...

    "... I need it centered because when I load the tray with the actual 3x5 index card, it's going to be in the center of the printer's paper path."

    ... "On one row I'd like to put the phone number (aligned from the left margin) and the hours of operation (aligned from the right margin)."

    We can only fit 4 Index cards in a regular paper size (Letter or A4).

    So we created a custom mail merge label template in the word document using an Excel Database.

    Image

    In the sample picture below we have the cards for 4 museums in New York.

    OBVIOUSLY, the final design is up to you.

    I just wonder how much of your above statements match the resulting Index Cards template in the picture?

    Image

    You may find in the following link a folder with the Word and Excel files with the above results https://we.tl/t-L8pC2QCpFa

    If you need more help

    Kindly suggest preparing and uploading the Word and Excel files and sharing the link here using the instructions in the following video.

    This will help us to give you a prompt and right solution to your problem

    Regards

    Jeovany

    https://www.youtube.com/watch?v=NnXsE0SNuCc&t=14s

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2022-08-04T20:29:51+00:00

    Hi there,

    If you are unable to find a means to upload directly here, you can upload to OneDrive instead and share the link here (remember to grant access to public view).

    Regards,
    Albert

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-08-04T17:50:35+00:00

    I realize my original post left a lot to be desired. I created a Word document with all of my actions and a PDF document with the results.

    However, I don't see the usual paper clip icon (or any icon or instructions for that matter) that allows me to attach them to this post. How do I do that?

    Thanks.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2022-08-04T06:19:07+00:00

    Hello Norman,

    Thanks for reaching out here regarding this query.

    Do you mean you want to adjust an Excel cell such that it prints out correctly with your preferred dimensions?

    Please, share an image description of the situation and perhaps what you're trying to obtain regarding the 3×5 index card.

    Warm regards,
    Albert

    Was this answer helpful?

    0 comments