I have =A1 on one cell and then a bunch of text on three cells beneath it and then =A2 on the fourth cell beneath it, how to make sure that when I drag down, it goes to A3 after leaving three cells and so forth?

  • 1
    Welcome. The question doesn't show your search/research efforts. Please take the tour and checkout How to Ask to learn part of the basics of this site. – Rubén Jul 24 '17 at 2:04

To achieve the following:

  • D1 refers to A1
  • D4 refers to A2
  • D7 refers to A3

and so on, use a formula such as =offset(A$1, row(D1)/3, 0) in cell D1. This offsets the reference to A1 by the row number divided by 3 (the result is rounded down automatically). When copied down the column, it will offset the cell positions correctly.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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