Thread: Hiding Rows
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Hiding Rows

Hi,

Select A1 then
data|Filter|Autofilter

click the down arrow and rom the dropdown select 'Does not equal'
enter 0 (zero)

OK

Mike

"Graham Moore" wrote:

I have a cell that has 0 for a total and I want to hide the entire row that
cell is in. Expamle: if cell A1 is '0', I want to hide row 1. Any ideas
how I can do that. I am using excel 2003.
Thanks
Graham