1

I am working in Google sheets which is the same as the excel program.

How do you make it so that when one cell is changed in a column all of the cells in that column are also changed so that they all contain the same value entered?

3
  • Just make the cell content a reference to the source cell. If A1 is what will change, make the other cells: =A1 To enter the formula once and copy it, anchor it: =$A$1. Are you sure you couldn't find this with a search?
    – fixer1234
    Nov 29, 2018 at 0:49
  • There is no need to move this question to web apps
    – PeterH
    Nov 29, 2018 at 15:09
  • @Andria, BTW, Google Sheets is very similar to Excel, but not identical. The safe approach is to ask Google questions on Web Apps. What sometimes happens is a question is posted as Excel when the OP is actually using Sheets or LO Calc or something else. It turns out not to behave exactly the same, and everybody wastes a lot of time figuring out why nobody can replicate the other person's results. It's unfair to answerers.
    – fixer1234
    Nov 29, 2018 at 19:38

0

You must log in to answer this question.

Browse other questions tagged .