Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
print area selection slows excel, formula for hiding rows??
I have very large data sheets that I need to print out and at times I would
only like certain rows to print. When I go to page setup and select the rows I want and I have seperate ranges that I would like printed it slows the whole excel sheet down. It take several minutes for the workbook to respond to a simple command. Is there a fix for this? If not I am thinking I could hide the rows, but would like it automatic. Here is an example fo what I am trying to I will need the first 30 rows to be printed, the next 30 rows are blank and I dont want them printed, but I dont want to delete them because they will eventually have data filled in. Then I have about another 10 rows that total all my data. Is there a formula or a setting that will automatically hide the rows I do not want printed and move my bottom totaling rows up to be printed on the same page. I am using Excel 2003 Thanks Suzanne |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
print area selection slows excel, formula for hiding rows??
Maybe you could use data|filter|autofilter to show/hide rows.
But I think I'd look into getting a fresh printer driver, too. In fact, you may want to change to a different printer just to test it. One more thing to try...If you're using a network printer, then try installing the drivers locally to see if that helps. sbrimley wrote: I have very large data sheets that I need to print out and at times I would only like certain rows to print. When I go to page setup and select the rows I want and I have seperate ranges that I would like printed it slows the whole excel sheet down. It take several minutes for the workbook to respond to a simple command. Is there a fix for this? If not I am thinking I could hide the rows, but would like it automatic. Here is an example fo what I am trying to I will need the first 30 rows to be printed, the next 30 rows are blank and I dont want them printed, but I dont want to delete them because they will eventually have data filled in. Then I have about another 10 rows that total all my data. Is there a formula or a setting that will automatically hide the rows I do not want printed and move my bottom totaling rows up to be printed on the same page. I am using Excel 2003 Thanks Suzanne -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Format worksheet to view only the print area cells in Excel | Excel Discussion (Misc queries) | |||
Excel 2003 Print Issue | Excel Discussion (Misc queries) | |||
Updating rows - Excel Formula or Something Else? | Excel Worksheet Functions | |||
How do I only show print area in excel? | Excel Discussion (Misc queries) |