Hi, this is Anne with Graphic Design How To, and today I'm going to show you
how to add numbering on tickets in Adobe InDesign. All right, let's get started.
So my end goal here is to have separate tickets that pull from a spreadsheet. So we'll be using
InDesign, Illustrator and Google Sheets for this. Ok, so I'm here in Adobe InDesign,
and I'm just going to create a new file. I'm going to come up here to Print, and then choose Letter.
And I just need one page. And I don't want facing pages, so I'm going to uncheck that.
And we'll Create. All right now my ticket is already created, and
it's in Adobe Illustrator. All right, so here's my ticket. I'm going to have a number here,
and the same number here. And then I'm going to have a lot of tickets, and they'll each have
a different number. So I'm going to go back to InDesign and place that file. So I'll hit CMD D,
or CTRL D. And here's my ticket file. I'm just going to click once so that it places it at
full size. And I'll just kind of center it up on the page, it doesn't really matter. Ok, so we're
good here for now. And now I'm going to make a spreadsheet. So let's head out to Google Sheets.
And I've got a blank spreadsheet now. And in A1, I'm going to type the word 'NUMBER'. Now
this is really important. You don't want this to be your actual first number. You just want
it to have kind of a title here. But underneath that, you'll have your first number. I want it
to be a six-digit number, and start with one. Now when I hit Enter or Return, it changes the
format of my number. So I need to get on that cell. And then come over here to Format>Number.
And I'm going to create a Custom Number Format. And I'm going to type it right up here. And it's
going to have six digits just like this, and I'll Apply. And this will give me the format
that I want. Now I've got 32 tickets to make. I need to copy this number down 32 times, so I need
to put another one in. So I'll put number two in. I'll have to change the format on this one
to my Custom Number Format, and Apply that, then I can select both. Get right on the lower right hand
corner. Sometimes you'll see a plus sign. It's not showing up for me right now. But you'll want that
plus sign. Click and drag all the way down to 32. And this will give you what you're looking for,
which is all the numbers between one and 32. And it looks like I need one more right down here.
The next step is to download this spreadsheet. So I'm going to come up here to File>Download
and CSV or comma separated values. When I do that, it'll go into my downloads folder,
or wherever you have set it up to go into if you're doing something like this from the web.
If you haven't changed it, it'll be Downloads. Ok, so let's go back to InDesign. And now I'm
going to bring up my Data Merge Window. So I'll go to Window>Utilities and >Data Merge. And now
I'm going to make a text box about that size, but I want it to be horizontal. So I'll hit T
on my keyboard and just draw a text box about that size. Now I'm going to come up to the Data Merge
flyout and choose Select Data Source. And we're going to navigate to that spreadsheet we saved,
and it should be in your downloads. So open that, and now you can see your title. So we have NUMBER
here. I'm going to click on that. And this is what we get. So I'm going to highlight this I can make
all my text changes. I want this to be centered. So I'm going to hit SHIFT CMD C or SHIFT CTRL C.
That's also in Paragraph right here. I'm going to change my text to Montserrat Bold, and I think
I want it to be this red color. I'm going to go back to Illustrator to get that because InDesign
does not like us to sample colors from a placed document. So I've got my A tool. I'll click on the
red letter and then double click my swatch. And I'm going to copy this color right down here. I'll
cancel that. And then go back to InDesign. And I'll double click on my text fill right down here.
And I'm just going to paste that color right here and say, OK. All right, this looks pretty good. So
now I want it to be in this spot, and this spot, so I'll rotate it. I'll hit E on my keyboard.
You can also hit R. E is Free Transform, and I'll just rotate it up like this.
And I'm going to zoom in and make this the same width as that white space and just
kind of center it up visually in the space. I'll zoom out with CMD minus or CTRL minus.
And then I'm going to copy this with SHIFT and OPT or SHIFT and ALT on a PC and put one right here
and we'll come back to my Data Merge Window and I'm going to hit Preview. So this is what our
first ticket looks like. We've got five zeros and a one and the same number right over here. So now
we can merge our document. I'm going to click this little Create Merge Document button right here.
And this will bring up this dialog box. We want to choose All Records. And instead of single records,
we want multiple records. I want a lot of tickets on one page, as many as will fit. And then I'm
going to choose Preview right down here. Now this is going to put it right up against that margin.
So if you want to change that, if you want it to be more centered, for some reason, you can unclick
this, make the settings the same button, and then increase the left margin. So this looks fine.
You can also increase the spacing between your rows. If you wanted to have a little more space
between them. I don't want any because it's kind of nice to just be able to cut right on that line.
Now, you might have noticed that this document is not set up for bleeds. And it really should be if
you're going to make tickets like this because the color is going off the edge. And if that's
ever happening, you want bleeds. But this tutorial is just to show you how to do the numbering. I'm
not worried about the bleed issue. So this is just a preview. I'm going to uncheck Preview,
and then I'll click OK. And now InDesign has made an actual document. You can see it has seven
pages. And if we get down here, we've got ticket number 23. And also has the same number here 24.
And like that. And so at this point, if this was a print ready file, all we need to do is just
export. And I would make this print PDF, and then print it to my printer, cut everything and be good
to go. And that's it. All right, if you liked this video and you want to see more videos like this,
just hit the subscribe button and the little bell next to it and you'll be notified every
time a new video comes out. All right, I'll see you in the next video. Thank you!!!