Print Area

kebodebo

New Member
Joined
Sep 22, 2009
Messages
43
I have many rows that contain basic location information and need to only print those rows with data in it. I could have as many as 100 rows (locations) or just one. Is there a way to set the print area automatically based on the number of locations (rows)?

Thanks
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,108,577
Messages
5,523,686
Members
409,531
Latest member
wo1f

This Week's Hot Topics

Top