hiding rows

[karl middleton]

I want to find a quick way to hide various rows in a spreadsheet that contain
zero values. i.e. below example i want to hide the whole row 'oranges'

sales

apples 100
pears 200
oranges 0
bananas 30

I have quite a lot of rows that may need hiding and any help would be
appreciated, thanks.

 

[Don Guillett]

data>filter>autofilter

 

[karl middleton]

Thanks for that Don, but what if you have multiple areas in a spreadsheet for
instance sales, costs, and overheads. You cannot filer multiple selections
in a sheet.

 

[Don Guillett]

Another example perhaps or send me a workbook.

 

[karl middleton]

example. . .

sales
apples 100
bananas 50
pears 0
oranges 10

(another section of sheet - few rows down from the above)
costs
staff 75
materials 10
phone costs 0
light cost 5

i am after hiding the zero values for sales aswell as the costs, thanks Don.

 

[Don Guillett]

Then why can't you just filter by 0 and sales??

 

[Don Guillett]

If you still can't get it, send me a workbook with an explanation.