Forum Discussion
Jump over a row when dragging down a formula
Hi, I am trying to put in a formula in excel. The problem is that every 7th row I have a row that I don't want to compute but instead jump to the next row but I still want to have the result ben...
You could simply drag down the formula, and clear the 'unwanted' cells by ctrl-clicking these and press 'delete' once selected. A sum of the range of cells still computes, even if the range contains blank cells.
Is that what you mean?
Regards,
Thank you. That will work fine :)
Carl Elmesiöö, if you're data and formulas consistently repeat, you might also try dragging a selection.
Selecting cells across multiple rows and then dragging down will copy each row in turn.
E.g. Select A1:A7, grab the drag handle then drag down to A14 (or as far as you need).
A1 is copied to A8
A2 to A9
...
A7 to A14 etc
If A7 was blank or contained text, A14 and every 7th cell will contain the same contents as A7.
- Nice one, and even better! I didn’t look that far ahead!