LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default How to Create a Date Series across a row?

Greetings all. I've run into a roadblock in Excel 2007.

I am trying to create an ascending date series across a row, with each
3-cell section containing the same month, day and year. So, for example :
Cells A1 - C1 = 1/1/03 1/1/03 1/1/03
Cells D1 - F1 = 2/1/03 2/1/03 2/1/03
Cells G1 - I1 = 3/1/03 3/1/03 3/1/03, etc.

In previous vesions of excel I could type the first date of the series in
cell A1, the second date of the series in cell D1, the third in cell G1. Then
select all cells from A1 - I1, drag to the end of the row. Then Edit Go To
Blanks OK. Click the "=" sign in the formula bar, select the cell with

the first date (A1),hold down CNTRL and press ENTER. The date range would
then be autofilled through the entire row, continuing through whatever date
could fit in the last cell of the row.

It seems to me this should be a "Fill" option from the Editing portion of
the ribbon in Excel 2007. But I just can't figure it out. Any
information/solution would be greatly appreciated.

Thanks in advance for the help!


 
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
Create vertical line to indicate date on chart with series of date ryguy7272 Charts and Charting in Excel 1 January 11th 08 06:36 PM
create an autofill series! via135 Excel Worksheet Functions 2 March 16th 06 03:27 AM
How do I create a weekly series? eingram Excel Worksheet Functions 6 September 19th 05 09:01 AM
create chart from series grouped by value in another column HarCo Charts and Charting in Excel 2 August 28th 05 01:53 AM
Date updates from worksheet to chart & changes date to a date series! Help!! Jayjg Charts and Charting in Excel 2 January 22nd 05 03:00 PM


All times are GMT +1. The time now is 11:49 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"