Welcome To Signs101.com: Largest Forum for Signmaking Professionals

Signs101.com: Largest Forum for Signmaking Professionals is the LARGEST online community & discussion forum for professional sign-makers and graphic designers.


  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Numbering labels

Discussion in 'Tips & Tricks' started by charlie62, Oct 3, 2012.

  1. charlie62

    charlie62 New Member

    May 28, 2010
    Don't know if any of you had to do this before, but this is how I do it quickly & easily.
    I use Corel Draw & Excell.

    1. Open the artwork in Corel Draw. Work on the full printable width of your media and create a lay out of as many labels as will fit and as many strips as you prefer.
    2. Number the first and the last label so you can see where the numbers should be.
    3. In Excell create columns of as many numbers as there are stickers per strip and then enough columns as you may need
    4. Use the correct type and size font.
    5. There is a quick way to do sequencial numbers in Excell - fill in the first 3 cells and then drag as far as necessary - this works vertically and horizontally.
    6. I found that, in order to get the numbers right, I have to make the first column in Excell one number more than necessary and then start column 2 with the same number that I ended with in column 1. When dragging horizontally, only select until the second last number in column 1 in order not to repeat any numbers.
    7. Copy the columns & paste in Corel Draw: edit + paste special + rich text format + maintain fonts and formatting + table outline : none
    8. Resize the pasted table to the same size as the area you are going to print.
    9. Copy/cut and paste over the artwork on page 1 of the Corel Draw document.
    10. Move the table until the first number fits exactly over the one inserted in step 2. Make sure the last number also fits the number on the last lable. Resize slightly if necessary. Delete the numbers you inserted in step 2. Export the file to your printer.
    11. The next set of numbers to be printed is easier - repeat step 7, resize to the exact size as the first table you've already done, paste and align with the first table.
    12. Delete the first table and export the labels with the new set of numbers to the printer.
  2. lazaros

    lazaros Member

    Feb 3, 2011

    Why not use the print merge feature in corel? i find it simpler...
    You can find it under the "File" menu...
  3. CanuckSigns

    CanuckSigns Very Active Member

    Nov 11, 2008
    Yeah print merge in Corel is pretty good, if you are just doing sequential numbers, you can eliminate excel completly.

Share This Page