View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default hiding even (or odd) rows in excel 2003

Hi Jason

One way
In a spare column enter following formula
=MOD(ROW(),2)=0
Copy down as far as required.
Highlight first cell, DataFilterAutofilterselect from dropdown TRUE
--
Regards

Roger Govier


"9d1awd" wrote in message
...
I am curious as how to hide even , or odd rows in 2003 , not based on
information in them but the actual row numbers themselves.

Jason