Is there any way to copy a formula down a column which has empty columns next to it? That is, I can’t copy the formula down with a double click in this situation. Instead of dragging down the Fill Handle (say down to 1870th row!!), I usually create a column next to this column which I will be working on beforehand so that I can do the simple ‘double click’ cool act. However, I think there should be better alternatives and I would appreciate any suggestions. Thanks.