[Libs-Or] Tech-Talk: EXCEL / G-Sheets - Quick Column (or Row) AutoFit

Fri Apr 17 15:07:51 PDT 2020

Greetings and welcome to this week’s issue of Tech-Talk!
Having trouble reading this email?
You can view the tech tip<https://www.tech-talk.com/excel-quick-column-adjustments.html>, the communication tip<https://www.tech-talk.com/be-respectful-mute-yourself.html>, and the leadership tip<https://www.tech-talk.com/015-ask-what-is-one-thing.html> online instead!
When prompted for a username and password, use ORLIBTECH for BOTH

Use this quick shortcut to adjust columns or rows
[http://r20.rs6.net/on.jsp?ca=c8c3c5b3-d348-453c-888d-0d6adcb73714&a=1100778316270&c=4f52e898-6edc-11ea-9474-d4ae529a85ae&ch=4f548978-6edc-11ea-9474-d4ae529a85ae]

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

Announcements

Yes, during the nationwide shutdown Tech-Talk offers free learning to students, teachers and patrons during. Apply here <http://r20.rs6.net/tn.jsp?f=001Z5EnGdTtBlar-IgLr1lobta2MR86RF6gudY-Tnn_Ugn0M98mzAxeLL6ZETMFEWZkpMUl0KjSxBXJpjDqJXAWMwQXkKw1dIn08FXbv8BMfBVdKN3queboGH7Txym9KUQkYRl4UpDCUSQsqrTSvxhRA--KJVGSin3dD_pN4sngT9Y=&c=cBY3NagfbqXVHYWzIaQiKcB1LSu0ABD7cpawnpQ5-hMksawPktELyA==&ch=cczqeeer6EBTH96QyqWCDz5Fp5XdogBRioFHLrY4H1wU9sNm0HzONg==> for your library, academic institution or school.

[https://files.constantcontact.com/ee1208b4001/8e8a2e94-d3d0-492e-ada7-235b3db0e6a8.png]

NEW WEBINARS

·     Apr 15: Be a TECH HERO #1 (Office Tips)
·     Apr 29: Creating VIDEO on the Run
·     May 6: Organizing Your Files and Desktop
·     May 13: Tips to Participate In and Present a Zoom Meeting

Click Here to REGISTER <http://r20.rs6.net/tn.jsp?f=001Z5EnGdTtBlar-IgLr1lobta2MR86RF6gudY-Tnn_Ugn0M98mzAxeLEUhMJ28lHak5Ta0TZAxdm123tqBnEj6n7XWWCS5u6tAtCQtFjnZ8NOct1ldvEQt71laoLx_dYNjZ5nlw3YaY44ITlEyBjLDxQPNdVyDrLpK&c=cBY3NagfbqXVHYWzIaQiKcB1LSu0ABD7cpawnpQ5-hMksawPktELyA==&ch=cczqeeer6EBTH96QyqWCDz5Fp5XdogBRioFHLrY4H1wU9sNm0HzONg==> ... Watch A Variety of RECORDINGS<http://r20.rs6.net/tn.jsp?f=001Z5EnGdTtBlar-IgLr1lobta2MR86RF6gudY-Tnn_Ugn0M98mzAxeLEUhMJ28lHak5Ta0TZAxdm123tqBnEj6n7XWWCS5u6tAtCQtFjnZ8NOct1ldvEQt71laoLx_dYNjZ5nlw3YaY44ITlEyBjLDxQPNdVyDrLpK&c=cBY3NagfbqXVHYWzIaQiKcB1LSu0ABD7cpawnpQ5-hMksawPktELyA==&ch=cczqeeer6EBTH96QyqWCDz5Fp5XdogBRioFHLrY4H1wU9sNm0HzONg==>

 This Week's Topic: EXCEL / Google Sheets

1. ARTICLE & VIDEO ... Quick Column (or Row) AutoFit
2. COMMUNICATING ... Be respectful, mute yourself
3. LEADERSHIP ... Ask: What is "one thing"

[column adjustments]

Brought To You By

[State of Oregon]

Visit Tech-Talk.com Database<http://r20.rs6.net/tn.jsp?f=001Z5EnGdTtBlar-IgLr1lobta2MR86RF6gudY-Tnn_Ugn0M98mzAxeLK-UgtsZPeYLnosSsiBzJBB2NJVGd2FHAUWoNVeO1jpymot-9daohQW0OuBIoYzJZXa9SnLN1Z36RSLdPwtON5VIwNUpyyxjDiVjkoeH5xif&c=cBY3NagfbqXVHYWzIaQiKcB1LSu0ABD7cpawnpQ5-hMksawPktELyA==&ch=cczqeeer6EBTH96QyqWCDz5Fp5XdogBRioFHLrY4H1wU9sNm0HzONg==>

Username:
Password:

Questions about Tech-Talk?

EXCEL / Google Sheets - Quick Column (or Row) AutoFit
Intermediate

[https://files.constantcontact.com/ee1208b4001/15a8c81c-967b-493d-98a9-fd22b87788dc.png]

I downloaded a .csv file the other day ... and of course, all the columns were squished together. Most of the columns had content that spilled over the width of it, so it was not at all readable.

Before I learned the tips we're sharing today, I would manually drag each column wide enough to see all of the data clearly. Unfortunately, there are often a lot of columns!

Then I had one of those "duh" moments and realized that I could re-size (AutoFit) all columns (or rows) at once with a quick shortcut. AutoFit means that the width of the column will be adjusted to fit the contents of the cell "automatically." The same is true for row height.

How to AutoFit One or All Columns

If you want to quickly adjust one or every column in your spreadsheet, there are two ways to do this depending on how you like to you work. Some people tend to "remember" shortcuts easily, while others rely on prompts from the toolbar/ribbon. See which way works best for you.

[highlight all]

Shortcut to AutoFit Columns

·     Either click the Select All button (the triangle above row 1 and to the left of column A), or highlight the columns you want to AutoFit.
·     Hover your cursor between any of the columns (it doesn't matter which ones) and when you see the vertical line with a double-arrow going through it, double-click.
·     That activates the Autofit. All of the columns will expand to fit the longest entry.

[autofit]

Use the Command in the Ribbon to AutoFit Columns

·     Select the columns that you want to widen by highlighting them.
·     On the Home tab, in the Cells section, click on the Format icon and in the drop-down window select AutoFit Column Width.

That's it! All the columns you selected will now adjust to the widest entry.

[autofit column width]

How to AutoFit One or More Rows

The process is the same for adjusting the rows to be the right height for your content so that you won't have partial letters showing.

[AutoFit]

Shortcut to AutoFit Rows

·     Either click the Select All button (the triangle above row 1 and to the left of column A), or highlight the rows you want to AutoFit.
·     Hover your cursor between any of the rows (it doesn't matter which ones) and when you see the resize row cursor, double-click.

Use the Command in the Ribbon to AutoFit Rows

·     Select the rows that you want to heighten by highlighting them.
·     On the Home tab, in the Cells section, click on the Format icon and from the drop-down window, click on AutoFit Row Height.

In either case, your rows will now be adjusted to accommodate the tallest entry.

AutoFit in Google Sheets

The same shortcut concept works in columns and rows in Google Sheets.

·     Hover your cursor between any of the columns (or rows).
·     Your cursor will turn into a line with arrows on each side. Double-click and the column (or row) will adjust to fit the contents of the cell.
·     To change all at cells at once -- highlight all of the cells (or use Ctrl + A) and then click on any line in between columns or rows and it will adjust all at once.

[https://files.constantcontact.com/ee1208b4001/7821eae9-ddea-4356-8a51-71e24c9b9562.png]

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

Communications: Online Meetings
Be respectful, mute yourself

As more and more people start to join group meetings online (using such web tools as Zoom, Microsoft's Teams, GoToMeeting), there is a need to develop a few protocols for communicating.

Connecting digitally in this way opens up new problems and opportunities. A concern we hear is that the group sessions get noisy. One of the biggest distractions is background noise.

What you may not realize is that the sounds around you actually get amplified to the other people on the call. That means that the other people in your group hear it MORE than you do! So if the TV is on in another room (you can barely hear it) it will be heard by the others on the call, more loudly. If you have a friend, spouse or child come in the room and quietly ask a question, it will be shared on the call. If the dog is barking at your neighbor's, everyone will hear it.

There IS a solution. Mute yourself. Keep yourself on mute and just un-mute when you want to ask a questions or contribute to the conversation.

It's polite. It's considerate. It's effective!

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

Leadership
Ask: What is "one thing"

As we talk about valuing the talent and insight of everyone at work regardless of position, here's a question you can ask of your team.

"What is one thing we could do to _______?"

You fill in the blank. Have the words you choose be specific to the role you play in the organization.

For example…

·     What is one thing we could do to get greater attendance at this event?
·     What is one thing we could do to feel more connected to each other?
·     What is one thing we could do to make our social studies class more exciting?
·     What is one thing we could do to increase funding for this program?
·     What is one thing we could do to make our facilities more inviting?
·     What is one thing we could do to make the meals we serve be healthy and delicious?

Asking the question, not only gives you good ideas, it goes a long way to showing that you respect everyone's ideas. Watch out! You may be surprised where some of the best ideas come from. When shy or introverted people are asked, and listened to, they sometimes come up with some real innovative ideas.

Tapping into every individual's knowledge with their unique perspective not only builds engagement, but is critical for an organization to continue to serve it's mission.

[http://files.constantcontact.com/ee1208b4001/b13a7a6a-7445-4d8e-b741-4b475385ef5b.png]<http://r20.rs6.net/tn.jsp?f=001Z5EnGdTtBlar-IgLr1lobta2MR86RF6gudY-Tnn_Ugn0M98mzAxeLMRU9z58uJqGRmZlhS8_VYeVzsgAUXtgTuan3S65E23TNw-HDNHbKf9bBg72sirQxZr2MwoXDjsrBPvV1sROpi9UmEGJv-uVbbYCstDf5ZRr&c=cBY3NagfbqXVHYWzIaQiKcB1LSu0ABD7cpawnpQ5-hMksawPktELyA==&ch=cczqeeer6EBTH96QyqWCDz5Fp5XdogBRioFHLrY4H1wU9sNm0HzONg==>

[Ask a question]<http://r20.rs6.net/tn.jsp?f=001Z5EnGdTtBlar-IgLr1lobta2MR86RF6gudY-Tnn_Ugn0M98mzAxeLCEN43uOy5DVl4_K07KsBNzOpeO1Rq0Si1YQSS89EW2ezyYro_I7Aw5WzCrrp3qgdjfMGJ1C3cbo6yBERfbKPfScQDhHjDIVS0_K3Ji8K1mrsGqMetQoMtY=&c=cBY3NagfbqXVHYWzIaQiKcB1LSu0ABD7cpawnpQ5-hMksawPktELyA==&ch=cczqeeer6EBTH96QyqWCDz5Fp5XdogBRioFHLrY4H1wU9sNm0HzONg==>

Copyright 1996-2020 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
Public Library Consultant / CE Coordinator
https://libguides.osl.state.or.us/coronavirus

darci.hanning at state.or.us<mailto:darci.hanning at state.or.us> | 503-378-2527| www.oregon.gov/library<https://www.oregon.gov/library>
Follow us: Facebook<https://fb.me/StateLibraryOR> | Twitter<https://twitter.com/StateLibraryOR> | Instagram<https://www.instagram.com/statelibraryor/> | Pinterest<https://pinterest.com/statelibraryor/>

[cid:image005.png at 01D31C27.4B9FEA30]

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