1 / 10

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 : Using Color In Excel Worksheets. Excel 2010 : Using Color In Worksheets.

huyen
Download Presentation

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

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A few tricks to take you beyond the basics of Microsoft Office 2010 GCPS Tech Tips Microsoft Excel 2010 : Using Color In Excel Worksheets

  2. Excel 2010 : Using Color In 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 web site. 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.

  3. Excel 2010 : Using Color In Worksheets Why Add Color? These simple color tips for Excel can help you add a bit of color to your worksheet. You may want to apply color to attract attention to specific areas of a sheet and to identify purpose, category, and other important concepts. Used discretely and with specific intent, color can guide the audience through their work and help them work more efficiently. These three tips are easy ways to consider color when working with Excel sheets.

  4. Excel 2010 : Using Color In Worksheets Color Tabs Adding descriptive text to sheet tabs is usually enough, but sometimes a bit of color can help - especially if there is already a set of data conventions that use color. • To add color to a tab: • Right-click the tab and choose Tab Color • Select a color from the resulting palette • Move to another sheet and watch as Excel colors the tab

  5. Excel 2010 : Using Color In Worksheets Change Gridline Color Gridlines are the cell outlines that you see on screen. They don’t print (by default) and they’re not the same as borders. You can turn them off for individual sheets by clicking the Page Layouttab and unchecking the View box under the Gridlines group. Besides turning the display off and on, you can also change their color, as follows:

  6. Excel 2010 : Using Color In Worksheets • Change Gridline Color (cont.) • Click the File tab and choose Options in the left pane • In the left pane, select Advanced

  7. Excel 2010 : Using Color In Worksheets • Change Gridline Color (cont.) • In the Display Options For This Worksheet section, choose a color from the Gridline Color dropdown. (Automatic is the default setting.) • Click OK

  8. Excel 2010 : Using Color In Worksheets If you want to print gridlines, use the Page Layout tab. Check Print box under Gridlinesin the Sheet Optionssection.

  9. Excel 2010 : Using Color In Worksheets Printing In Black And White While we’re discussing colors and printing, you might want to know that you don’t have to print your sheets in color. In fact, unless you have a specific reason to do so, printing all those colors is expensive. To print a colorful sheet in black and white, do the following: • Open the Page Setup dialog box. • Click the Sheet tab and check Black and White box • Click the OK button

  10. 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 IMD_Connection_Newsletter@gwinnett.k12.ga.us Gwinnett County Public Schools | 437 Old Peachtree Road NW | Suwanee | GA | 30024-2978 | 678-301-6000

More Related