jamieleeuk
Board Regular
- Joined
- Feb 9, 2009
- Messages
- 99
I went into the page setup for one of my worksheets to set it to Lanscape so it would fit neatly onto one page.
When I previewed it though, it says there are 6 pages in total, but all 5 after the data page are empty?!
It's possible something is in one of those cells causing it to print out that many pages - but is there a quick way of finding out how or clearing everything after a certain cell.
Eg, if my last cell in use is O:30 is there a formula or code I can run to clear evertything after this?
I just want it to come out on its own without being followed by 5 blank pages!
Thanks for help
When I previewed it though, it says there are 6 pages in total, but all 5 after the data page are empty?!
It's possible something is in one of those cells causing it to print out that many pages - but is there a quick way of finding out how or clearing everything after a certain cell.
Eg, if my last cell in use is O:30 is there a formula or code I can run to clear evertything after this?
I just want it to come out on its own without being followed by 5 blank pages!
Thanks for help