Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I put numbers in order into each cell of a worksheet?
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. 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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I put numbers in order into each cell of a worksheet?
Kenny
See comments in-line................ On Tue, 17 Apr 2007 12:24:04 -0700, 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? A cell can contain data or a formula. You want each cell to also be numbered like 001, 002, 003 etc.? In A1 enter 1...........right-click and drag down then release and "Fill Series" Format these cells as Custom 000 But where will you be entering your schedule info? 001, 002, 003, etc. I have excel 2003. Also, how do I put the day/date for each sheet on the top of each sheet? One Where at the top of the sheet? In a cell? sheet is for one day, but I need for each sheet to have the correct day/date on it, How does Excel decide which is the correct day/date? and I want to be able to print a month at a time. You want to print all the sheets for each month? I am not sure what you want here. Could you provide more detail or wait for one of the psychics to drop in with some suggestions. Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add/count numbers in the same cell in excel worksheet? | Excel Worksheet Functions | |||
Rearrange numbers from a column in a different order in a second c | Excel Discussion (Misc queries) | |||
Worksheet 1 exact copy of worksheet 2, but in different order | Excel Discussion (Misc queries) | |||
Transpose and order array numbers | Excel Worksheet Functions | |||
assign cell selection order in protected Excel worksheet | Excel Discussion (Misc queries) |