how to make openoffice excel sheet print lines

Troubleshoot printing issues with gridlines – If gridlines don't show up when you print your worksheet, or if you can't see them in the Print Preview window, check that the Draft quality check box is not selected. To learn more about these options, see Define or clear a print area on a worksheet or Apply or remove cell borders on a worksheet. Or, you can apply borders around the cells instead. If you want to print gridlines around empty cells also, you must set the print area to include those cells. Gridlines print only around actual data in a worksheet. Preview the gridlines – To see how the gridlines will print, press Ctrl+F2 to open the File tab, which displays a preview of printed worksheet. Keyboard shortcut You can also press Ctrl+P.Īfter you select the Print check box, you might want to take the following steps: If you cancel that selection, you'll be able to use the check boxes.Ĭlick the File tab, and then click Print. Note: If the check boxes in the Sheet Options group appear dimmed, it may be because you have a chart, image, or other object selected on the worksheet.

How to make openoffice excel sheet print lines