0

So pretty simple thing I am doing, pulling data from a form and putting it in a template.

=('Form Responses 1'!B3)

is what I am doing, which works fine for my needs, however when I copy and past this it advances like this

=('Form Responses 1'!B4)

This is working as intended, but I want to advance column instead of the row. Is there an easy way to do this?

0

What you are looking for is to lock the formula.

The dollar sign $ is used for "locking" a cell.

  • Form Responses 1'!$B$3 The cell is fully locked.
  • Form Responses 1'!$B3 The column of the cell is locked.
  • Form Responses 1'!B$3 The row of the cell is locked.
  • Form Responses 1'!B3 The cell is unlocked.

EDIT: (following OP comment)

What I need is =('Form Responses 1'!B$3) =('Form Responses 1'!C$3) on the next row down in the same column. Unless there is a better way to do this.

Unlocked cells change the column letter when changing columns and row numbers when changing rows.

The easiest way to achieve what you want is manually:

1. Double click within the cell of the formula ='Form Responses 1'!B$3, highlight the whole of the formula and copy the text.
2. Go to the cell you want, double click within the cell and paste the text you have just copied and manually change the column letter from B to C.

  • I want to advance the column letter, while pasting down a single column, it appears to only advance the column if you past in the next column over. I am trying to past down a list of information in my template. What I need is =('Form Responses 1'!B$3) =('Form Responses 1'!C$3) on the next row down in the same column. Unless there is a better way to do this. – James Oct 10 at 2:53
  • Do you mean drag down the formula ='Form Responses 1'!B3 and at the same time have it changed from want to ='Form Responses 1'!B3 to ='Form Responses 1'!C$3, then ='Form Responses 1'!D3 etc? – marikamitsos Oct 10 at 3:07
  • Please check the updated answer and if it solves your question accept it so others can benefit as well. If not, let us know. – marikamitsos Oct 10 at 5:44

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.