Showing Gridlines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I cannot seem to be able to print the gridlines on the part of the paper where there is no typing. I made up columns with headings and that's the only area that the lines are printing. Heeelllllpppp!
 
Select the entire range you want to print and then use File, Print Area, Set
Print Area.
 
Hi Linda,
See http://www.mvps.org/dmcritchie/excel/gridline.htm
for troubleshooting some problems you may encounter with gridlines.

If you convert to HTML you have another set of problems, due
to empty cells.


Linda T. said:
I cannot seem to be able to print the gridlines on the part of the paper where there is no typing. I made up columns with
Click to expand...
headings and that's the only area that the lines are printing. Heeelllllpppp!
 
Linda

What I have done, on occasion, when I want the gridlines to appear on the
whole page is to just put a "." (period) in the last cell of the sheet at
the bottom right of the sheet. Gridlines print on the whole page and the "."
is almost unnoticeable on the printed page.

Walt Mayes
David McRitchie said:
Hi Linda,
See http://www.mvps.org/dmcritchie/excel/gridline.htm
for troubleshooting some problems you may encounter with gridlines.

If you convert to HTML you have another set of problems, due
to empty cells.


"Linda T." <The Samra Group> wrote in message news:[email protected]...
Click to expand...
where there is no typing. I made up columns with
 
Ok, I see I did not read the question properly, as you want to
see the gridlines past the lastcell.

That's the kind of thing I just accept. Walter's solution, of course
works, because it changes the last cell. But I was surprised at
Jim's solution that setting the print area would also expand the
area that the gridlines show for.
 
Back
Top