Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default fill series by weekdays in XL 2007

I have a date in B1 and would like to fill down by weekday down to B25 or so

I used Alt E..fill Series..Weekday in XL 03

How do I find/use Fill Series in 2007?

....Lisa
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default fill series by weekdays in XL 2007

You can right click and drag down and when you release the mouse you'll get
the option of filling weekdays or you can click the down arrow to the right
in the Home tab, select fill series and weekdays


--

Regards,

Peo Sjoblom




"Lisa Hetherington" wrote in message
...
I have a date in B1 and would like to fill down by weekday down to B25 or
so

I used Alt E..fill Series..Weekday in XL 03

How do I find/use Fill Series in 2007?

...Lisa



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 fill a series using keyboard commands EchoPapa42 Excel Discussion (Misc queries) 2 March 14th 07 03:55 AM
fill series FreezingInFargo New Users to Excel 1 December 19th 06 05:16 PM
Edit Fill Series - How do I fill using minute increments IUnknown Excel Discussion (Misc queries) 1 January 29th 06 12:50 PM
fill series D J R Excel Discussion (Misc queries) 2 December 14th 05 10:42 PM
Fill dates with weekdays/workdays only DJ Bjorklund Excel Worksheet Functions 1 January 18th 05 04:48 PM


All times are GMT +1. The time now is 02:27 PM.

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

About Us

"It's about Microsoft Excel"