A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do I put numbers in order into each cell of a worksheet?



 
 
Thread Tools Display Modes
  #1  
Old April 17th 07, 08:24 PM posted to microsoft.public.excel.misc
KennyD
external usenet poster
 
Posts: 38
Default 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.
Ads
  #2  
Old April 17th 07, 09:14 PM posted to microsoft.public.excel.misc
christielee
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.

  #3  
Old April 17th 07, 09:17 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 22,912
Default 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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I add/count numbers in the same cell in excel worksheet? Brecken Excel Worksheet Functions 5 January 11th 07 07:44 PM
Rearrange numbers from a column in a different order in a second c Gaetan58 Excel Discussion (Misc queries) 14 November 21st 06 07:43 AM
Worksheet 1 exact copy of worksheet 2, but in different order Lou@CRA Excel Discussion (Misc queries) 1 July 11th 06 05:49 PM
Transpose and order array numbers cradino Excel Worksheet Functions 2 October 1st 05 06:27 PM
assign cell selection order in protected Excel worksheet tom92 Excel Discussion (Misc queries) 1 April 4th 05 05:57 PM


All times are GMT +1. The time now is 11:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.