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 alright let's get started
[Music]
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
okay 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 command d or control 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 okay 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 numbers 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
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 but
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 1 and 32. 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 okay 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 fly out 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
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 command c or
shift control 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 place 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 okay
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 command
minus or control minus
and then i'm going to copy this with
shift and option or shift it alt on a pc
and put one right here and i'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 wanted 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 along
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 a print pdf
and then print it to my printer cut
everything and be good to go
and that's it all right if you like 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 alright i'll see you in
the next video thank you