M mrxwantobe Board Regular Joined May 2, 2002 Messages 158 Sep 14, 2006 #1 hi. I have a sheet with three columns. Column A and B have 5000 entries. I need to fill column C with a duplicate entry all the way down. is there an easier way then to drag down from 1 to 5000? Some hotkey that says fill to the end?