Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Trying to copy a formula across 13 columns that have a blank column between each - so 26 columns in total. The formula gets data from another spreadsheet. At the moment I am going to each cell and copying the formula in and modifying the reference cell. Is there any way to make this quicker. I have tried dragging and copying when I have had 2 formulas filled in correctly however that does not work.

It wouldn't be so bad but it involves about 8 or 9 of these rows.

Thanks for any help

share|improve this question

1 Answer 1

Highlight the cell with the formula and the empty cell next to it. Using the fill handle, drag the corner ACROSS to the desired column. Excel will follow the pattern and copy the formula to the cell in every other column.

enter image description here

Then, if you need to, drag the corner DOWN to the desired number of rows.

If you are not getting the results you expect, you may need to adjust your formula in order for it to be copied correctly. That would be a different question though.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.