In Excel, how do I get blank rows and columns to print?

  • Thread starter Thread starter cvfc the dj
  • Start date Start date
C

cvfc the dj

I'm working on a simple, one page spread sheet, and want to print extra blank
cells
on the bottom and to the right of my data cells. Say 10 extra blank rows on
the bottom and 3 extra blank rows to the right.

what do I need to do so the blank rows will print?
thanks very much for any help.
Go Tribe.
 
Are you printing gridlines or borders for those empty cells? If not,
then nothing will show on the printout.

If you are, then all you need to do is make your print area larger.
Highlight the cells that you want to print (including the blanks) and
click on File | Print Area | Set Print Area.

Now if you do File | Print Preview you can see what the effect will
be.

Hope this helps.

Pete
 
You could change the print area.

In xl2003, you can:
Select the area to print
File|print area|set print area

But if you want to just let excel determine the print range, you could put
something in the bottom right corner.

I like to use a formula that makes the cell look empty:
=""

It's enough for me to notice and remember why it's there.
 
Are you printing gridlines or borders for those empty cells? If not,
then nothing will show on the printout.

If you are, then all you need to do is make your print area larger.
Highlight the cells that you want to print (including the blanks) and
click on File | Print Area | Set Print Area.

Now if you do File | Print Preview you can see what the effect will
be.
Click to expand...

Alternatively, you could put a small (or maybe an unprintable ?) character
in the cell you want it to print to. I use a "." for this.
 
Back
Top