Grid Lines

[Guest]

How do i print grid lines WITHOUT the text in the grid lines?

 

[Guest]

So, you want blank graph paper?

Try here:
http://office.microsoft.com/en-us/templates/CT101448201033.aspx?av=ZXLThat's
Microsoft Graph paper templates.

 

[Guest]

Thanks foir repling Lauren, but I do not want graph paper. I do have some
text in some of the grids. It only prints where the text is. I do need for
it to be both.
Julie

 

[Guest]

Oh, got it. I'm just going to restate what you want for my own benefit: you
have a worksheet with text in some places and blank in others, but you want
the grid lines to stay there, even if there's no text in them. Got it.

Okay, are the empty cells formatted to actually have grid lines (not the
default gray lines that don't print)? Highlight the cells you want to have
the grid lines, then Format> Cells> Border. Make sure you choose visible
lines (like black) and apply them. I'm guessing you've already done this,
right? Well, it won't print all of those lines there unless you put something
in a box at the bottom right. Make the print lines visible so that you can
see which box is the bottom right. Put a space in that box. Now, print
preview. That should make the whole page have the gridlines, even the boxes
without text.

 

[Dave Peterson]

It sounds like excel is only printing the range that has values (or formulas) in
the cells.

You could also use:
Select the range to print
file|print area|set print area

or
select the range to print
File|Print
Check Selection on that dialog (lower left corner)

Excel "knows" how much to print by where values or formulas have been.

Instead of a space character like Lauren suggested, I use:
=""
in the bottom right corner of the cell to print.

I find that that is easier to see in the formula bar and because it's kind of a
weird formula, it serves as a reminder why it's there.