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 check the text values in the sheet, click on ‘Tools’ from the main menu bar and from the resulting drop-down, click on ‘Automatic Spell Checking’. This will open the ‘Spelling’ dialog box. This dialog box lists all the incorrect spellings in the sheet. You can check the spellings and also correct them from here. After making all the changes, click on ‘Close’. This is how we can check the text values in Calc.
Turn on, off display of gridlines, display of row and column headings for printing purposes.
To turn on/off the display of gridlines or the display of row and column headings, click on ‘Format’ from the main menu bar and from the resulting drop-down, click on ‘Page’. This opens the ‘Page Style’ dialog box. In this dialog box, under ‘Print’, we have two check boxes named ‘Column and row headers’ and Grid’. The display of grid lines can be switched on or off by checking or unchecking the ‘Grid’ check box and the display of row and column headings can be switched on and off by checking or unchecking the ‘Column and row headers’ check box. After selecting the required values, click on ‘OK’. This will save your settings.
Apply automatic title row(s) printing on every page of a printed worksheet.
To apply automatic title rows printing on every page of a printed worksheet, click on ‘Format’ from the main menu bar. From the resulting drop-down menu, click on ‘Print Ranges’ and from the sub-menu which gets displayed, click on ‘Edit’. This will open the ‘Edit Print Ranges’ dialog box.
In this dialog box, we have a section called ‘Rows to Repeat’. Click on the ‘Shrink’ button in front of this section and this will minimize the dialog box. Now select the row which you want to set as the title row for automatic printing on every page for the worksheet and again click on the ‘Shrink’ button.
This will again bring up the full ‘Edit Print Ranges’ dialog box but now the rows selected will get displayed in the ‘Rows to Repeat’ section. Click on ‘OK’ and this will set up the selected rows as the automatic title rows for printing on each page of the worksheet.