79% OFF online library of tutorials for mastering Google Sheets
This tutorial is not available for free users. Please purchase a subscription to view this tutorial.
Hey there stranger!
Please sign-up or sign-in to watch this tutorial.
Anika Asks: How To Set Text Overflow All The Time
About this Tutorial
How do I get that? Do you see that magic that overflow all of the time? Or in our case in Anika's case, she's doing an overflow, but there's also this setting text wrapping has overflow wrap and clip. So how do you set that to automatically change upon any edit? How do you keep it that way as we're adding more data, maybe even copying and pasting from another page and we want to keep it that way.
So I wrote a little script here for Anika and I wanted to share it with you and everybody else here at Better Sheets. So, , I'm using the function on edit. It's pretty simple actually. There's this sort of one line set wrap, by the way. We'll get there in a second. We get the active sheet. Now I did two things.
You might only need one of these two, but I did both of them because they're a little bit different. First if we want it to wrap. Let's say we wanted to sheet wrap all the time. We wanted the text to wrap all the time. In this sheet I just called it sheet wrap, you'll have a different name. I said if the active sheet dot get name is equal to those two equal signs sheet wrap, then we'll get the range, which is the A column in our case.
And this a column, we're just gonna do data range dot set wrap. True. And that's all we have to do for doing the wrap one. That's this text wrapping. wrap. It gets a little tiny bit more complicated if we want to do overflow. That's why I did this here and it did it separately. If the sheet name is sheet overflow, which is this one, and we want column A to overflow, we do the same thing we did up.
Above, which is data range, the A column, and we do set wrap strategy, and then we have to use spreadsheet, app dot wrap, strategy dot overflow, overflow in all caps. Now, if for instance, you want to do a clip, so out of the options up here in text wrapping, there is overflow wrap and clip. Which one do you do?
I'll, I'll tell you right now what you do. We're gonna create a. a new sheet. We're gonna duplicate it and we're gonna call it sheet clip. And we want all of these to clip. We don't want to show the overflows. How do we do that? Well, I'm just gonna copy this whole text, which you can do too. You'll can come into the sheet and just copy the text.
I'm gonna move my face over here and we go do get name sheet. Now we. Change our name to clip. Let me make sure I got the capitalization correct. Yeah. Sheet clip data range A to A as well. And this spread, this wrap strategy spreadsheet, app dot wrap strategy dot overflow. We're gonna just change that to all caps.
Clip command S, this orange button goes away and let's see if that works. So what we need to do is we need to actually edit. So. We can edit anywhere actually on the anywhere, but let's see. Edit that. And there they go. The entire A column is now clipped. Isn't that cool? So we are able to do both, all three of these.
Set wrap, true spread the wrap strategy overflow and wrap strategy clip. Cool. I hope this helps you and I hope this adds a little dimension of magic to your sheets. Right? We can do this on any column. , you couldn't change the column here. A to a, you can even change the range. Maybe you don't want an entire column, but only like a two to a 10.
You can do that by just typing that in there. All right, thanks for watching.
Better Than Happy | Redesign of The Feelings Wheel
Best Header Font Ever
Learn to Love Your Sheets
Sheet Review! 150 Active VCs by LemonIO
Anika Asks: How To Set Text Overflow All The Time
Introducing: Brutal Calendar
Add a Checkbox to Turn on Dark Mode
Create Drop Shadows! This makes your dashboards pretty.
Merge Cells for Dashboards
Dark Mode / Better Font Color
Better Font Colors
Magical Things You Can do with Checkboxes - Google Sheets
Export Your Beautiful Sheets to PDF
Consider Labels as Opposed to Headers
Add Icons To Your Sheets With a Domain Name
Coloring Cell Blocks for Others to Enter Data
Great Sheets! Corona Hiring Sheet
Great Sheets! Community Information Board by Seedtable.com
Roast: Hotel PPC Channel Cost Calculator
Better Header Fonts - Best Fonts To Use In Google Sheets
Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell
Basic Keyboard Shortcuts To Speed Up Your Productivity
Basics - 5 Ways to Change Row Height
Anders Asks: Can I Highlight Whole Row if Certain Columns have text?
How to Refer to Other Cells - A1 and R1C1 Explained
Change the Default Font
Biggest Flaw In Dashboards with Dark Colors
Basics - 4 Ways to Change Column Width
Basics - Structure of a Sheet: Index() Row() and Column()
Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets
Use Cmd + Y To Do It Again, and Again, and Again
Create an Auto-Update Sales Chart: Trailing 12 Months
Google Sheet Basics - The Absolute Basics
Secure Your Sheets by BetterSheets.co
How To Create An AutoFill in Google Sheets
Build a Thermometer for Savings Goals
Make Your Lists Spicy Hot in Google Sheets
Restrict Access to a Cell if Another Cell is Blank
How to Use Smarket
Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!