[Libs-Or] Tech-Talk: EXCEL - Quick Trick to Highlight Just Your Data

Fri Feb 19 09:00:28 PST 2021

Welcome to the latest issue of Tech-Talk!

Having trouble reading this email?
You can view the tech tip<https://www.tech-talk.com/quick-trick-to-highlight-all-data.html>, the communication tip<https://www.tech-talk.com/getting-to-the-really-important-stuff.html>, and the leadership tip<https://www.tech-talk.com/what-you-can-do-now.html> online instead!
When prompted for a username and password, use ORLIBTECH for BOTH.

Choose only the info in your spreadsheet

[https://files.constantcontact.com/ee1208b4001/470df2da-b8fb-4b32-95fb-8f6331e9910d.png]

This Week's Topic: EXCEL

1. ARTICLE & VIDEO ... Quick Trick to Highlight Just Your Data
2. COMMUNICATING ... Get to the important stuff
3. LEADERSHIP ... What you can do now

4. WEBINARS ...
·     Feb 17: Instantly Customize Emails, Documents, Labels … with Mail Merge
·     Mar 3: Preventing Citation Errors and Protecting Academic Integrity Using Bibliographic Tools
·     Mar 17: Five (5) New and Cool Tricks in PowerPoint
·     Mar 31: 12 Powerful Phrases to Use in Critically Important Work Situations

Register for Webinars<http://r20.rs6.net/tn.jsp?f=001PpZLbr8Um1uTP8f2gLIEE2xqDyle8ETZSLoL24xKcBzz-f9NX2RAPiIP4d9TAXIsV2rSLQcWE6RZN5N4fJX3QIVZkRocGuVtonRhfztUqxBItgNuoyuXKbUehIzBR6-vBNBOIr-7nReln6G3GNYlaMeHo35hmFoa&c=xK4wRykWZMrJWSb9pVHG7fUCWmND-3EMsUB8VwaOgx2WgOpZQx-ESQ==&ch=H9eymseSuewMj0aDx-9FmyIfyZXqrzdJsaAdZ_sWmjEsROJvfehwng==>

[highlight]<http://r20.rs6.net/tn.jsp?f=001PpZLbr8Um1uTP8f2gLIEE2xqDyle8ETZSLoL24xKcBzz-f9NX2RAPprR8Vdp0encFoQ1EvnUy8mrdl0mLQ8dlKTsj21vF-2bkv8Dl78oR8fPRAYL-H3QgJOttAMu8UELXvsacuUlEoFUPjHvH5T9wPmZVv2qKMkg8q4-Vmus9p0hwnnczXqnD7Fcx8hyPEKcUBsYiyGKd1w=&c=xK4wRykWZMrJWSb9pVHG7fUCWmND-3EMsUB8VwaOgx2WgOpZQx-ESQ==&ch=H9eymseSuewMj0aDx-9FmyIfyZXqrzdJsaAdZ_sWmjEsROJvfehwng==>

Photo by Bob Canning<http://r20.rs6.net/tn.jsp?f=001PpZLbr8Um1uTP8f2gLIEE2xqDyle8ETZSLoL24xKcBzz-f9NX2RAPprR8Vdp0enc8i43Pu6wRr5epmNDv1sCT2k-CE13L6pf8yvJGdVo58wAUnUaiLmCjXAUhBdqnl9IOLXh7s41eyghyh3pxVo-6e6Ntly5tTskurS1FHEXWKt_6-3Pcu1VPIJ8jWIjkiJba32gQxCW2TW1q3xBJVCTCi-JA0uVtpreCgwZ1l7GkpGykJYEa1ofwjAWg4E37mrn0WchWs67_LA=&c=xK4wRykWZMrJWSb9pVHG7fUCWmND-3EMsUB8VwaOgx2WgOpZQx-ESQ==&ch=H9eymseSuewMj0aDx-9FmyIfyZXqrzdJsaAdZ_sWmjEsROJvfehwng==> on Unsplash<http://r20.rs6.net/tn.jsp?f=001PpZLbr8Um1uTP8f2gLIEE2xqDyle8ETZSLoL24xKcBzz-f9NX2RAPj7aYVbkDtYUs5YAs_SmE28O4tNUCaQd_T-T2SCY2TKmaHIyF4N6z2mNx2wkIvgU5xzzIA4fmj-Er_VcWokZ8-GbWVAGP2v83ojxbkRVy_IIpHlzPYXWioZaxn7sCXKcM-1VT8MGk6GSIAS5GP6WYnzIAWZM-CJYl5-tY2SfBKMasgRX4NqUzL0R-VSVOLOS5WcG75FSPgKzD7OnwTmqvyBgmo3UqyMO-Q==&c=xK4wRykWZMrJWSb9pVHG7fUCWmND-3EMsUB8VwaOgx2WgOpZQx-ESQ==&ch=H9eymseSuewMj0aDx-9FmyIfyZXqrzdJsaAdZ_sWmjEsROJvfehwng==>

Brought To You By State Library of Oregon

[State of Oregon]
Visit Tech-Talk.com Database<http://r20.rs6.net/tn.jsp?f=001PpZLbr8Um1uTP8f2gLIEE2xqDyle8ETZSLoL24xKcBzz-f9NX2RAPunFpUi_4KlNZ2Fc_VNR8dqWLjaV2M93vgXDV9sPOrn2MxzNlr24AqmJjQ1roxWJ6SEml_r2jf-w_eBKrmLlfBHQXid8ETL0YtTmcgquiO8m&c=xK4wRykWZMrJWSb9pVHG7fUCWmND-3EMsUB8VwaOgx2WgOpZQx-ESQ==&ch=H9eymseSuewMj0aDx-9FmyIfyZXqrzdJsaAdZ_sWmjEsROJvfehwng==>

Username: ORLIBTECH
Password: ORLIBTECH

Questions about Tech-Talk?
darci.hanning at state.or.us<mailto:darci.hanning at state.or.us>

EXCEL - Quick Trick to Highlight Just Your Data
Novice

[large spreadsheet]

Do you work in large spreadsheets where the end of the data in the rows and or columns is out of view? You have to scroll down or over to see all of it. This makes editing a bit tricky.

For instance, if you highlight the whole spreadsheet to add borders to the cells, it not only adds the outline to the cells with data, but the WHOLE spreadsheet (which can have thousands of rows and columns)!

If you've ever made a mad dash to the printer to halt a print job that is spitting out extra pages with no data (only cells with a border), you know what I mean!

Here are a few more examples of when you might want to grab just the cells with your info in them: 1. You may want to convert your info in the spreadsheet into a Table Format which makes everything appealing and easily sortable. 2. You might want to add borders or formatting. 3. You may want to print the selected area.

We've got a quick shortcut that allows you to highlight ONLY the rows and columns in your spreadsheet that have data -- instead of the whole thing.

Now you'll no longer have to scroll all the way down, then across to find the end of the data.

Highlight Just the Cells with Data

[first cell]

To quickly capture only the cells with content in your spreadsheet:

·     Put the cursor in the first cell you want to include - like A1.

·     Next, hold the Shift and Ctrl keys down and press the DOWN ARROW key to capture from the top to the bottom row.

[Shift and Ctrl]

·     And then hold the Shift and Ctrl keys down and press the RIGHT ARROW key to capture from the left to the right.

[Shift Ctrl and down arrow]

TIP: This shortcut takes you to the first EMPTY cell, which is most likely the end of your data. But if you have some empty rows or columns in the content you're trying to capture, you may have to hit the arrow key another time to get to the end of your data.

With this shortcut, you should have highlighted just the data in the spreadsheet. This way you don't capture the entire spreadsheet with zillions of empty rows and columns as you would if you used the Ctrl +A to highlight.

Shortcut Using Google Sheets

Good news! Google has taken a cue from Microsoft so this shortcut works exactly the same in highlighting all of your data in a Google Sheet.

[https://files.constantcontact.com/ee1208b4001/41d9a61c-7e5a-4de3-b0a4-4021dd05cea3.png]

Communications: Talking
Getting to the really important stuff

If you've ever asked someone to rate an idea or project on a scale of 1 to 10, you know that you get a more accurate assessment of how they really feel.

But wait, there's more!

To get to the really good stuff, be sure to ask a follow-up question ... no matter what number they choose. Yes, even if they say a "9," you want to then ask:

"What is one thing that would get you closer to a 10?"

Yes, don't sit on your laurels if they had chosen a high number. Ask how to make it even better, because that is where the gold is. That's when you'll get a specific understanding of why they chose that number. Then you can walk away pleased ... or have a more in-depth discussion because you have new insight.

TIP: What if they say a "10"? Ask, what is one thing that would get it to an "11." Or, you can flip it, and ask, "What is one thing that would have kept it from being a "10"?

[https://files.constantcontact.com/ee1208b4001/da1c6ee9-ba35-4af5-9c80-8e1b5781189e.png]

Leadership
What You Can Do Now

If you're a manager, when was the last time that you spent 10 – 30 minutes to sit down with each individual on your team to go over the tasks and projects you’ve asked to be done?

If you're an individual contributor, when was the last time you requested a half-hour session with your manager to review and clarify what you've been asked to do? You don't have to wait for them to suggest these actions. You can take the lead. They will respect your initiative.

Make sure that in these sessions that you have there is a two-way discussion touching base with each of the five commitment conversations we've presented in recent articles.

Ask yourself…
1. How often do we take time to really discuss tasks so that we have a better chance of success?

2. How well do we pay attention to our team member's ideas, giving them careful consideration so that opportunities don’t fall through the cracks?

3. How well do we stay in touch and follow up with what we've been tasked to do so that these projects can continue the momentum?

[http://files.constantcontact.com/ee1208b4001/b13a7a6a-7445-4d8e-b741-4b475385ef5b.png]<http://r20.rs6.net/tn.jsp?f=001PpZLbr8Um1uTP8f2gLIEE2xqDyle8ETZSLoL24xKcBzz-f9NX2RAPmBkLOVlzRLHiweI7yKrnln2aFpmuHCljhuU-wlOyFruttRs9o7aj0qhboFO_RSkMHlGjeoTCcRG6kwjPwcmAUQybyBmR-VYlNIuMP1wFmQP&c=xK4wRykWZMrJWSb9pVHG7fUCWmND-3EMsUB8VwaOgx2WgOpZQx-ESQ==&ch=H9eymseSuewMj0aDx-9FmyIfyZXqrzdJsaAdZ_sWmjEsROJvfehwng==>
[Ask a question]<http://r20.rs6.net/tn.jsp?f=001PpZLbr8Um1uTP8f2gLIEE2xqDyle8ETZSLoL24xKcBzz-f9NX2RAPvgNsayiaZ2gNCUojRU5iHLG3bHEwicZujs6etZsm48gBF3mfbdJIb-eLbMMS2M7dKkSe_dgHUWmxrRv1HTDPjTYFObaVOyplDII3GcX25N4ZxIbXNRKdAQ=&c=xK4wRykWZMrJWSb9pVHG7fUCWmND-3EMsUB8VwaOgx2WgOpZQx-ESQ==&ch=H9eymseSuewMj0aDx-9FmyIfyZXqrzdJsaAdZ_sWmjEsROJvfehwng==>

Copyright 1996-2021 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> 941-355-2092.

The Tech-Talk e-newsletter for Oregon library staff is distributed weekly via the Libs-OR and TechTalk mailing lists. Know someone who might be interested in receiving a copy but they’re not on TechTalk or Libs-OR mailing lists? Have them contact darci.hanning at state.or.us<mailto:darci.hanning at state.or.us> or visit http://listsmart.osl.state.or.us/mailman/listinfo/techtalk to subscribe to just the Tech-Talk newsletter!

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.
Cheers,
Darci Hanning, MLIS (she/her/hers)
Public Library Consultant / CE Coordinator
Continuing Education Resources: https://libguides.osl.state.or.us/conted
NEW: darci.hanning at slo.oregon.gov<mailto:darci.hanning at slo.oregon.gov> | 971-375-3491 | www.oregon.gov/library<https://www.oregon.gov/library>
Follow us: Facebook<http://fb.me/StateLibraryOR> | Twitter<https://twitter.com/StateLibraryOR> | Instagram<https://www.instagram.com/statelibraryor/> |  Pinterest<https://pinterest.com/statelibraryor/> | YouTube<https://www.youtube.com/channel/UC0-kU8Gu0jS_YcnXg-b_TRA/playlists>

[cid:image001.png at 01D7069C.F4D1E460]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/libs-or/attachments/20210219/76540c0d/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/20210219/76540c0d/attachment.png>