How to leave out unused cells when printing?

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

Guest

I have put borders on my cells for 200 rows. I'm only using 50. How do I make
it to where my computer only prints cells with information on them?
 
Because of the borders, Excel thinks those extra 150 rows are something of
interest to you (perhaps even a form for a crossword puzzle <g>) and so it
prints them by default.

Look into File | Page Setup. On the [Sheet Tab] you'll find a "Print Area"
item. Click in the entry area and then select the cells you want to be
printed, or just type in the address as A1:G50

But you'll have to remember to change that as you add more used rows after
row 50 (if you insert rows above row 50, the range will change automatically
if you enter the address as I've shown above, without any $ symbols in it).
 

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

Back
Top