a few tricks to take you beyond the basics of microsoft office 2010
Download
Skip this Video
Download Presentation
A few tricks to take you beyond the basics of Microsoft Office 2010

Loading in 2 Seconds...

play fullscreen
1 / 21

A few tricks to take you beyond the basics of Microsoft Office 2010 - PowerPoint PPT Presentation


  • 60 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'A few tricks to take you beyond the basics of Microsoft Office 2010' - luke


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
a few tricks to take you beyond the basics of microsoft office 2010

A few tricks to take you beyond the basics of Microsoft Office 2010

GCPS Tech Tips

Microsoft Excel 2010 :

Adding Color Tabs To Worksheets

slide2
Excel 2010 : Adding Color Tabs to Worksheets

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.

slide3
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.

slide4
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?

slide5
Excel 2010 : Adding Color Tabs to Worksheets

All you have to do is place your cursor on a tab you want to rename...

slide6
Excel 2010 : Adding Color Tabs to Worksheets

double-click the left button on your mouse...

slide7
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.

slide9
Excel 2010 : Adding Color Tabs to Worksheets

and Excel assigns the new tab name.

slide10
Excel 2010 : Adding Color Tabs to Worksheets

Repeat the process for

any other tabs you want to rename.

slide11
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.

slide12
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.”

slide13
Excel 2010 : Adding Color Tabs to Worksheets

To change the color of a tab,

just place your cursor on that tab...

slide14
Excel 2010 : Adding Color Tabs to Worksheets

click the right button on your mouse...

or click the right button on your laptop...

slide15
Excel 2010 : Adding Color Tabs to Worksheets

On the box of choices that opens up,

click “Tab Color.”

slide16
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...

slide17
Excel 2010 : Adding Color Tabs to Worksheets

And Excel applies the color to the tab.

slide18
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.

slide20
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 andadding color to the tabs in Excel 2010 worksheets, just print this last page. Have fun naming and coloring!

gcps tech tips
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 to

[email protected]

Gwinnett County Public Schools | 437 Old Peachtree Road NW | Suwanee | GA | 30024-2978 | 678-301-6000

ad