| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I autofill dates having a blank cell between each day?
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How can I autofill dates having a blank cell between each day?
Hi Dee,
Enter a date in cell A1 (eg 5/13/08), enter the next day's date in cell A3 (eg 5/14/08). Select cells A1 trough to A4 (ie select two dates and two blank cells). See the little dot at the bottom right of the selection rectangle? Click on that (the cursor will change to a cross when you are over the right spot) and drag it down as far as you want. Ed Ferrero www.edferrero.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill Down When Text to Left is Not Blank | Excel Worksheet Functions | |||
| autofill on fixed dates | Excel Worksheet Functions | |||
| COUNTIF, dates and blank cell criteria | Excel Discussion (Misc queries) | |||
| Autofill until blank cell is reached | Excel Discussion (Misc queries) | |||
| Autofill data in specific blank cells | Excel Worksheet Functions | |||
Linear Mode
