How do I advance the column instead of the row when I copy/paste a formula?

by James   Last Updated October 10, 2019 03:03 AM - source

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?

Answers 1

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.
October 10, 2019 02:50 AM

Related Questions

Import range from 3 sheets/tabs into 4th

Updated February 06, 2019 12:03 PM

Aggregate results by week and month for charts

Updated January 18, 2019 09:03 AM