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.