Temporarily hide rows without data:


1. in IV1 put a label

2. in IV2 enter:
=COUNTIF(A2:IU2, "") and copy down
cells showing 255 represent empty rows

3. select IV1 and pull-down:
Data Filter Autofilter

4. go back to IV1 and click the dropdown and select (Custom...)
drop-down and select does not equal
and enter 255 in the next field


The empty rows will be hidden and will not print. You can use variations of
this to hide rows based upon lots of criteria.
--
Gary's Student


"superkopite" wrote:


Hiya Guys and gals

could someone please help me out

i have 200 rows, in all rows there is somekind of forumla. what i want
to do is only print the rows that have had data entered into them

Is this possible or am i living in dreamland

cheers
James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=503750