auto fill weekdays only does not work

[Guest]

Type in the date in a cell 8/25/2004 then highlight it, click
edit,fill,series,row,date, weekday and leave the step at 1 or even delete it
either way click ok go back to cell little black cross at bottom right drag
down and it fills with consecutive days not weekdays. Have tried every
variation multiple times. Cleared the contents. Went to new sheet. Tried the
little auto fill options box that apperars nothing works. Any suggestions.
email me at (e-mail address removed) TX

 

[Guest]

Try this:
Type the date.
Select the cell with the date and all the cells you want filled with a date.
Then, go to Edit|Fill, Series, etc.
Choosing "Rows" makes it fill across a row, so switch to Column, if you want
to go down a Column.
I just tried this and it works in Excel 2003, at least.

tj

 

[RagDyeR]

I hate to be the one to say this, but ... you just *don't know* how to do
it!

Here's a couple of ways:

ONE:
Enter the date in a cell,
*Right Click* on the fill handle and drag down as needed.
When you release the mouse button you'll see a pop-up menu.
Just click on your choice, one of which is "Fill Weekdays".

TWO:
Enter the date in a cell.
Click in the cell and drag down the *selection* as needed.
*DO NOT* use the fill handle !
NOW, do your <Edit> <Fill> <Series>
THEN click on <Columns> <Weekday> <OK>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Type in the date in a cell 8/25/2004 then highlight it, click
edit,fill,series,row,date, weekday and leave the step at 1 or even delete it
either way click ok go back to cell little black cross at bottom right drag
down and it fills with consecutive days not weekdays. Have tried every
variation multiple times. Cleared the contents. Went to new sheet. Tried the
little auto fill options box that apperars nothing works. Any suggestions.
email me at (e-mail address removed) TX