If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Printing only what can be seen
Ok, I have a worksheet or template rather with about 200 rows (each row
size 14 font), each row (after the 7th row) has the same conditional formats and formulas in the same columns. The conditional formats and formulas are done such that every cell is a blank cell until data is entered into a cell on that row. Now, each day I paste in data, but it's not everyday that all 200 rows are needed. However, Excel still wants to print each and every last row that I have those conditional formats and formulas on, despite the fact that they have no visible data in them. Excel just prints up extra blank pages. I wouldn't mind, except that I have footers and rows repeated at the top on my page setup. So I think you can understand my fustration when I print up wasted paper that have my repeated rows at the top and page of 1 of # at the bottom. Is there any way that Excel will only print my worksheet up to the last row with data that can actually be seen? --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Printing only what can be seen
See one guess at your other post.
"abxy " wrote: Ok, I have a worksheet or template rather with about 200 rows (each row size 14 font), each row (after the 7th row) has the same conditional formats and formulas in the same columns. The conditional formats and formulas are done such that every cell is a blank cell until data is entered into a cell on that row. Now, each day I paste in data, but it's not everyday that all 200 rows are needed. However, Excel still wants to print each and every last row that I have those conditional formats and formulas on, despite the fact that they have no visible data in them. Excel just prints up extra blank pages. I wouldn't mind, except that I have footers and rows repeated at the top on my page setup. So I think you can understand my fustration when I print up wasted paper that have my repeated rows at the top and page of 1 of # at the bottom. Is there any way that Excel will only print my worksheet up to the last row with data that can actually be seen? --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|