Excel 2007 - print gridlines

  Graham. 17:27 14 Dec 10

I'm trying to print out a sheet that has only Headers in freeze frame so that I can write in the blank spaces. I've tried all the obvious, but nothing gets the grid lines to appear in print preview, or the print.


  compumac 17:31 14 Dec 10

Page Layout/Gridlines and check print tick same with Headings

  Graham. 17:35 14 Dec 10

Done that already, thanks.

  Graham. 17:38 14 Dec 10

It seems it will only print gridlines of cells that have content.

  VoG II 17:42 14 Dec 10

Why not apply borders to the range?

  AroundAgain 17:53 14 Dec 10

It will only print out gridlines to the extent of cell content being input. So, as a 'work around' I put a 'full stop' (because it is the less intrusive) in the lowest right cell, and have the 'tick' for printing gridlines.

If you go into Preview, and then back into your worksheet, you will see guider lines as to where your page ends, making it easier to know which cell to put your 'full stop'.

Hope this helps you

  uk-wizard 18:11 14 Dec 10

As VoG™ sayes , highlight all the sheet then format > cells > borders > all.

  Graham. 23:49 14 Dec 10

Borders did it. I can now format my Christmas Card list.

This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Animator Emanuele Kabu’s psychedelic video is a stunning tribute to Lisbon city

Best Mac antivirus 2017