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

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.
 
P

Pete_UK

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
 
D

Dave Peterson

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.
 
B

Bruce Sinclair

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top