1,089
edits
Changes
Jump to navigation
Jump to search
Line 79:
Line 79: − + − + − + Line 94:
Line 94: − + Line 102:
Line 102: − + − +
→For MAC OS
=====For MAC OS=====
=====For MAC OS=====
#Click [https://www.fosshub.com/LibreOffice.html this link] and click on "LibreOffice MAC OS" for MAC laptops.
#Click [https://www.fosshub.com/LibreOffice.html this link] and click on "''LibreOffice MAC OS"'' for MAC laptops.
#It will start downloading "LibreOffice_..._MacOS_x86-64.dmg" into your computer (by default browser will save the files in "Downloads" folder in your system
#It will start downloading "''LibreOffice_..._MacOS_x86-64.dmg"'' into your computer (by default browser will save the files in "''Downloads"'' folder in your system
#Double-click on download "LibreOffice_..._MacOS_x86-64.dmg" file to begin installation
#Double-click on download "''LibreOffice_..._MacOS_x86-64.dmg"'' file to begin installation
#An installation window appears: drag and drop the LibreOffice icon onto the Applications icon in the same window. You may be required to enter your administrator password.
#An installation window appears: drag and drop the LibreOffice icon onto the Applications icon in the same window. You may be required to enter your administrator password.
#The files are copied over and a progress bar shows when the installation is complete.
#The files are copied over and a progress bar shows when the installation is complete.
File:LO Calc 1 viewing a spreadsheet.png|Basic spreadsheet interface
File:LO Calc 1 viewing a spreadsheet.png|Basic spreadsheet interface
</gallery>
</gallery>
* LibreOffice Calc can be opened from "Applications --> Office --> LibreOffice Calc". This opens a ‘work book’. A work book can have many ‘sheets’. When you open the LO Calc application, it will show a window like this. The spreadsheet consists of rows and columns. Each column-row intersection is a cell; this is the place you will enter data in a spreadsheet. You can click the cursor on any cell and type in the information you want to enter. <br> Select Cell A1 and type “Name of city”, Hit enter. Next select cell B1 and type “Average annual rainfall (cms). Hit enter, and select cells of Column A to enter names of cities and Cells of Column B to enter annual average rainfall. <br> You can click on the A1 and B1 cells and click on the BOLD function icon (or simply type CTRL+B) to make the headings bold.
* LibreOffice Calc can be opened from "Applications --> Office --> LibreOffice Calc". This opens a ‘work book’. A work book can have many ‘sheets’. When you open the LO Calc application, it will show a window like this. The spreadsheet consists of rows and columns. Each column-row intersection is a cell; this is the place you will enter data in a spreadsheet. You can click the cursor on any cell and type in the information you want to enter. <br>Select Cell A1 and type “Name of city”, Hit enter. Next select cell B1 and type “Average annual rainfall (cms). Hit enter, and select cells of Column A to enter names of cities and Cells of Column B to enter annual average rainfall. <br>You can click on the A1 and B1 cells and click on the BOLD function icon (or simply type CTRL+B) to make the headings bold.
Like in the case of text document, you can use the File menu to save your spreadsheet. The file will be saved with a .ods extension. ODS is the short form of Open Document Spreadsheet.
Like in the case of text document, you can use the File menu to save your spreadsheet. The file will be saved with a .ods extension. ODS is the short form of Open Document Spreadsheet.
{{clear}}
{{clear}}
File:Cal step 2.png|Navigation from various sheets
File:Cal step 2.png|Navigation from various sheets
</gallery>
</gallery>
* You can move across cells using the arrow keys. You can also quickly go to the ends of the sheet using CTRL Keys, such as CTRL-Home (go to Cell A1), CTRL-End (bottom rightmost part of filled cells / entered data), CTRL – Up Arrow (next cell in same column, before an empty cell) etc. <br>It is useful to become comfortable using keyboard to move across the spreadsheet.<br>Columns and rows can be inserted or deleted or hidden in a spreadsheet. You can right click anywhere on the spreadsheet and insert/ delete rows and columns. You can also go to Sheet menu and insert rows/ columns. <br>
* You can move across cells using the arrow keys. You can also quickly go to the ends of the sheet using "Ctrl" Key, such as Ctrl+Home (go to Cell A1), Ctrl+End (bottom rightmost part of filled cells / entered data), Ctrl + Up Arrow (next cell in same column, before an empty cell) etc. <br>It is useful to become comfortable using keyboard to move across the spreadsheet.<br>Columns and rows can be inserted or deleted or hidden in a spreadsheet. You can right click anywhere on the spreadsheet and insert/ delete rows and columns. You can also go to Sheet menu and insert rows/ columns. <br>
==== Inserting a new sheet ====
==== Inserting a new sheet ====
Sheets can be added or deleted from a work book using the "+" symbol seen next to the sheet name. Sheets can be named and renamed by right clicking on the name of the sheet visible in the bottom panel. (screenshot for both)
Sheets can be added or deleted from a work book using the "+" symbol seen next to the sheet name. Sheets can be named and renamed by right clicking on the name of the sheet visible in the bottom panel.
{{clear}}
{{clear}}