Printing in Excel2000?
Is it possible to suppress printing of hidden pages (rows) in Excel2000?
|
Printing in Excel2000?
???
Hidden rows do not print by default. HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "PaulM" wrote: Is it possible to suppress printing of hidden pages (rows) in Excel2000? |
Printing in Excel2000?
You added a bunch of manual page breaks. Then you hid lots of rows, but the
page breaks still cause blank sheets of paper to come out of the printer? (Discounting headers/footers.) If that's what you mean, then how about just copying the visible rows to a new worksheet and print from there. Select your range edit|goto|special|visible cells only edit|copy edit|paste in that new worksheet. You'll have to reapply the pagebreaks you want. .... Or you could copy the worksheet edit|move or copy sheet then remove all the hidden rows on that sheet. then print and delete that helper sheet. You could even use a macro: Option Explicit Sub testme() Dim curWks As Worksheet Dim tempWks As Worksheet Dim iRow As Long Dim LastRow As Long Set curWks = Worksheets("sheet1") curWks.Copy 'to a new workbook Set tempWks = ActiveSheet With tempWks LastRow = .Cells.SpecialCells(xlCellTypeLastCell).Row For iRow = LastRow To 1 Step -1 If .Rows(iRow).Hidden = True Then .Rows(iRow).Delete End If Next iRow .PrintOut preview:=True .Parent.Close savechanges:=False End With End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm PaulM wrote: Is it possible to suppress printing of hidden pages (rows) in Excel2000? -- Dave Peterson |
All times are GMT +1. The time now is 10:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com