| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can autofill, as in months or dates, go to the end of the spreads
Hi, trying to set a spreadseet with dates all the way to the end, do I have
to hold autofill to the end or can I do it another way? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can autofill, as in months or dates, go to the end of the spreads
Put the start date in the first cell then select the area you want to fill
including the cell you put the first date in. This can be done using shift+end shift+down-arraw. Then from the edit menu select fill|series... Then select rows, date, day,step 1 and click ok. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Mary jane" wrote: Hi, trying to set a spreadseet with dates all the way to the end, do I have to hold autofill to the end or can I do it another way? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can autofill, as in months or dates, go to the end of the spreads
Are you sure you want to fill the date into 65536 cells?
That would take you up to June 6, 2086 Follow Martin's advice but select a smaller range. You can select a range by typing A1:A4000 in the namebox then hit ENTER and EditFill Series. Gord Dibben MS Excel MVP On Sun, 31 Dec 2006 20:19:00 -0800, Mary jane wrote: Hi, trying to set a spreadseet with dates all the way to the end, do I have to hold autofill to the end or can I do it another way? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can autofill, as in months or dates, go to the end of the spre
Thanks Gord.
I didn't realize that you could use the name box to select a range. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Gord Dibben" wrote: Are you sure you want to fill the date into 65536 cells? That would take you up to June 6, 2086 Follow Martin's advice but select a smaller range. You can select a range by typing A1:A4000 in the namebox then hit ENTER and EditFill Series. Gord Dibben MS Excel MVP On Sun, 31 Dec 2006 20:19:00 -0800, Mary jane wrote: Hi, trying to set a spreadseet with dates all the way to the end, do I have to hold autofill to the end or can I do it another way? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can autofill, as in months or dates, go to the end of the spre
These NG's are a great place to learn.
Another method for those who are rodent-challenged............ F5 and type A1:A4000 and <ENTER Gord On Tue, 2 Jan 2007 02:39:00 -0800, Martin Fishlock wrote: Thanks Gord. I didn't realize that you could use the name box to select a range. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Manipulating dates (was Add 6 months to a date) | New Users to Excel | |||
| Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions | |||
| Calculating Dates in Terms of Months | Excel Worksheet Functions | |||
| I want to subtract 2 dates and display the result as months | Excel Worksheet Functions | |||
| How do I display months and years between two dates | Excel Discussion (Misc queries) | |||
Linear Mode
