In my LibreOffice Calc spreadsheet, I have a column in one sheet where I want to reference values from another sheet. I want to copy one cell, paste into multiple cells, and have it correctly set the references.
Let's say I start by coping a cell containing
=sheet2.A1. By default:
If I paste it into cells in the same column, it will increment the row numbers, like:
If I paste it into cells in the same row, it will increment the column names, like this:
=sheet2:B1 =sheet2:C1 =sheet2:D1
What I want is to control whether it increments the cell or column, so that I can paste into the same column and increment the column names, like this:
COLUMN A =sheet2:A1 =sheet2:B1 =sheet2:C1
How can I do this?