This will make sure that your pages include the gridlines when printed. Under the Print section, check the box next to ‘Gridlines’.Select the ‘Sheet’ tab at the top of the dialog box.The Page Setup dialog box should now appear.Click this tool to launch the Page Setup dialog box.

At the bottom right corner of this group, you’ll see a tiny dialog box launcher tool.Under this tab, look for the ‘ Page Setup’ group of tools.You can do this by dragging your mouse to make a box around your print area. Select the area of your worksheet that you want to print.Here are the steps you need to follow for this: If you want to make sure that gridlines get printed to the page along with your data, you need to open the Page Setup launcher. It provides a shortcut to open dialog boxes or task panes related to a particular group. This is a tiny icon that appears in a group. In this method, we will use a dialog box launcher tool ( ). Method 2: Printing Gridlines using Page Setup Launcher Tool This was one way of adding gridlines to your printouts. If everything looks alright, press the large Print button on the left-hand side to start printing. From here, you can see on the right-hand side how your print page is going to look.This will bring you to Print Preview mode. If you now want to print your sheet, press CTRL+P (if you’re on a Mac, press Cmd+P), or navigate to File->Print.This will make sure that your printouts include gridlines when you decide to print your sheet.Make sure the checkbox next to ‘Print’ is checked. Under the Gridlines option, there are two checkboxes – View and Print.

This group contains two options, one for the Gridlines and another for the Headings.

Under this tab, look for the ‘ Sheet Options’ group of tools.

You’ll find this in the top portion of your Excel window. Here are the steps to add gridlines to your page using this method: The easiest and quickest way to add gridlines to your printouts is using the ‘ Sheet Options’ group. Method 1: Printing Gridlines using Sheet Options So, let us see three ways to make sure the gridlines get printed along with the data. It gets even harder when you have larger datasets with multiple rows of data. The printout does not have any grid lines separating the cells, so it is hard to tell the rows apart.

Openoffice print gridlines