Excel 2007 - print gridlines

  Graham. 17:27 14 Dec 2010

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 2010

Page Layout/Gridlines and check print tick same with Headings

  Graham. 17:35 14 Dec 2010

Done that already, thanks.

  Graham. 17:38 14 Dec 2010

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

  VoG II 17:42 14 Dec 2010

Why not apply borders to the range?

  AroundAgain 17:53 14 Dec 2010

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 2010

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

  Graham. 23:49 14 Dec 2010

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

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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment utiliser Live Photos ?