I am a special education teacher who has been given an excel template to keep
my student's data on. I have two problems with the template:

1) The individual sheet tabs are hard to read. The font color is almost
exactly the same as the white background. It is a very light gray. The file
has many individual worksheets so that it is almost guess work to find the
actual sheet I am looking for. How do I change the font color of the little
tabs at the bottom of the template? I know how to do it in a cell....but for
whatever reason I can't make the text in the little tab be black so that I
can read it.

2) The template is set up so that each student has three linked worksheets.
Sheet 1 is demographic data, Sheet 2 is raw data, Sheet 3 is a chart
displaying performance....and then the sequence begins again for the next
student How can I duplicate the 3 inidvidual sheets so that they remain
linked? I have made new worksheets and I have cut & pasted the formulas but
the new sheets are not linked when I do so. I don't know the meaning of the
individual formulas to fix them. I just want to add more students without
creating a brand new file for each student.

Sorry for being a noob........

Thanx for any help.

Shawn

1) right-click on the tab and select Tab Color...

2) again right-click on the sheet you want to duplicate select Move Or
Copy, select where you want the copy( what book and before what sheet)
and check the create a copy checkbox, click OK.



Shawn iin Philly wrote:
I am a special education teacher who has been given an excel template to keep
my student's data on. I have two problems with the template:

1) The individual sheet tabs are hard to read. The font color is almost
exactly the same as the white background. It is a very light gray. The file
has many individual worksheets so that it is almost guess work to find the
actual sheet I am looking for. How do I change the font color of the little
tabs at the bottom of the template? I know how to do it in a cell....but for
whatever reason I can't make the text in the little tab be black so that I
can read it.

2) The template is set up so that each student has three linked worksheets.
Sheet 1 is demographic data, Sheet 2 is raw data, Sheet 3 is a chart
displaying performance....and then the sequence begins again for the next
student How can I duplicate the 3 inidvidual sheets so that they remain
linked? I have made new worksheets and I have cut & pasted the formulas but
the new sheets are not linked when I do so. I don't know the meaning of the
individual formulas to fix them. I just want to add more students without
creating a brand new file for each student.

Sorry for being a noob........

Thanx for any help.

Shawn