[techtalk] EXCEL/G-Sheets – Wrap Text in a Cell Automatically

Tue Jun 15 09:00:12 PDT 2021

Welcome to the latest issue of Tech-Talk!
Instantly make your text fit the column

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

This Week's Topic: EXCEL/G-Sheets

1. ARTICLE & VIDEO ... Wrap Text in a Cell Automatically
2. COMMUNICATING ... A magic phrase for gaining buy-in
3. LEADERSHIP ... Introducing Covey's Quadrant II

4. WEBINARS ...
·     June 23: [EXCEL] Simple Formulas to Make Spreadsheet Calculations Easier
·     July 7: [VIDEO] Breeze Through Video-Making in Canva
·     July 21: [EXCEL/G-SHEETS] Create Pivot Tables and Pivot Table Charts

Register for Webinars<https://r20.rs6.net/tn.jsp?f=001-29YFlBG26qYabq0PRQtb0pcfPCQItR96jYb3foQW2-8VFMegbJXOUArMQVmb6qdzvurYEoetxEeA8vsDlw0Nu3V5fNG2ClzusNMBZOGbD_wBkiiwPUhwrfBY_mWVZTmXDfgwdkjZw8OhTNcTizt-Xu-9oyq9JyG&c=BNtEZmVPnQeFnZeY2AybEyxNUoK1MT47i10YjM-diFJuUudb0BVRKQ==&ch=Mh37jhcs9jti2vHk3qBZUk7iVSsD1vN5E6EhsqqMYrsmfazHBLE10Q==>

[wrap text]<https://r20.rs6.net/tn.jsp?f=001-29YFlBG26qYabq0PRQtb0pcfPCQItR96jYb3foQW2-8VFMegbJXOT_110bk-jZYpu-myiXLFTGd-5IbO_rmwmG5qRl_bRtMzBlGlqQyU8xhvWg_JKbEdZWCK7RcXWItIjvHd8bg5hyHqh6yJtvpuq-e2wdBMvCg8xG2PgHQALWp9izBbaQSZ5WA7LYvcCqK-rBP2hGsGWU=&c=BNtEZmVPnQeFnZeY2AybEyxNUoK1MT47i10YjM-diFJuUudb0BVRKQ==&ch=Mh37jhcs9jti2vHk3qBZUk7iVSsD1vN5E6EhsqqMYrsmfazHBLE10Q==>

Photo by Rayia Soderberg<https://r20.rs6.net/tn.jsp?f=001-29YFlBG26qYabq0PRQtb0pcfPCQItR96jYb3foQW2-8VFMegbJXOT_110bk-jZYLP1kZqCuUARyHCInjIOmtpfRBBcU5VhSZWuRGPpxUvX4q9NWeTq_hNL0nK9BejPX2uzvep9jWfMoRQI3KCZKLEJh3IQvOgoAWpqvhZEbqWM5a0jtZHg5wHRwStDzngqjLG0iZ6rS4hWtxWRxFoAo3lmpEMl4odCzegRcxEJZOH9VrHrxr-gr9T1qLjZwUR5v&c=BNtEZmVPnQeFnZeY2AybEyxNUoK1MT47i10YjM-diFJuUudb0BVRKQ==&ch=Mh37jhcs9jti2vHk3qBZUk7iVSsD1vN5E6EhsqqMYrsmfazHBLE10Q==> on Unsplash<https://r20.rs6.net/tn.jsp?f=001-29YFlBG26qYabq0PRQtb0pcfPCQItR96jYb3foQW2-8VFMegbJXOT_110bk-jZYt8wG6enm0jBOWFmqSgD-V3RJn5HOdtfXyDWFD5zqbKpy-PD4RaGvlcNWqz6rJKjuw3SttrZNdEjEvi3SsVEuo7_RJNWiJpnn4Q4YH3vdxBGsNex05lpSXdnFPSJOS_p0yd8o6Cb7Jx62OL4ghBqyfIGeVcVrqNiz4ENIwbrY-Im_MqssU91OO63ylUd0yhBkg7cWewhUkls=&c=BNtEZmVPnQeFnZeY2AybEyxNUoK1MT47i10YjM-diFJuUudb0BVRKQ==&ch=Mh37jhcs9jti2vHk3qBZUk7iVSsD1vN5E6EhsqqMYrsmfazHBLE10Q==>

Brought To You By

[State of Oregon]
Visit Tech-Talk.com Website<https://r20.rs6.net/tn.jsp?f=001-29YFlBG26qYabq0PRQtb0pcfPCQItR96jYb3foQW2-8VFMegbJXOa26lVwUHm2NNhzhDlR_dOHTiyYYzPpM1tX0F60Jd-AO5ouSHXNQnaEWcipBFaZBoAU4F9kJil6_fHs6KhA-H0Yw9zI81FQlSWI1ruR0bf1V&c=BNtEZmVPnQeFnZeY2AybEyxNUoK1MT47i10YjM-diFJuUudb0BVRKQ==&ch=Mh37jhcs9jti2vHk3qBZUk7iVSsD1vN5E6EhsqqMYrsmfazHBLE10Q==>

Username:
Password:

Questions about Tech-Talk?

EXCEL/G-Sheets – Wrap Text in a Cell Automatically
Intermediate

Have you ever been working in a spreadsheet where the text you want to use was too wide for the cell ... but you didn't want to widen the column? What can you do? Wrap the text!

The Wrap Text feature instantly adjusts the text in the cell to roll over into a second line. Excel automatically modifies the height of the row as well. A perfect solution! Now you see several lines of text neatly packed into the width of the column.

[wrap text]

[Excel]

TIP: Sometimes, the text wraps to the width of the column, but the row height doesn't shift. Bummer. (See example on the right where the text is cut off!) Why didn't it automatically adjust? There are some situations where it doesn't.

Let's take a look at not only how to use the Wrap Text feature in Excel and Google Sheets -- but also the trick to letting Excel make the cell height adjustments for you.

Wrap Text in Excel

When you have a cell (or whole column) that has content in it that is too long for the width of it, instead of making the column wider, you can "wrap" the text so that it flows over into another line automatically, still in that same cell.

[Excel wrap]

[Excel wrap text]

·     Click in the cell, or the whole column.

·     On the Home tab, in the Alignment group, click Wrap Text.

·     The content in the cell will wrap automatically to fit the column width.

Now, Excel should also automatically adjust the row height to make all of the wrapped cell content visible. If it does not -- it's because you have manually adjusted the row height (or the column width) yourself at some point. That sort of disengages the auto Wrap Text.

NOTE: You can often toggle the auto text back on. Put your cursor in the cell you want to wrap, then click on Wrap Text. If nothing happens, click it again. And possibly a third time. This trick works quite often, but not always. You may have to adjust the height or width yourself.

[https://files.constantcontact.com/ee1208b4001/07337467-2905-426f-b1dd-faf2c22c0dfb.png]

To Adjust the Row Height Yourself

If you do need to adjust the row height manually so that all wrapped text is viewable:

Hover on the line at the bottom of the row that you want to adjust (between the row numbers) and when the cursor turns into a line with a double arrow crossing it, drag the line to the height that you want.

OR:

[adjust row height]

·     Click in the cell (or range of cells) for which you want to adjust the row height.

·     On the Home tab, in the Cells group, click Format.

·     Under Cell Size, either: 1) To automatically adjust the row height, click AutoFit Row Height, or 2) To specify a row height, click Row Height, and then type the row height that you want in the box.

Wrap Text in Google Sheets

In Google Sheets, if you want to use the Wrap Text feature:

·     Highlight the cell(s) with the text you want to wrap.

·     In the menu go to Format and choose Text Wrapping and then Wrap.

·     The Row height will adjust with the wrap. However, if you want to modify it, just put your cursor on the line below the row until it turns into a double arrow and then drag it to the desired height.

[Google Sheets]

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

Communicating: Writing
A magic phrase for gaining buy-in

How do you feel about the phrase, "fair and reasonable?"

They go together well, don't you think? They pack a powerful punch for gaining agreement on something specific such as a project deadline, a budget amount or an approach.

·     "Is the end of next week a fair and reasonable deadline?"
·     "Does $1,500 sound like a fair and reasonable budget?"
·     "Would talking to students first be a fair and reasonable approach?"

Here's a Twist

You can also gain insight to unspoken assumptions by asking this as an open-ended question of someone...

·     "What would be a fair and reasonable date to have this finished?"
·     "What would you consider as a fair and reasonable budget amount?"
·     "What do you think would be a fair and reasonable approach to this project?"

Typically, you'll find others tell you exactly what they are thinking when you use these two words so that you can come to an understanding quickly and agreeably.

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

Leadership
Introducing Covey's Quadrant II

"Discipline is choosing between what you want now and what you want most,” Abraham Lincoln.

I saw this quote and thought it might be a good way to introduce you to the idea that investing some time in Quad II activity is a desirable thing. It requires a little discipline (to not put it off, to deal with a grumbling team, to set aside dedicated time), but it pays off in big ways.

What is Quad II activity, you say? Simply put it's taking time to focus on, and execute, activities that will make a difference. They are Important, but not Urgent (e.g. training, implementing a new process, holding a communication meeting). They are the items you plan to do, hope to do, meant to do ... but don't get around to it.

Watch for more leadership articles on Stephen Covey's Quadrant. It's a powerful tool for managers and individuals to use ... at work and in life.

[https://files.constantcontact.com/ee1208b4001/f1792a63-bc10-4a0c-ade8-6d14af698aa7.png]

Quadrant Image from BishopHouse.com

[http://files.constantcontact.com/ee1208b4001/b13a7a6a-7445-4d8e-b741-4b475385ef5b.png]<https://r20.rs6.net/tn.jsp?f=001-29YFlBG26qYabq0PRQtb0pcfPCQItR96jYb3foQW2-8VFMegbJXOUlSEvc28KKLpPJ7q8hKorV-ETdN-53YfxgCKedaHe1mTpS0_OCdHS-oJzC3f4w6jb7xuLOZpOBJz4LfYXX_DDsCLJMGRmB0aRLa-cf30ri3&c=BNtEZmVPnQeFnZeY2AybEyxNUoK1MT47i10YjM-diFJuUudb0BVRKQ==&ch=Mh37jhcs9jti2vHk3qBZUk7iVSsD1vN5E6EhsqqMYrsmfazHBLE10Q==>
[Ask a question]<https://r20.rs6.net/tn.jsp?f=001-29YFlBG26qYabq0PRQtb0pcfPCQItR96jYb3foQW2-8VFMegbJXOfnFG2MdMQIatEr5wJyHhYrrKTjWbMri4fuX4B-oTw5-n7dax0lpHYoH3D61OBRrgLzz0LWc6Zri4V9-JJ2BA4NQBjD7JJRzj2l7CELljdogG0wh1_ebXwA=&c=BNtEZmVPnQeFnZeY2AybEyxNUoK1MT47i10YjM-diFJuUudb0BVRKQ==&ch=Mh37jhcs9jti2vHk3qBZUk7iVSsD1vN5E6EhsqqMYrsmfazHBLE10Q==>

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
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>
Follow @StateLibraryOR: 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/featured>
Continuing Education Resources: https://libguides.osl.state.or.us/conted

[cid:image001.png at 01D761C4.A1FF0CD0]<https://www.northwestdigitalheritage.org/>      [cid:image002.png at 01D761C4.A1FF0CD0]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/techtalk/attachments/20210615/ee3a93d8/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 6600 bytes
Desc: image001.png
URL: <https://omls.oregon.gov/pipermail/techtalk/attachments/20210615/ee3a93d8/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 15548 bytes
Desc: image002.png
URL: <https://omls.oregon.gov/pipermail/techtalk/attachments/20210615/ee3a93d8/attachment-0003.png>