LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Walter Mayes
 
Posts: n/a
Default Autofill a series

Excel XP

Am trying to fill a series of dates such as:


1/1
1/2
1/3
1/4
1/5


1/8
1/9
1/10
1/11
1/12

First date in cell a3. By selecting cells a1:a14 I can get Excel to
leave the two blank cells but cannot get it to skip the 1/6, 1/7 dates. In
the next series Excel picks up with the 1/6 date.Is it possible to have
Excel "skip" dates with autofill?

Walter Mayes


 
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
How can I autofill a series to reference non adjacent cells? Microcell Excel Discussion (Misc queries) 1 June 30th 05 09:49 PM
Can I add an average series to a chart with 2 or more series? Yaniv Charts and Charting in Excel 4 June 16th 05 11:37 PM
Can I use AutoFill or a formula to fill a series of letters? tadpgk835 Excel Discussion (Misc queries) 3 April 28th 05 02:46 PM
How to change Series order in a Combination Chart? vrk1 Charts and Charting in Excel 3 April 1st 05 07:21 AM
series graph -- one series being added to another series rich zielinski via OfficeKB.com Charts and Charting in Excel 3 March 30th 05 06:23 PM


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