Hiding Row

[toe222]

i am converting a file from lotus to excel. lotus has a
thing that if you put "ll" in a cell it will not print
that entire row. it also moves the the other rows up so
there is not a gap in the spacing. i cannot find this in
excel....HELP! thanks...toe

 

[Frank Kabel]

Hi
not sure if this is what you want:
Select the rows you want to hide and goto 'Format - Rows - Hide'

Frank

 

[Ron de Bruin]

Hi

Excel don't have this.
Try a example on this page to hide rows or make the text white of the cells
http://www.rondebruin.nl/print.htm

 

[toe222]

no cause sometimes i need that row to print based on other
conditions. i wrote a function @if(a1=x,"ll",""). this
way if it saw an 'x' then it knew not to print that row.
thanks for the help though...toe

 

[Dave Peterson]

I'm not sure if you found your solution, but if you used that helper cell in a
column outside the print range (or just hide it before you print), you could
apply Data|Filter|autofilter and just show the cells "not equal to" ||.