LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Steven
 
Posts: n/a
Default Excel : fill by example

Hi

Is there a similar function to the Lotus 1-2-3 "fill by example". I've
tried the Fill option under Edit, however can't seem to get it to work with
dates. For example if I enter in 3 dates in a column (see example below), I
would then like the next 20 or so rows for that column to be filled in with
dates incrementing by one week.

e.g

31.10.2005
07.11.2005
14.11.2005

thanks in advance.

Steven


 
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
can excel be opened to fill screen size available johnw Excel Discussion (Misc queries) 4 October 8th 05 10:34 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Why won't it Excel fill in weekly dates now, changes them to daily Larry Excel Worksheet Functions 1 April 6th 05 12:57 PM
My excel 2003 wont let me fill cells with color or color the tabs. trizog New Users to Excel 2 February 22nd 05 06:43 PM
How do I change fill color default in excel 2003? bowler708 Excel Discussion (Misc queries) 1 January 2nd 05 08:59 PM


All times are GMT +1. The time now is 09:51 PM.

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

About Us

"It's about Microsoft Excel"