Excel 2013 & FlashFill

[blue-eye-boy]

Hey there, I have a question regarding Excel 2013 (365) and Flash Fill.

I use it a lot, to copy Dates. Now every time I use Flash Fill to copy the date, it creates a series of date. I need it to Copy the dates. I know I can change it manually every time, but if it is possible to set it to default copy and not fill a series, it will save me quite a bit of time.

Thanks in advance...

 

[gfmalan]

Hey there, I have a question regarding Excel 2013 (365) and Flash Fill.

I use it a lot, to copy Dates. Now every time I use Flash Fill to copy the date, it creates a series of date. I need it to Copy the dates. I know I can change it manually every time, but if it is possible to set it to default copy and not fill a series, it will save me quite a bit of time.

Thanks in advance...

I've tried to simulate what I understand from your post, but a few questions come up.
When you start with the dates, are they in a format like "yyyy/mm/dd" and then you fill them down for say 20 rows, or do the appear as date numbers?!
Is it a list looking like numbers in the above date format, that you select and copy, and when you past it, it paste as date numbers and not in the nice date format?

 

[blue-eye-boy]

I've tried to simulate what I understand from your post, but a few questions come up.
When you start with the dates, are they in a format like "yyyy/mm/dd" and then you fill them down for say 20 rows, or do the appear as date numbers?!
Is it a list looking like numbers in the above date format, that you select and copy, and when you past it, it paste as date numbers and not in the nice date format?

It is in a dd/mm/yyyy format. Then when i ckick and drag down, the days follow on each other, for example I start with the first of the month, and after flash fill, the date is at the 20 th. But I need it to stay on the exact same date. This is for a production of various products on the same day, then the next day I start with the next date, and so on. So basicaly I need flash fill to copy and not create a series, as default.

 

[GPS]

Press control when dragging down?

 

[Shiraz]

Put the date in the first cell.... Highlight all the cell's you want to fill (including the first with the date) and press Ctrl D to duplicate the value down

 

[blue-eye-boy]

Press control when dragging down?

Put the date in the first cell.... Highlight all the cell's you want to fill (including the first with the date) and press Ctrl D to duplicate the value down

Thanks, I will definitely try this.