Fill down Question.

Wecks

New Member
Joined
Aug 11, 2018
Messages
5
This maybe a very simple question.

I have 1 column.

01/01/2018
01/01/2018
01/01/2018
01/01/2018

I want the pattern to continue i thought i could highlight the 4 cells and fill down and it would look like the below but it does not let me it just duplicates the values in the first 4 cells. I thought if i highlight the 01/01/2018 and the 02/01/2018 it would pick up the pattern and continue but this does not work either. Any assistance would be greatly appreciated.

01/01/2018
01/01/2018
01/01/2018
01/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Mike Blackman

Well-known Member
Joined
Jun 8, 2007
Messages
2,494
Hi Wecks,

You could use a formula to get that effect, put 01/01/2018 in A1 and use this below:

=IF(MOD(ROW()-1,4)=0,A1+1,A1)
 
Last edited:

Forum statistics

Threads
1,136,435
Messages
5,675,848
Members
419,586
Latest member
RoteichA

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top