Ask Your Question
0

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
0

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

pierre-yves samyn gravatar image

Hi

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)

Regards

edit flag offensive delete link more
0

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

Opaque gravatar image

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

Hello

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

Stats

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

Seen: 33 times

Last updated: Jul 03