How to leave out unused cells when printing?
 

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?

How to leave out unused cells when printing?
 

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

"HoganD87" wrote:

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?