To change to percentage press Control+Shift+5 or Format ‣ Number Format ‣ Percentage. To change to showing currency for the number press Control+Shift+4 or Format ‣ Number Format ‣ Currency. If you want to paste your text unformatted press Control+Shift + Alt+V or Edit ‣ Paste Unformatted Text. To cut text press control+x, right click Cut, or press the scissors button to cut text. To paste data press control control +v, Edit ‣ Paste, right click Paste, or press the button that is a clipboard with a piece of paper on it. To copy data you can right click Copy, press the button with two pieces of paper or press control + c. To open a recent document File ‣ Recent Documents. To open a file press the button that looks like a brown folder and add select the file you want from the dialog or File ‣ Open.

To save with a different file name File ‣ Save as. To save your spreadsheet you need to press the button that looks like a floppy disk, press the keyboard shortcut or go to File ‣ Save. To sort in ascending order press the button with bullet points and an arrow pointing upwards. To sort your cells in descending order press the button with bullet points and an arrow going down. To sum data from cells in the cell where you want the sum is to press the button that looks like Σ character and then drag the mouse over the cells you want to add. To select cells left click and drag to select the cells you want. To enter data into cells type in the keyboard. Subscribe to DCP YouTube for more free LibreOffice video tutorials.To move between cells press the arrow keys in the direction you want to move. Why not check out some of our other Libre Office tutorials and upgrade your skill set today? During this video tutorial we will look at: Once you have completed this tutorial you should have a good understanding of Libre Office Calc. In this tutorial, we will focus on the fundamentals of Libre Office Calc. Libre Office can be downloaded for free and is supported by various operating systems which include Windows 10, Linux and Apple Mac computers. Libre Office Calc can be used to complete various analytical and business documentation tasks. Libre Office Calc is a spreadsheet software application which is very similar to Open Office Calc and Microsoft Excel. In this tutorial, we will cover the fundamental of using Libre office Spreadsheets. This is a free Libre Office Calc Beginners Tutorial. (Click image above to watch video tutorial)

Libre office calc