View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul C Paul C is offline
external usenet poster
 
Posts: 269
Default Hide Raws even the Auto Filter is active

You can set the row height to 1 (0 won't work). Not really hidden, but
visually the same result.


--
If this helps, please remember to click yes.


"Saji" wrote:

How to hide the raws permentanly of the Excel sheet 2003, even when the
filter is active?

If the filter is active, the hidden raws again unhide when we select "All"
option in the Auto Filter.