number

How to easily make custom numbered Raffle Tickets with MS Word and MS Excel



Sharing buttons:

much for joining substantially they can

very easily create these raffle tickets

then used to create for an upcoming

raffle we have at our elementary school

they look at Lake Chelan which is a

fabulous place if you're ever in the

Washington area with generous generous

enough to donate a weekend away and as

you can see here very easily created I

think a little over a hundred lottery

tickets within a matter of minutes using

nothing but Microsoft Word and Excel

alright so before we get started I do

want to point out that I do have a

YouTube channel which has lots and lots

of printables and most importantly it

does have these certain fonts installing

and using symbols if you do not know how

to download and install new fonts and I

use a font that you do not have default

on your computer please watch that video

to learn how to do that subscribe to my

channel and or like any and all of my

videos that would be so appreciative

alright so let's go ahead and get for it

first thing we want to do is go to file

new blank document you don't want to go

to page layout go to marketing to go to

narrow we then want to go to insert

picture oopsies I'm so sorry insert

shape and we want to insert a rectangle

again I did shape and I did a rectangle

insert shape rectangle and then you can

click anywhere on there once you do that

you can see the distance listed because

it has a little squares around it and we

want to go up to format and we want to

make this 2.5 by 4 size pretty average

for a raffle ticket and then you can go

ahead move the filled up furnace you

then want to click on format' do a shape

0 of no fill a shape outline of black

and we want to do a weight of this is

two and a quarter car next what we want

to do is create this part of the ticket

we then want to go through and we wanted

to insert text box and we want to draw a

text box and we can kind of draw it

anywhere in there but what we want to do

is go up to this format and we want to

make this 2.5

by 2.3 we then want to click on format'

do a shits out of no film more

importantly we want to do a shape

outline of three and a quarter and we

want to do the dashed lines right here

and that's going to create that sort of

dash line bit so here that's right when

a weekend okay land now if you notice

here the spacing is a bit big so I'm

going to highlight that text get a home

click on line spacing options and we

want to go down to zero and

single-spaced press ok okay

we don't want to go and we want to

highlight this and we want to Center

this and then we want to change the font

and we want to make this trip

I believe it's culturally Desha I'm not

sure but I think that's the trading Shea

ask again if you don't have that default

please watch my video and in down that

and download that fonts and this is 12.1

and this is actually constellar font and

this is a 14 point font alright once we

have value to kind of enter to make that

a little bit longer process here a few

times and then some here we want to do

name those you know and again if you

want to add address you can add address

but what we want to do is we want to not

Center this but align left and again we

want to add that same at trebuchet but

we want to make that ten point one and

obviously we want to add some space

people too right now we want to add

those lines so we want to hold down our

Shift key go put your cursor next to

name hold down the shift key and click

on the underlined and that's it pretty

easy hold the shift key click on the

underlined my underline is found next to

the zero key on my keyboard firm your

keyboard could be different

I can hold down the underline okay

finally we want to click up here and we

want to insert our pcs we're going to

insert pixel we're going to go to

desktop we're going to go to wrestle and

we're going to find our East Gate PTA

logo we want to right click and we want

to do rap text we want to do behind text

we obviously want to make this much

smaller and we want to change the color

to gray and we want to click the

corrections to make this much lighter

and then finally we just want to move

this in the middle finally let's add our

actual ticket portions we want to do

insert text and what did you draw a text

box and let's just make this text box

right there and we want to click on

format' do a shape fill of no fill and a

shape outline of no outline for that

text box when a you can actually amazing

and it really is amazing

see okay then and once again we want to

highlight this go to our home click on

this line spacing options and we want to

make this zero and single spaced we then

want to Center this and once again we

want to change the font is that

trebuchet ms' and this is casteller and

this is a 14 point font

and from here we want to do and enter

for the look out at Lake Chelan

okay get treatment just a little bit

further down just not quite so far right

alright and then from here we can go

ahead and press enter but what we want

to do is actually change the fonts to

Calibri and a 10-point font and we're

going to press enter one more time and

the reason we want to change our plan is

because if this is a 14-point one it's

going to make the spacing bigger so we

want to sure to change up to Calibri

we'll change this up

well you 14:17 and we can add our little

flowers moon in the comment and we can

make this bold and then from here we're

going to go back and I'm just going to

copy some of the Burbidge that was given

to us from our amazing partners at to

look at a little and and and that's it

to create this oh we do need the logos

that's right we want to do an insert

picture and let's take a look out and

once again we want to do behind text we

want to make this much smaller and we

want to change the color to black and

white we want to move this right over

here and we want to once again click

over here do an insert picture click on

our PTA logo once again we want to do

behind text move this up here against

with all I'm kind of going fast because

we have a lot to show you and I have

already showed you this part make this

smaller and we want to change the color

to black and white and we want to move

this right over here

now finally we want to add in those

numbers so we want to insert text box

draw our text box we want to draw the

text box right here and we're going to

write in number period and we're going

to leave the rest of it as a space okay

we also want to do a shape fill of no

Phil shade line of no outline and I want

to change this font what I used is the

modern number 20 okay from here we can

write with this we can right click on

this text box and click on copy go up

here and click on paste and we want to

move this right down here because

obviously need the numbers twice now the

last type is last part before we copy

and paste is we want to insert shape we

want to insert the line we want to go

hold down the shift key and do that line

right there we want to do is shave

outline a black the weight of one and we

want to do sort of that on both sides

okay so that is it to create the outline

of this now let's go and copy and paste

this and add a numbers so in order to

copy and paste this multiple times in

the sheet you're going to press ctrl a

and that is going to select all then you

want to press ctrl C for copy ok from

here you want to press the Enter key to

move this one down you want to go back

up to the top and press ctrl or control

V okay move your arrow key down here

both control Z all right and again you

can always press the Enter key if you

need to move these around so now we have

three on one page again if you played

with the spacing or maybe bigger or

smaller your pipe it fit four or five or

six now we need to fill in these numbers

here's where you need Excel okay we're

going to go ahead and open up Excel a

new blank workbook okay because we have

three per page we need to use three

different columns if we have four

tickets per page we would need four

columns if we had five tickets per page

we would need five columns but what we

essentially do is have the numbers go

one two three four five six and this

column we increment is three so what we

want to do is we want to do an equal

sign open parenthesis three plus we want

to do this so and again you just

highlight that cell where you could type

in a one and you end parenthesis it's

very important and parentheses then you

just press the Enter key again equals

open parenthesis three plus

be two and parentheses enter key equals

open parentheses 3 plus highlight the

cell or you could even type in c1 and

then the enter key okay now all you need

to do is go to the bottom right hand

corner hold down the left click button

and go down to as many as you want this

is showing you how to make 72 but again

you can you can do this version as many

as you want okay now the next thing is

you can see here that these are actually

from values these are formulas not

actual data number so what we want to do

is change these formulas to data numbers

so what you want to do is you want to

highlight

left click do a copy okay and then you

want to highlight and you want to do a

left click and you want to do paste

values you see that little 1 2 3 the

second you just want to do paste values

now as you can see these are actual data

values finally we want to add 2 0 0 1 0

0 2 0 0 3 so you want to highlight all

of these and you click on more number

formats and again this is under the Home

tab and then from here you get a custom

click on this and you just type in if

you want this to be a thousand or 10,000

you can do that so you want to make them

up to 10,000 all right now we have our

formats so one more step before we save

is we want to do inserts and we were to

say now you ticket won two tickets one

ticket

two tickets three okay

from here we want to say file save as my

computer save this in a raffle and this

is very important you want to save this

as csv comma-delimited okay and let's

say this as raffle data yes okay now we

want to go up and we want to close and

we can save it again we already saved

this both mean I just like saving again

okay again very important to close out

Excel document now from here what we

want to do is click on to mailings and

we want to click start mail merge and we

want to do step by step wizard now over

to the right we can go ahead and click

on letters up sign current document is

what we want and we want to browse for

the data set again use an existing list

we want to go to our desktop we want to

go to our raffle and again we call this

raffle data here's the data that we want

this looks perfect

then we just press ok next write your

letter okay now again you want to click

on that first raffle ticket and you want

to hit it a space between a number and

then you want to go click on more items

from here we want to do take it one now

from here we want to do take it one now

from here you want to click on the more

items and we want to do is you could

imagine ticket to and from here you

Wendy widens and ticket to and then from

down here

we want to click on more items to get

three and from here more item to get

three and then we want to go to next and

we want to complete and then we want to

print okay very important what you can

either print to a printer or I like to

print a PDF so I can see what it's going

to look like and we want to call the

gospel ticket dot PDF okay let's wait

while this is printing and let's go

ahead and go to our desktop and let's go

ahead and go to our raffle and let's go

ahead and open up our raffle ticket so

now we can see here I'll just paste and

got a little off but you could easily

play with that zero zero one zero zero

two zero zero three and we have our

raffle ticket okay thanks so much for

watching and if you found useful please

like this video watch in any and all of

my videos like the mama subscribe to my

channel and I do monitor the chat lines

often if you have any questions or

comments please feel free to comment

thanks so much and I hope you did find

this useful

bye