Fill Weeks Excel 2003

August

Active Member
Joined
Jun 18, 2004
Messages
264
Hi there
it's a minor issue, but does any one know why there is no option to fill down "weeks" in Excel 2003. There's days, weekdays,months,years but no weeks. Or is there a way of adding weeks to the drop down menu

Just curious - - - Thanks
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
No, but if you enter the first 2 weeks and select those cells, you can just drag the fill handle down (or across).
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
49,473
Office Version
  1. 365
Platform
  1. Windows
Hi there
it's a minor issue, but does any one know why there is no option to fill down "weeks" in Excel 2003. There's days, weekdays,months,years but no weeks. Or is there a way of adding weeks to the drop down menu

Just curious - - - Thanks
Would the standard 'days' option with a step of 7 do what you want?
 

August

Active Member
Joined
Jun 18, 2004
Messages
264

ADVERTISEMENT

Hi there
it's a minor issue, but does any one know why there is no option to fill down "weeks" in Excel 2003. There's days, weekdays,months,years but no weeks. Or is there a way of adding weeks to the drop down menu

Just curious - - - Thanks
Would the standard 'days' option with a step of 7 do what you want?

Yes, but the drop down menu in Excel 2003 is just a faster method and you can't select the number of days from the drop down when you choose days for the fill
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
49,473
Office Version
  1. 365
Platform
  1. Windows
Yes, but the drop down menu in Excel 2003 is just a faster method and you can't select the number of days from the drop down when you choose days for the fill
Fair enough. :)

Perhaps you could attach this macro to a new toolbar button.

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> FillWeeks()
    Selection.DataSeries Rowcol:=xlColumns, Type:=xlChronological, Date:= _
        xlDay, Step:=7, Trend:=<SPAN style="color:#00007F">False</SPAN>
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>
 

August

Active Member
Joined
Jun 18, 2004
Messages
264
Yes, but the drop down menu in Excel 2003 is just a faster method and you can't select the number of days from the drop down when you choose days for the fill
Fair enough. :)

Perhaps you could attach this macro to a new toolbar button.

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> FillWeeks()
    Selection.DataSeries Rowcol:=xlColumns, Type:=xlChronological, Date:= _
        xlDay, Step:=7, Trend:=<SPAN style="color:#00007F">False</SPAN>
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

I'll try that, thanks
I'm assuming you highlight the desired cells below the start date before running the macro?

Thanks again
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
49,473
Office Version
  1. 365
Platform
  1. Windows
I'm assuming you highlight the desired cells below the start date before running the macro?
Yes, highlight the start date cell as well as the cells below where you want the fill to go (just like you would with the built-in Fill Down), and then click the button.
 

Forum statistics

Threads
1,136,927
Messages
5,678,621
Members
419,776
Latest member
mikelowski

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top