t-spreadsheet.html

---
layout: base
title: "How to create a simple spreadsheet in LibreOffice"
---
<article data-hd-class="task"> 
<h1>{{ page.title }}</h1> 
<p>Create a simple spreadsheet in LibreOffice using the spreadsheet application, Calc.</p> 

<section data-hd-class="task/prereq"> 
<h2>Pre-requisites</h2>  
<ul> 
<li>1 computer with LibreOffice</li>
</ul> 
</section> 
<section data-hd-class="task/steps"> 
<h2>Steps</h2>
<ol> 
<li>Open LibreOffice either from the <strong>Start</strong> menu or the desktop icon.</li>
<li>Using the menu bar on the left, select <strong>Calc Spreadsheet</strong>.
	<p><u>NOTE</u>: This will open a blank, untitled Calc screen.</p>
</li>
<li>Under <strong>File</strong> in the Menu toolbar, click <strong>Save As...</strong>. Enter the desired filename of your spreadsheet and click <strong>Save</strong>.
</li>
<li>Insert the appropriate titles, labels, and information for your spreadsheet into the blank cells by clicking on the desired cell (it will outline in black) and immediately typing <em>(Figure 7)</em>.
	<p><u>NOTE</u>: Remember to save frequently while you work by clicking <strong>File: Save</strong>.</p>
<figure>
	<img src="images/structureSS.jpg" />
	<figcaption>Figure 7: The general structure of a spreadsheet input in LibreOffice Calc. Typing will occur in the outlined cell.</figcaption>
</figure>
<li>Navigate to other cells using the pointer, keyboard arrows, or Enter key.</li>
<li>Use Calc toolbars to format your spreadsheet to the desired form, e.g. making the titles bold <em>(Figure 8)</em>.
<figure>
	<img src="images/formatSS.jpg" />
	<figcaption>Figure 8: Using Calc toolbars to format the titles (highlighted) of a spreadsheet to be bold.</figcaption>
</figure>
</li>
<li>Upon completion, click <strong>File: Save</strong> to save your final spreadsheet. 
	<p><u>NOTE</u>: The keyboard shortcut "Ctrl + S" can also be used.</p>
</li>
</ol> 
</section>
</article>