Ask Your Question

how to print gridlines in a spreadsheet

asked 2019-07-02 17:17:52 +0200

joannie gravatar image

how to print gridlines in a spreadsheet and make the orientation of page landscape

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-07-03 08:25:45 +0200

pierre-yves samyn gravatar image


Defining borders is not always necessary. In many cases, it is sufficient to ask for the grid to be printed. This is a property of the page style that can be set:

Tick FormatPageSheet tab▸PrintGrid

@Opaque explained how to get the landscape format. I would add that it might be useful to create a new page style for this purpose in order to be able to possibly "mix" the orientations in the spreadsheet (not all sheets may have to be printed in landscape). FormatPage modifies the current page style (the default page style)


edit flag offensive delete link more

answered 2019-07-02 19:13:52 +0200

Opaque gravatar image

updated 2019-07-02 19:15:10 +0200


1st question (gridlines): Format cells to have borders Edit -> Select All, right click, select Format Cells from dialah and set borders in tab Borders (Instead of "all cells" you may also set only range of cells being printed)

2nd question (landscape): Format -> Page -> Tab: Page -> Category: Paper Format -> Option: Orientation tick Landscape

If the answer is correct or helped you to fix your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-02 17:17:52 +0200

Seen: 33 times

Last updated: Jul 03