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!!!!!

I have a number of tables which show all possible categories, but in
each month not all these categories will be used. In order to avoid
printing them I put a simple formula in a helper column (to the right
of the print area) which basically takes the count on that row - in
your case this would be =ytd total, copied down.

You can then apply a filter to these numbers - custom, not equal to,
zero, to hide the rows temporarily while you print. Then select All
from the filter to reveal them again.

Hope this helps.

Pete

On Oct 24, 1:22 am, ejt1234 wrote:
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!!!!!

Excel doesn't have an equivalent.

I sometimes add a column to the data (insert a new column A and make sure that
the print range doesn't include column A).

Then I'll put a formula in that cell that determines if that row should be
hidden. Then I apply Data|Filter|autofilter to filter by that column.

ejt1234 wrote:

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!!!!!

--

Dave Peterson

"ejt1234" wrote:

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!!!!!
Pete, I think that will work! I won't know until I try it on Monday but you
are my hero!
ejt1234

Well, thank you ! But Dave has suggested more-or-less the same thing
(he's my hero !! <bg).

Pete

On Oct 26, 10:54 pm, ejt1234
wrote:
"ejt1234" wrote:
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!!!!!

Pete, I think that will work! I won't know until I try it on Monday but you
are my hero!
ejt1234

You are the wind beneath my wings!

<gd&r

Pete_UK wrote:

Well, thank you ! But Dave has suggested more-or-less the same thing
(he's my hero !! <bg).

Pete

On Oct 26, 10:54 pm, ejt1234
wrote:
"ejt1234" wrote:
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!!!!!

Pete, I think that will work! I won't know until I try it on Monday but you
are my hero!
ejt1234

--

Dave Peterson