Ask Your Question
0

multiply cells

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

wdhc 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 close merge delete

Comments

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
0

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 LibreOffice.org).

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
Login/Signup to Answer

Question Tools

2 followers

Stats

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

Seen: 4,046 times

Last updated: Mar 25 '16