Return or get same row instance

I want in column C to divide column A and column B but for every row. So instead of writing in 100+ rows A2/B2, A3/B3/, A4/B4… I need the A(of same row) / B (of same row). Should be ez but cannot find…

  • First option: Select from column C from row 2 to 100+, type =A2/B2 and immediately press Alt+Enter.

  • Second option: Type in C2: =A2/B2, press Enter. Click on C2, and…

  1. Drag down the fill handle (the little square at the bottom right of the selection).
  2. Double click on the fill handle (previously there must be data in column B).

More LibreOffice Help on Selecting Multiple Cells, Entering Formulas, Calculating With Formulas, Copying Formulas.

Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.

Check the mark (Answer markCorrect answer mark) to the left of the answer that solves your question.