436
edits
Changes
From Open Educational Resources
no edit summary
remember that you should select the entire sheet (Edit – Select All, or simply CTRL-A) or keep the cursor on a single cell, else you may sort only the data selected which will be incorrect.
remember that you should select the entire sheet (Edit – Select All, or simply CTRL-A) or keep the cursor on a single cell, else you may sort only the data selected which will be incorrect.
{{clear}}
{{clear}}
==== Preparing charts and graphs====
==== Preparing charts and graphs====
<gallery mode="packed" heights="250px" caption="Preparing charts and graphs">
<gallery mode="packed" heights="250px" caption="Preparing charts and graphs">
File:1. LO Calc Pivot 1. data sheet.png|Data sheet
File:1. LO Calc Pivot 1. data sheet.png|Data sheet
File:2. LO Calc Pivot 2. Inserting pivot.png|Inserting Pivot
File:2. LO Calc Pivot 2. Inserting pivot.png|Inserting Pivot
</gallery>
</gallery>Inserting pivot table from the existing data sheet:
# Inserting pivot: select the desired rows and click on Insert → Pivot Table option,you will get the select source wizard,then click on current selection.
==== Printing a spreadsheet ====
==== Printing a spreadsheet ====
[[File:LO_Calc_9_Adding_Page_Header_before_printing.png|500px|left]]
[[File:LO_Calc_9_Adding_Page_Header_before_printing.png|500px|left]]
