2 questions
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 |
2 questions
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 |
All times are GMT +1. The time now is 03:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com