Welcome to the MrExcel board!

I am not exactly sure what you are saying goes wrong, but this works exactly the same for me in Excel 2007 as in previous versions. Try just putting =A1 into cell C5 then click and drag the "Fill Handle" (the little black square you described).

If this doesn't work, please tell us what is in cells A1:A10, what formulas end up in C5:C14 after you perform the above process, and what results appear in C5:C14 after the process?

## Like this thread? Share it with others