View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
christielee christielee is offline
external usenet poster
 
Posts: 6
Default How do I put numbers in order into each cell of a worksheet?



"KennyD" wrote:

I need to place numbers in order into each cell. I am making a schedule where
I will write info into each cell, but each cell has to have it's own number?
001, 002, 003, etc. I have excel 2003.


in the first cell type the #1 then if you highlight the
cell so it's got the black border around it put your arrow to the bottom
right hand corner and your arrow will turn into a t click and hold and drag
down til you get to 30 or 31 days.


Also, how do I put the day/date for each sheet on the top of each sheet? One
sheet is for one day, but I need for each sheet to have the correct day/date
on it, and I want to be able to print a month at a time.


If you click on cell A1 click insert, select
header/footer then insert date and time you have to do this on each page then
you go back into the header and change the days. That's the only way i know
how to enter the date unless you type it into a cell and don't do the
Header/Footer.
Hope this helps.