[Libs-Or] Tech-Talk: EXCEL/G-Sheets - Color Coded Spreadsheet Tab

Wed Nov 20 07:59:50 PST 2024

Welcome to the latest issue of Tech-Talk!

Having trouble reading this email?
You can view the tech tip<https://www.tech-talk.com/excel-color-coded-spreadsheet-tabs.html> and the communication tip<https://www.tech-talk.com/i-disagree-with-the-idea.html> online instead at:
https://www.tech-talk.com/login/oregon

When prompted for a username and password, use ORLIBTECH for both.

Tech-Talk is a paid subscription service for staff of Oregon libraries and is supported in whole by the Institute of Museum and Library Services (IMLS) through the Library Services and Technology Act (LSTA), administered by the State Library of Oregon.
Make each tab a different color

[https://files.constantcontact.com/ee1208b4001/34916cb2-412f-43fa-8294-1f7ecb0e9a3d.png]

[<img alt="Lake reflecting a forest with trees glowing in golden sunlight. A button in the center reads, View the Tech Tip Video Here.]<https://opiayfbab.cc.rs6.net/tn.jsp?f=001tUzqUt-TDejlngJJkQeeKS9a05Kb4K3v5NrhT3nz5HuT4GiNGCV5SJRPtfbgudTL7mcn3UWo80_7yfitn8XUM3k5JUxq_TEtAksniVhZmi4C3jLDMAnpHhvqjoeiT4efzH8MhIK-Uv0znZO386fDFrLXWXv-HZD4cLKqwGi1bXdEbBX_lURxlJOxZ7GonIt08sLu2wGZk9Y=&c=Tif_AmoCDfG4Z7ftpZWcAUBn-LTxIeauQbF8vFrMuQtCe7HL6gGKIg==&ch=lHjm4rjc6nPkgK8trEumEdfMPCuF3RSg_fDpTbxCHvNS9p_C6zt2yQ==>

Photo by Urban Vintage<https://opiayfbab.cc.rs6.net/tn.jsp?f=001tUzqUt-TDejlngJJkQeeKS9a05Kb4K3v5NrhT3nz5HuT4GiNGCV5SJRPtfbgudTL5MN16VNoQB5xvqSF3CTrbcoeNia-uanTF_fU3tShI3ZRLplLAYxmYIa1U5rEQMSLoNdhyN2B3O60YxDgD0VTnuFvFykzvmeTWEIj58R2NA2d8t2tPsK3xTjAI2kC2A1_-Ws-ZcXP4jw8Kw6msGTlkxBes4HCOxgEz6ygvGmYLPPidm7ORca_3tptm0xYJ5f9zJZ7mshOrhHxJHPLRMYQ4Q==&c=Tif_AmoCDfG4Z7ftpZWcAUBn-LTxIeauQbF8vFrMuQtCe7HL6gGKIg==&ch=lHjm4rjc6nPkgK8trEumEdfMPCuF3RSg_fDpTbxCHvNS9p_C6zt2yQ==> on Unsplash<https://opiayfbab.cc.rs6.net/tn.jsp?f=001tUzqUt-TDejlngJJkQeeKS9a05Kb4K3v5NrhT3nz5HuT4GiNGCV5SJRPtfbgudTL7TewRDCdy6DEMY9tHcKYGTNXmjTG-gTK2Qn2RXYuUReUyCMksfOcbouF9smTNdyF-9_xiTnoJ_7FWFDsz4CncY1TOvMdV2WarVeH2fCvDNOLswBcZVdVWsV82EWO8Wkz2Y8_xEXU3CXpq49JcA4TUzjAFZ8aUDdb9zKFRZoDZytJD4DqVV-OjIZXoUqN8D71BGgINkV7JLIm0OaYQ9y28kdue0Y_-q4R0kHIK_GJ1ft4PsPZxgQKpiiZTmcBabJWUJlhqHpIV_KIS6yay9XF50GAdXNoYL4l&c=Tif_AmoCDfG4Z7ftpZWcAUBn-LTxIeauQbF8vFrMuQtCe7HL6gGKIg==&ch=lHjm4rjc6nPkgK8trEumEdfMPCuF3RSg_fDpTbxCHvNS9p_C6zt2yQ==>

[https://files.constantcontact.com/ee1208b4001/e25f6bcf-26a8-4e59-91f2-cc248962042d.png]<https://opiayfbab.cc.rs6.net/tn.jsp?f=001tUzqUt-TDejlngJJkQeeKS9a05Kb4K3v5NrhT3nz5HuT4GiNGCV5SOAJVZ2H8k6RJZqqlJD6a6vFfDlYkGet_IRCwU60QQxuCk5v3q19wTjAj_O6W1LGs_zBx1dM1yRRH1LHmnCUTCiFan8K59HCwE4awABUVNnJ&c=Tif_AmoCDfG4Z7ftpZWcAUBn-LTxIeauQbF8vFrMuQtCe7HL6gGKIg==&ch=lHjm4rjc6nPkgK8trEumEdfMPCuF3RSg_fDpTbxCHvNS9p_C6zt2yQ==>

Webinars for You

NOTE: All webinars begin at 3 pm ET / 2 pm CT / 1 pm MT / 12 Noon PT and are one hour long.

Nov 20: [VIDEO] How to Pick the Perfect Video Creation Resource for Any Situation. Why attend? If you want to "de-confuse" all your video options.

Dec 4: [GOOGLE] Navigating Google Drive - A "Getting Started" Webinar.

Why attend? You're new to Google or need better understanding.

Dec 18: [GRAPHICS] Finding No-Cost Copyright-Free Images, Videos and Music Why attend? Save money with these resources.

Jan 8: [MOBILE] WhatsApp: Stay Connected with This NO-Cost Mobile App. Why attend? Learn how this app can be a communications tool.

View Webinars and Register Here<https://opiayfbab.cc.rs6.net/tn.jsp?f=001tUzqUt-TDejlngJJkQeeKS9a05Kb4K3v5NrhT3nz5HuT4GiNGCV5SPhCzxUWHhhbCpOlzP62T6-tfftcQ3f8eorkO-y1UR7KK9xBTaiTCpLzcEQ6LgO1RDy8kVj3nvBI2O5O6i-QiEqWWseHUnTxFhLM1qJNs0GOJ2w2HiljSGc=&c=Tif_AmoCDfG4Z7ftpZWcAUBn-LTxIeauQbF8vFrMuQtCe7HL6gGKIg==&ch=lHjm4rjc6nPkgK8trEumEdfMPCuF3RSg_fDpTbxCHvNS9p_C6zt2yQ==>

EXCEL / Google Sheets - Color-Coded Spreadsheet Tabs

Intermediate

Do you ever work in an Excel or G-Sheets workbook with a lot of worksheets in it? This makes it hard to find the individual one you're looking for, right?

Well, there's a trick that can make it easier if you're a visual person. You can "color-code" the tabs so that you can look for a familiar shade rather than read through the text.

For example, let's say you have a workbook that contains several different types of sheets – one for each department. That's a lot of tabs!

[Spreadsheet tabs labeled: Sales (blue), Marketing (red), Finance (green), and HR (purple).]

You'd have a much easier time locating the specific spreadsheet you need if each type of sheet had a different color tab. For instance, you could make Sales blue, the Marketing department red, Finance green and HR purple. Or however you associate colors and terms.

Color Code Tabs in Excel (Desktop or WEB 365)

[Menu in spreadsheet software showing "Tab Color" option, with a color palette below. A red arrow points to light blue in the Theme Colors section.]

Color coding your tabs is really easy. In your Excel spreadsheet (in either the desktop or Web 365 platform) simply:

·     Right-click on the tab you want to color.

·     Choose Tab Color.

·     From the palette that is displayed, select the shade you'd like to apply.

A colored line will appear along the bottom edge of the tab. Once you move to another sheet in your book, the entire tab will be colored.

[Spreadsheet menu with color palette open. "Change color" option is selected, and a cursor hovers over the red color.]
Color Code Tabs in Google Sheets

It's the same process for color coding tabs in a Google Sheet.

·     In the tab at the bottom of the Sheet, right-click.

·     Choose Change color.

·     From the palette that opens, select the color that you'd like.

[https://files.constantcontact.com/ee1208b4001/e565d7d1-215e-487a-8e78-f332113e7825.jpg]

Communications: Talking

"I disagree with the idea of...."

You're in a team meeting or having a cup of coffee with a friend. You're conversing about all kinds of things including ideas and opinions.

There's a good chance that some of the topics brought up may be controversial or at least not something in which you all agree.

It's so easy to get embroiled in emotions and say things that people find hurtful.

To avoid that situation, keep this mantra in mind:

Disagree with the idea, not the person!

Make it a point, with the words you choose, to communicate that while you respect and like the person, it's the opinion or thought that you do not agree with.

TIP: Make people really get it that you're targeting the idea by saying, "I disagree with the idea [thought; opinion]."

Examples:
·     IDEA: "I think we should hold the company picnic on a weekday."
·     BAD REPLY: "You always look for a way to get out of work."
·     GOOD REPLY: "I disagree with that thought. I think we will get a better attendance if we hold it on a weekend."

[https://files.constantcontact.com/ee1208b4001/b13a7a6a-7445-4d8e-b741-4b475385ef5b.png]<https://opiayfbab.cc.rs6.net/tn.jsp?f=001tUzqUt-TDejlngJJkQeeKS9a05Kb4K3v5NrhT3nz5HuT4GiNGCV5SBCuiPfFlWsLCh4CxgyLO7IxsuefOffpy29Inhxejrd92Hy34q3u8RbMN_InlZ1EvL1kNOsob3fNs26VQhJZzkCiRCtmSrNYhYCQ3fv3ZIzSwBrMFXBp5MU=&c=Tif_AmoCDfG4Z7ftpZWcAUBn-LTxIeauQbF8vFrMuQtCe7HL6gGKIg==&ch=lHjm4rjc6nPkgK8trEumEdfMPCuF3RSg_fDpTbxCHvNS9p_C6zt2yQ==>

[Ask a question]<https://opiayfbab.cc.rs6.net/tn.jsp?f=001tUzqUt-TDejlngJJkQeeKS9a05Kb4K3v5NrhT3nz5HuT4GiNGCV5SNStjYXa0woTnkJS4dnHE5pGnWJ5QNxr9iQVVFUNSdl2P2vGxeIHQkO9imSzpGD07JEPgrZ2HIBmyj8hJ2D8uYaL7YliEG1cEE-f7LHsx6mwSeimw-e7VTY=&c=Tif_AmoCDfG4Z7ftpZWcAUBn-LTxIeauQbF8vFrMuQtCe7HL6gGKIg==&ch=lHjm4rjc6nPkgK8trEumEdfMPCuF3RSg_fDpTbxCHvNS9p_C6zt2yQ==>

Copyright 1996-2024 Shared Results International. Published weekly. Distribution is limited by license. For information on how to include additional recipients, contact support at tech-talk.com<mailto:support at tech-talk.com> 585-615-7795.

Cheers,
Darci Hanning, MLIS (she/her/hers)
Public Library Consultant / CE Coordinator
Continuing Education Resources: https://libguides.osl.state.or.us/conted
State Library of Oregon | Library Support and Development Services
971-375-3491 | darci.hanning at slo.oregon.gov<mailto:darci.hanning at slo.oregon.gov> | www.oregon.gov/library<http://www.oregon.gov/library>

[State Library of Oregon (Logo)]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/libs-or/attachments/20241120/9d3db0d2/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 15548 bytes
Desc: image001.png
URL: <https://omls.oregon.gov/pipermail/libs-or/attachments/20241120/9d3db0d2/attachment.png>