We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

how to compose a spreadsheet

asked 2019-07-21 21:48:18 +0200

ginabella67 gravatar image

updated 2020-07-29 23:59:53 +0200

Alex Kemp gravatar image

Never have composed a spreadsheet i.e. # of columns etc. Please help STEP BY STEP!! Thanks

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-07-22 00:47:45 +0200

lazarus477 gravatar image

updated 2019-07-22 00:49:44 +0200

  1. Decide one what data you want to store and or analyze.
    1. Define the field names for the data and enter these horizontally, vertically, or both ways.
    2. Enter data in the cells that make up the rows and columns of the spreadsheet.
    3. Add formulas in the formular bar to compute values based on entered values.
    4. Apply formatting to data such as currency and date formats, to name a couple.
    5. Next to get some visually appealing structure and design make use of visual elements such as grid lines and text areas.
    6. Add graphs to graph out data.

The list goes on but that is one way of looking at how one creates a spreadsheet. Next I suggest you to google up some examples of spread sheets and also watch some videos on the subject. The handbook for LibreOffice Calc is here: https://documentation.libreoffice.org/en/english-documentation/calc/

For good instructive videos watch these: https://thefrugalcomputerguy.com/seriespg.php?ser=10

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-21 21:48:18 +0200

Seen: 152 times

Last updated: Jul 22 '19