I have a spreadsheet that stops at line 24 and continues across to M. It will always stop at M but I want to continue it from 24 down to line 70. I've tried to use "fill" and "down" but it just messes up and ends with a bunch of hashtags. What am I doing wrong? Do I have to enter the formula in each individual cell? Is there no easy way of doing this? I attached the spreadsheet, and the blank cells are just words. Any help would be wonderful. Thanks.

Attached Files

Sample.xls (28.5 KB, 10 views)

Selecting the last row, then extending the selection downwards, followed by Ctrl-D allows you to continue to data etc. down as far as you want. The ### output simply tells you the cells aren't wide enough to display their contents. You can widen the columns and/or make the font smaller to overcome that.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Go to the Formulas ribbon, in Formula Auditing section select Show Formulas so you can see the progression of all the formulas.

In column B all those D3 should be $D$3 and in column K the K3 should be $K$3 for the formulas to maintain the addition of the constant when being dragged.