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!

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!

You could try this (not exact solution). In a helper column, input formula
=MOD(ROW(),2)
and copy down.
Now do an AutoFilter on this column for either 0 or 1, depending on which
rows you want to keep.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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!