View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dowitch Dowitch is offline
external usenet poster
 
Posts: 8
Default Hide Alternate Rows temporarily to Edit worksheet

I would create a new column and number each row alternately (1,2) or ( ,1)
then filter for whichever row you want to look at.

"Bridget~" wrote:

I am trying to figure out how to hide every other row temporarily (rows 2, 4,
6, etc) so I can edit remaining data in columns that only affect rows 1, 3,
5, etc. Anyone know how to do this? Thanks in advance!