View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Graham Graham is offline
external usenet poster
 
Posts: 155
Default hide row on spreadsheet

please advise if it is possible to hide a row if data is entered in a
specific cell within that row.As an example if I enter the text "Yes" in cell
D2, then row 2 must then be hidden !! Just a thought as I am creating a
spreadsheet to track items and once I have actioned a certain task I then
want to auto hide that item.

Thanx Graham