Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I suppress printing a row without hiding it?
I am converting from Lotus to Excel. I use the "||" characters in the first
column of my spreadsheets print range to suppress the print of the row without having to hide it. This is essential for my updates, so I don't spend time displaying rows now have data pulling into them. What is the Excel equivalent? Custom views does work, but it is extremely inefficient to unhide/hide the rows from month to month over 83 different departments. In Lotus, I write a formula that essentially is = if the ytd total = zero then "||", otherwise put a zero. I turn the zero hide on, and set the print range and all rows in which the ytd = zero don't print. Lotus will even adjust the print range to account for the rows not printed. HELP!!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
suppress printing on certain rows | Excel Discussion (Misc queries) | |||
how do you suppress zero lines when printing reports | Excel Discussion (Misc queries) | |||
how do I suppress printing blank lines in a worksheet? | Excel Discussion (Misc queries) | |||
Suppress printing workbook | Excel Discussion (Misc queries) | |||
suppress printing a repeating value in a column | Excel Discussion (Misc queries) |