Office Software

There are some file types which are which are actually spreadsheet files, but in text format where cell contents are separated by a character. This character can be anything, say a comma or a colon. The extensions for such files are normally .csv or .txt and data from such files can be imported to Calc.…

To link data between different sheets within a spreadsheet, select the cell on which you want to create the link. After this go to the input line and input ‘=’. After this, go to the sheet whose data you want to link to this sheet and select the cell which needs to be linked. Click…

Insert, edit, and remove a hyperlink. Hyperlinks are used to jump to a different location from within a spread sheet and this location can be in the same file, in different files and also some websites. To insert a hyperlink, click on ‘Insert’ from the main menu bar, and from the resulting drop-down menu, click…

Create a spreadsheet based on an existing template. To create a spreadsheet based on an already existing template, click on ‘File’ from main menu bar. From the resulting drop-down, click on ‘New’, and from the sub-menu, click on ‘Templates’. This will open the ‘Template Manager’ wizard. Under the ‘Spreadsheets’ tab, click on ‘My Templates’ or…

Use paste special options: add, subtract, multiply, divide. Paste special options help in making some quick calculations and formatting changes by a special copy paste function. We need to have some data to use the special paste function. From the available data, simply right-click on any cell and copy that cell to the clip board.…

Name cell ranges, delete names for cell ranges. To name a cell range, click on ‘Insert’ from the main menu bar. From the resulting menu, click on ‘Names’ and from the sub-menu which gets generated, click on ‘Define’. This will open the ‘Define Name’ dialog box. In this dialog box, under ‘Name’, give the name…

Insert, edit, delete, show, and hide comments/notes. To insert comments is a worksheet, select the cell to which you need to insert the comment and right-click on this cell. This will open a menu from which you need to click, ‘Insert Comment’. This will give you a small text box attached to the cell as…

Show all formulas in a worksheet, rather than the resulting values. To show formulas in the worksheet instead of the resulting values, click on ‘Tools’ from the main menu bar. From the resulting drop-down, click on ‘Options’. This opens the ‘Options’ wizard. In the ‘Options’ wizard, under ‘LibreOffice Calc’, click on ‘View’. Then under ‘Display’,…

Trace precedent, dependent cells. Identify cells with missing dependents. Trace precedent gives us the cells on which the value of the current selected cell depends. To trace the precedent of a cell, select the cell and then click on ‘Tools’ from the main menu bar. From the resulting drop-down menu, click on ‘Detective’ and from…

Set and edit validation criteria for data entry in a cell range like: whole number, decimal, list, date, time. To set validation criteria for data entry in a cell range, click on ‘Data’ from the main menu bar, and from the resulting menu, click on ‘Validity’. This will open the ‘Validity’ dialog box. In this…