How to Print Gridlines on an Excel Sheet With Open Office

Written by jerry garner
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Print Gridlines on an Excel Sheet With Open Office
OpenOffice is a suite of computer software programs that can read and edit Microsoft Office documents. (computer keyboard image by vashistha pathak from

Gridlines help you view charts, graphs or text in an Excel spreadsheet. Using gridlines, you can easily position information in the file. The free open-source software OpenOffice includes a spreadsheet program, Calc. Open Excel files in Calc and make relevant changes to the page style to print gridlines.

Skill level:

Other People Are Reading

Things you need

  • OpenOffice

Show MoreHide


  1. 1

    Open the Excel spreadsheet using the Calc spreadsheet program included with OpenOffice. First open Calc, then open the Excel sheet you want to print.

  2. 2

    Select the page style preferences. From the Toolbar, click the "Styles and Formatting" tab. The Styles and Formatting window opens. On the Styles and Formatting window, click the "Page Style" icon appearing on the menu bar on the top. A list of page styles appears. If no list appears, select "All Styles" from the drop-down list on the bottom of the window. You will now see a list of all the page styles. From the list of page styles, right-click the page style you want to modify to print gridlines. The context menu opens.

  3. 3

    Click the "Modify" option. The "Page Style: Default" window opens.On the Page Style: Default window, the "Organizer" tab will be shown by default. Click the "Sheet" tab. On the Sheet tab, under the Print section, check the box for the "Grid" option. Click "OK."

  4. 4

    Double check to make sure the gridlines are showing. To check whether the gridlines appear along with the data while printing, on the Menu bar, click "File," then "Page Preview". Click on the "Zoom In" icon on the Toolbar to zoom in the Excel sheet. You will now see that the gridlines are visible on the sheet and will appear with the data when you print the Excel sheet.

Tips and warnings

  • Instead of clicking the "Styles and Formatting" tab on the Toolbar, you can also press F11 on the keyboard to open the Styles and Formatting window.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.