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.

Julie wrote:

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

--

Dave Peterson