How to keep one field fixed in a formular when using auto-fill?

openoffice.org autofill libreoffice
Seeker picture Seeker · Jun 25, 2012 · Viewed 12.3k times · Source

I want to autofill a formula to a bunch of fields in one column. I can do that by filling two fields manually then select them and drag down.

I want column B's cells to be =D1*A1 , =D1*A2,... Note D1 should not change.

When I drag the fields down or use (Edit > Fill...) it changes D1 to D2, D3,... How can I keep one field fixed for autofill?

Holding ctrl button down does not help.

Any idea?

Answer

twalberg picture twalberg · Jun 25, 2012

Make your "master" formula =D$1*A1. That flags the 1 in the D$1 part as being constant. You could also make the D part constant with =$D$1*A1, but since you stated this is a single column, it shouldn't matter in this case.

Note that this also works for Microsoft Excel, and I think that it's been a common feature of almost all spreadsheets since way back to supercalc on HDOS.

Related questions

How To Format A Block of Code Within a Presentation?

I am preparing a presentation using Google Slides, though I can also work on the presentation within Open Office that will include code snippets. Is there any easy way to perform basic syntax highlighting on the code snippets with either …

Read More
Fill non-contiguous blank cells with the value from the cell above the first blank

I want to know if there is a way to do this conditional in excel or open office: if the cell is empty then the cell will have the same value as the cell above it else do nothing. Should …

Read More
C#: Getting the number of rows/columns with ExcelPackage

I need to read and write data from an Excel spreadsheet. Is there a method to finding out how many rows/columns a certain worksheet has using ExcelPackage? I have the following code: FileInfo newFile = new FileInfo(@"C:\example.xlsx"); …

Read More