Ask Your Question

How can I get the gridlines to print on the whole spreadsheet? [closed]

asked 2014-09-14 05:04:16 +0200

Tamara gravatar image

updated 2014-10-13 01:40:25 +0200

qubit gravatar image

When I go to sheet- show grid, it only prints the cells and gridlines with things written in it. I want the whole paper to be gridlines though. And if this is not possible how do I insert a table and get it to print empty of any data inside?

I am trying to print the gridlines on a spreadsheet, but I do not know how to do it. Help

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 2016-03-04 20:26:00.361579



crimsonfox61 gravatar imagecrimsonfox61 ( 2013-01-28 22:02:16 +0200 )edit

Hi @crimsonfox61, If @Edward answered your question, please mark his answer as correct. Thanks!

qubit gravatar imagequbit ( 2013-01-28 22:12:43 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2013-01-28 19:20:08 +0200

Edward gravatar image

updated 2014-10-13 01:42:10 +0200

qubit gravatar image

Assuming you mean grid lines: Format/Page/Sheet, check grid in the print (middle) section

edit flag offensive delete link more


Hi! Did this as you suggest yesterday, and it worked! But today it no longer works even with Format/Page/Sheet <grid> box checked. And OBTW: All grid lines show when viewing the doc in 'Print Preview" Any ideas?? Thanks. . . ---rob

robhwill gravatar imagerobhwill ( 2019-07-21 04:38:49 +0200 )edit

This causes the grid lines to be printed only in the area where cells are filled in. How can we get the entire grid to be printed even where cells are empty?

Catlike gravatar imageCatlike ( 2020-03-17 01:01:43 +0200 )edit

answered 2014-09-14 09:22:30 +0200

Kunjomachen gravatar image

updated 2014-09-14 09:34:02 +0200

Select the cells and apply border, then from View -> Page Break Preview, check the blue borders and move it if necessary.

image description ............................................................... image description

edit flag offensive delete link more

answered 2014-09-16 00:07:49 +0200

horst gravatar image

Another way: Menue-Format > page > Tab:sheet under Print check Grid.

edit flag offensive delete link more

answered 2014-09-14 11:08:19 +0200

m.a.riosv gravatar image

Another way is defining the range to print: Menu/Format/Print ranges.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-09-14 05:04:16 +0200

Seen: 56,698 times

Last updated: Oct 13 '14