![openoffice print gridlines openoffice print gridlines](https://dt.azadicdn.com/wp-content/uploads/2014/03/OpenOffice-spreadsheet6.jpg)
However, you can use borders to give a gridline effect in a specific area in the worksheet. There is no way to show this in a specific area. In Excel, you can either have the gridline visible in the entire worksheet or hide it completely.
Openoffice print gridlines how to#
How to Show Gridlines in a Specific Area in the Worksheet Make sure to Ungroup the sheets (right-click on the tab and select ungroup) else all the changes you do in the current sheet would also be reflected in all the worksheets. Now change the gridlines view setting and it will be applied to all the worksheets. You would notice that the workbook is in the Group Mode (see the top of the workbook where the name is displayed). If you want to remove the gridlines from all the worksheets at one go, select the worksheets by holding the Control Key and selecting the tabs (this would group sheets together).( Note that you need to remove the fill color to make the gridlines visible). Hence, if you apply the fill color to the entire worksheet, the gridlines wouldn’t be visible. If the gridlines are visible, and you apply a fill color in a specific area, you would notice that the gridlines disappear and the fill color takes over. You can also remove the gridlines by applying a background fill to the cells in the worksheet.If you remove the gridlines from one worksheet, it would still be visible on all the other worksheets. This setting is specific to each worksheet.
![openoffice print gridlines openoffice print gridlines](https://sm.pcmag.com/t/pcmag_au/photo/o/openofficeorg-30-paragraph/openofficeorg-30-paragraph_du1j.1080.jpg)