Calc

To preview a worksheet, click on ‘File’ from the main menu bar and from the resulting drop-down menu, click on ‘Print Preview’. This will open the preview display of the worksheet as has been shown below. To close the preview, click on ‘Close Preview’. Print a selected cell range from a worksheet, an entire worksheet,…

Check and correct spreadsheet calculations and text. In order to check the spreadsheet calculations, we need to check the sheet for the error codes. These error codes have already been discussed. If error codes are present, this means that some errors exist in some of the calculations and we must check these calculations again. To…

Setup Change worksheet margins: top, bottom, left, right. In order to change the worksheet margins, click on the ‘Format’ button from the main menu bar. Click on ‘Page…’ button from the resulting drop-down. This gives the ‘Page Style’ dialog box. Under the ‘Page’ tab, you can make the appropriate changes to the ‘Margins’ in order…

Change the column, bar, line, pie slice colors in the chart. To change the column, bar, line, or pie slice color in a chart, simply double-click on the respective element for which you want to change the color. If it is a bar chart, double-click on the individual bar, and if it is a pie…

When a chart is created, then in the ‘Chart Wizard’, under the ‘Chart Elements’ tab, we have the option to add a ‘Title’ for the chart. Appropriate title can be added in this tab during the creation of the chart. Another way is to first create a chart, then select it by double clicking, and…

Create different types of charts from spreadsheet data: column chart, bar chart, line chart, pie chart. In Calc, we can represent our data with the help of different graphical representations like column chart, bar chart, line chart, or pie chart. This makes the data more presentable and also easier to comprehend. To create the different…

Apply text wrapping to contents within a cell, cell range. To apply text wrapping to contents within a cell or a cell range, first select the cell or the cell range and then right click anywhere on the entire range. From the resulting menu, click on ‘Format Cells’, this will open the ‘Format Cells’ dialog…

Change cell content appearance: font sizes, font types. In the same ‘Format Cells’ dialog box, under the ‘Font’ tab, we have the ‘Font’ and ‘Size’ drop-down lists. The ‘Font’ drop-down list gives the different font types and ‘Size’ gives the different font sizes. These values can be chosen accordingly. After selecting the required values, click…

Numbers/Dates Format cells to display numbers to a specific number of decimal places, to display numbers with, without a separator to indicate thousands. It is possible in Calc to format cells to display any input in some particular styles. To format a cell to display numbers to a specific number of decimal places, right-click on…