Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

Fill Series

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
WmBrown - 02 Jan 2006 17:49 GMT
Newbie

Is there an action to automatically fill a series of dates?

Row A1 01/01/2006
Row B1 Blank
Row C1 01/02/2006
Row D1 Blank
Row E1 01/03/2006
etc.

Thanks for any help
RagDyeR - 02 Jan 2006 18:01 GMT
Simply select A1 to D1,

Right *OR* left click on the fill handle of the selection,
And drag right.
Signature


HTH,

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

Newbie

Is there an action to automatically fill a series of dates?

Row A1 01/01/2006
Row B1 Blank
Row C1 01/02/2006
Row D1 Blank
Row E1 01/03/2006
etc.

Thanks for any help
bpeltzer - 02 Jan 2006 18:08 GMT
Fill in the first cell.  Then select the first TWO cells (1/1/06 and blank).  
Grap the fill handle at the extreme lower right of the selected cells and
drag until you've reached the ending cell (the tip will show you the value of
the latest cell you've covered).

> Newbie
>
[quoted text clipped - 8 lines]
>
> Thanks for any help
WmBrown - 02 Jan 2006 18:13 GMT
Sorry

The entries are in a column.

A1 01/01/2006
A2 Blank
A3 01/02/2006
A4 Blank
A5 01/02/2006
etc.

Will that make your answer change?
> Newbie
>
[quoted text clipped - 8 lines]
>
> Thanks for any help
RagDyeR - 02 Jan 2006 18:18 GMT
No !

Just select A1 to A4,
And drag down to where ever.
Signature


HTH,

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

Sorry

The entries are in a column.

A1 01/01/2006
A2 Blank
A3 01/02/2006
A4 Blank
A5 01/02/2006
etc.

Will that make your answer change?
> Newbie
>
[quoted text clipped - 8 lines]
>
> Thanks for any help
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.