Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what to do with unused cells | Excel Worksheet Functions | |||
deleting unused cells / getting rid of inactive cells | Excel Discussion (Misc queries) | |||
How to make unused cells blank | Excel Discussion (Misc queries) | |||
Is there a way to cut off unused cells on a sheet | Excel Discussion (Misc queries) | |||
how get rid of cells with unused formulas | Excel Discussion (Misc queries) |