Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping status on posed questions in Excel | Excel Discussion (Misc queries) | |||
I'm having trouble finding my posted questions? | Excel Discussion (Misc queries) | |||
Excel - how can I practice formulas on financial questions? | Excel Discussion (Misc queries) | |||
Finding my previous questions... | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) |