L
Larry Weaver
Hello -
I am a teacher in an alternative school where we must keep
up with the contact hours of each student. I have been
doing this with Excel for 2 years but there is one thing
that really bugs me. I shade every other row light gray
to make the easier to follow a given student across an
entire month. This works fine until I have to add a new
student (I keep them in alpha order). I can't copy, cut
and paste because that screws the shadings up so I have to
insert a row, etc. etc...
Bottom line - can I lock the shadings of a row so I can
copy and paster data only?
Thank you
I am a teacher in an alternative school where we must keep
up with the contact hours of each student. I have been
doing this with Excel for 2 years but there is one thing
that really bugs me. I shade every other row light gray
to make the easier to follow a given student across an
entire month. This works fine until I have to add a new
student (I keep them in alpha order). I can't copy, cut
and paste because that screws the shadings up so I have to
insert a row, etc. etc...
Bottom line - can I lock the shadings of a row so I can
copy and paster data only?
Thank you