Help! Inserting numbers in excel cells

  • Thread starter Thread starter mollymabel
  • Start date Start date
M

mollymabel

I am typing up tickets for a raffle and there are already over a
thousand cells. I now want to insert numbers to them so that when they
print, each ticket has a number- 1 thru 1,500.
Anyone know how to do this?
Thanks! Molly
 
Are you using Excel? Are you printing 1 ticket per sheet? You can stick this
in the
Workbook_BeforePrint event:
Range("A1").Value = Range("A1") + 1
 
Molly,
You can use Excel's fill feature as follows:
1) Select a blank column for your series
2) Start the series in the first 3 rows (e.g. 1,2,3)
3) Select the entire ranges where you want the series
including your seed values (1,2,3)
4) Selet Edit | Fill | Series from the menu
5) Select the stop value, for you 1500
6) Click OK

Hope that helps and good luck with your raffle.
Rich
 
Molly,

I'm not sure if this is exactly what you want, but if all you
need is a column with numbers 1 to 1500

Put 1 in say F1
Put 2 in F2
Select both cells, grab the little square in the bottom right
of the selected cells (your cursor should turn into a cross)
drag down and it will increment the numbers
ie F3 = 3
F4 = 4
etc...

Dan E
 
Back
Top