Ask Your Question

how can I print part of the calc grid without cells numbers/letters [closed]

asked 2012-06-25 18:40:57 +0100

anonymous user



I have done a pretty grid I want to print but I don't want to print "cells indexes" ( first column with numbers and first line with letters ).

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-16 22:00:52.046915

2 Answers

Sort by » oldest newest most voted

answered 2012-06-25 21:36:12 +0100

qubit gravatar image

To turn on/off gridlines or row/column headers, you'll need to go into the Page Formatting dialog.

Go to: Format -> Page, then go to the "Sheet" tab. Under the "Print" heading, make sure that the box is checked for "Grid", and unchecked for "Column and row headers".

edit flag offensive delete link more


some minutes faster than me :) ... took some time to upload the screenshots...

tohuwawohu gravatar imagetohuwawohu ( 2012-06-25 21:41:15 +0100 )edit

answered 2012-06-25 21:40:16 +0100

tohuwawohu gravatar image

To enable printing the grid just for the current sheet, select Menu "Format" -> "Page..." and select the "grid" option:

print grid

If you want to activate this option permanently, you should modify the page style. To do this, select Menu "Format" again, then "Styles and Formatting", or hit F11. A window showing the available styles will appear:


Select the second button at top to select the page styles. To modify the "Default" page style, right-click the "Default" entry, select "Modify..." from the context menu. You will see the same dialogue as displayed above.

edit flag offensive delete link more

Question Tools


Asked: 2012-06-25 18:40:57 +0100

Seen: 1,756 times

Last updated: Jun 25 '12