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, 8 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.