Ask Your Question

multiply cells [closed]

asked 2016-03-25 06:35:22 +0100

wdhc gravatar image

updated 2020-08-06 22:34:35 +0100

Alex Kemp gravatar image

LibreOffice is great at opening files that newer office software can no longer open, but very difficult to use. ---Help leads nowhere ---Spreadsheet columns cannot be expanded to create a header, nor is there a way to create a header

How do I access Help, or a tutorial?

What and where are the formulas for SUM and Multiply? I cannot get it to do anything? Nor do I have any luck with MSCalc so it must be %*$#@ Windows 10 pro....

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-06 22:34:57.851068


Have you tried F1 for accessing Help ? You can find useful informations in the documentation page of libreoffice site.

ratrace gravatar imageratrace ( 2016-03-25 09:02:32 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-03-25 14:28:16 +0100

LKeithJordan gravatar image

As @ratrace said, try F1 to access Help. You can also type "how to use libreoffice" into your browser search box to see a plethora of articles ranging from "Getting Started with LibreOffice 4.0" (by The Document Foundation), to "Taming LibreOffice," to "Instructions for Using LibreOffice Calc" (a wiki via

From you comments, I'm not quite sure what you mean by "Spreadsheet columns cannot be expanded to create a header..." A spreadsheet document header can be accessed and customized from Format > Page by clicking the Header tab.

If you are referring to freezing rows to create a static column heading while the detail scrolls, select View > Freeze Rows and Columns. This will freeze rows to the left of your cursor and freeze columns above your cursor.

The "formulas for SUM and Multiply" are basically the same as in Excel. The equal sign (=) entered as the first character in a formula indicates a mathematical operation. "=SUM([From]:[To])" adds the cells for the range specified. Multiplying cells uses the asterisk (*) symbol to indicate a multiplication operation.

I hope this helps.

Please click the check mark next to the post you believe best answers your question.

edit flag offensive delete link more


To make the answer a little more clear, Adding and Multiply both use function "SUM". Addition uses symbol ":" and Multiply uses "*".

RayN gravatar imageRayN ( 2020-06-22 08:57:28 +0100 )edit

BTW, using "SUM" for both addition and multiplication is entirely wrong. Seems M$ messed up if that is how it works in Excel. SUM in math means "addition".

RayN gravatar imageRayN ( 2020-06-22 08:59:34 +0100 )edit

RayN, I did not mean to imply that "SUM" would be used for multiplication. If my answer was unclear on this point, I apologize.

LKeithJordan gravatar imageLKeithJordan ( 2020-09-03 16:59:19 +0100 )edit

Question Tools



Asked: 2016-03-25 06:35:22 +0100

Seen: 9,846 times

Last updated: Mar 25 '16