Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I suppress printing blank lines in a worksheet?
I have rows in my spreadsheet that are blank in terms of conditional formulas
set up to return blanks under specific conditions. Is there a way to suppress the printing of, or automatically hide completely blank rows? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I suppress printing blank lines in a worksheet?
Can you use data|Filter|autofilter to show just the rows that don't appear
empty? === If those formulas appear at the end of the data and you don't want to use autofilter... If I can pick out a column indicates if that row is used or not, then I like this technique: (I used column A in my sample, but you can use any column you want.) Insert|Name|Define Names in workbook: Sheet1!LastRow Use this formula Refers to: =LOOKUP(2,1/(Sheet1!$A$1:$A$1000<""),ROW(Sheet1!$A$1:$A$1000) ) (Make that 1000 big enough to extend past the last possible row.) Then once mo Insert|Name|Define Names in workbook: Sheet1!Print_Area Use this formula Refers to: =OFFSET(Sheet1!$A$1,0,0,lastRow,3) That last 3 represents the last column to print (A:C in my example). And change the worksheet (sheet1) if necessary (in all the places). Rob M'Crystal wrote: I have rows in my spreadsheet that are blank in terms of conditional formulas set up to return blanks under specific conditions. Is there a way to suppress the printing of, or automatically hide completely blank rows? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i delete blank lines at bottom of an Excel worksheet? | Excel Discussion (Misc queries) | |||
a problem with blank lines | Excel Worksheet Functions | |||
Printing Recto/Verso | Excel Discussion (Misc queries) | |||
how do I print grid lines for blank rows | Excel Discussion (Misc queries) | |||
how do I print grid lines for blank rows | Excel Discussion (Misc queries) |