a few tricks to take you beyond the basics of microsoft office 2010
DESCRIPTION
A few tricks to take you beyond the basics of Microsoft Office 2010. GCPS Tech Tips. Microsoft Excel 2010 : Adding Color Tabs To Worksheets . Excel 2010 : Adding Color Tabs to Worksheets. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/1.jpg)
Gwinnett County Public Schools
A few tricks to take you beyond the basics of Microsoft Office 2010
Microsoft Excel 2010 : Adding Color Tabs To Worksheets
GCPS Tech Tips
![Page 2: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/2.jpg)
Gwinnett County Public Schools is committed to providing information related to student technology use in a manner that is clear, concise, organized, accessible, and current. To that end, GCPS has provided articles and handouts on its website.
The following resource is provided for information only and is NOT an official policy or procedure of Gwinnett County Public Schools. This resource may be used by schools and the school communities to share information and ideas around student technology use. Should a conflict between the information on this site and the existing policy, regulation or rule occur, then the official or approved policy, rule or regulation supersedes the resources in this document.
Excel 2010 : Adding Color Tabs to Worksheets
![Page 3: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/3.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
If you are keeping records in several Excel worksheets and you would like to make them easier to identify, there are a couple of easy
changes you can make.
![Page 4: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/4.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
Instead of the “Sheet 1”... “Sheet 2”... designations that Excel gives you to start with, why not name
each tab something more meaningful?
![Page 5: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/5.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
All you have to do is place your cursor on a tab you want to rename...
![Page 6: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/6.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
double-click the left button on your mouse...
![Page 7: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/7.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
The lettering for Sheet 1 will become highlighted and then type the new name
you want on the tab.
![Page 8: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/8.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
Press “Enter”...
![Page 9: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/9.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
and Excel assigns the new tab name.
![Page 10: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/10.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
Repeat the process for any other tabs you want to rename.
![Page 11: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/11.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
Besides that, you can color-code worksheet tabs to make it easier to remember what’s in each
worksheet. This is especially useful when you have multiple workbooks that have the same
types of worksheets.
![Page 12: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/12.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
For example, you could have one color for “Class Role” information... another color for “Daily Grades”... and another for “Test Scores.”
![Page 13: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/13.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
To change the color of a tab, just place your cursor on that tab...
![Page 14: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/14.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
click the right button on your mouse... or click the right button on your laptop...
![Page 15: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/15.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
On the box of choices that opens up, click “Tab Color.”
![Page 16: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/16.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
That brings up the “Format Tab Color” dialog box. All you have to do is click on the color you
want...
![Page 17: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/17.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
And Excel applies the color to the tab.
![Page 18: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/18.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
To change a color, repeat the process... or... to remove a color...
click on the “No Color” option.
![Page 19: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/19.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
Have fun dressing your tabs!
![Page 20: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/20.jpg)
Excel 2010 : Adding Color Tabs to Worksheets
That’s all there is to it. Now, if you would like a copy of the step-by-step directions for renaming and adding color to
the tabs in Excel 2010 worksheets, just print this last page. Have fun naming and coloring!
Step-by-Step:
To rename your tabs:- Point to the tab- Left double-click- Type the new tab name- Press “Enter”- Repeat for other tabs
To color-code tabs:- Point to the tab- Right click- Click on “Tab Color”- Click on a color- Click “OK”
![Page 21: A few tricks to take you beyond the basics of Microsoft Office 2010](https://reader035.vdocuments.us/reader035/viewer/2022070503/5681623f550346895dd27569/html5/thumbnails/21.jpg)
GCPS Tech Tips
We hope you found this technology tip useful. Feel free to share this tip with colleagues and students.
More technology tips can be found on the IMD website here.
For questions or comments about the technology tips, send email [email protected]
Gwinnett County Public Schools | 437 Old Peachtree Road NW | Suwanee | GA | 30024-2978 | 678-301-6000