Hey there stranger!

Sign up to get access.

Anika Asks: How To Set Text Overflow All The Time

About this Tutorial

Learn to set text wrap, overflow, or clip. Great for designing better text in your sheets.

Video Transcript

 Hey, so Anika asks, who's a better sheets member? Thank you for asking Anika. She asks, how do I do text overflow all of the time? I have some. Data here. I, I just put some random letters and numbers here, but I want it to actually overflow all the time. Even if I were to add some formatting here and say copy and paste something here.

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

How Starter Story Designs Data

Learn to Love Your Sheets

Best Header Font Ever

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


10 Things I Hate About Your Spreadsheets

Dark Mode / Better Font Color


Better Font Colors


Magical Things You Can do with Checkboxes in Google Sheets


How To Export Your Beautiful Sheets to PDF


Consider Labels as Opposed to Headers


Add Icons To Your Sheets With a Domain Name


How To Color Cell Blocks So Others Enter Data Easily


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!


Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!