CODEWITHSUNDEEP
libreoffice-calc
elli
elli

Reputation: 1169

Multiple the numbers of a specific column with a number in libre office

How can I multiple the numbers of column A with the number eg 5? I use LibreOffice. Thank you

Upvotes: 6

Views: 10564

Answers (1)

tohuwawohu
tohuwawohu

Reputation: 13618

  1. Enter the factor (multiplicant) 5 in an empy cell and copy it (CTRL+C);
  2. Select the column with the values to multiply;
  3. Select Menu Edit -> Paste special... (or hit CTRL+SHIFT+V);

  4. Under Operations, select Multiply - leave everything else as default; hit OK:

    enter image description here

That's it - LO Calc will multiply the selected cell values with the value copied in step 1.

Upvotes: 9

Related Questions