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.
Better Numbering and Bullet Points
About this Tutorial
Video Transcript
Hello. Welcome. I'm gonna do two really quick tips for you right now. One of. Interesting little challenges or frictions is when we want to in a sheet number, things like, you usually have these row, right? But like sometimes you want to actually number them and you're probably wondering how I got this.here.
Well, if you go into a cell and you go one dot, it's gonna. Do that, and you sort of have to do this to get a one. Oh, and that's not really a numbering, right? Like you just want 1, 2, 3, 1 dot, two three dot. You can do this, right? And then, Sort to the left, right? But what if it's like, you want the standard just dot, so what you've gotta do is you've gotta do equals concat.
This is like a short version of concatenate. You can do concatenate if you want, but concat is just two arguments. And I used Roe here just to show you what it looks like for the entire, every ev, the entire sheet, everything. But you couldn't replace this with one here. You can go there. One's the same thing.
So then you have to write a line and you got a one dot, that's it. Just concat the one with the period. And I like to put a little space there next to it when you can say, first. Second, give it a little white space there. And the other thing is bulleting. So I, I've just recently started to use emojis as bullets.
And these things just make a sheet sing. They just make the sheet just g pop, draw your eye, everything. So you have like sparkles here can have like dos and do nots like hearts and heartbroken. Like if you do this, my heart's broken. Or you can be like, yes or no, can have thumbs up, thumbs down. These emojis are available@emojipedia.org.
One thing I will say is that when I had to copy and paste them, I did have to copy and paste values or if I, it ended up being a really like big image. Yeah, that's it. I hope you enjoy this. This will make like your to-do lists Look really cool. Yeah. And try also, I, I do want to just one, one more thing.
Okay. The third thing I'll show you share with you. Usually we have like headers, right? But if you put these headers on the left I did a video on a great sheet by Gonz over at Seed Table, and he did this and I was like, oh, this is so awesome. So I wanted to take a chance to try it, and it looks great.
It turns my Google sheet's awesome. Where typically I'll put this as a header, little, tiny, little header there, and. This like, oh, sparkle. Heart thumb, you can tell. Oh, but yeah, yays and nays or nose and don'ts and, and sparkles and whatever. Like, this looks really cool. It like, really makes it look fun. And the only thing I would recommend is giving it a little more white space.
So you, the way you do that. Oh my God, I can't do it. Okay, I'll do it down here. So I'm gonna take these rows. Okay. It's gonna take a little finesse here. There you go. I'm gonna vertically align in the middle, then I'm gonna increase their size a little bit. Okay. So that, Hmm. Have to move my head around over here.
There you go. So then I'm gonna increase the size and see now that to do those dos and don'ts, you can really see each one individually. It's really nice. Hopefully this was helpful for you to be able to do a one dot two dot thing here. To be able to do bullets here. And these headers sort of to the side, I don't know, side headers, siders, I don't know what you want to call 'em.
You can go to emoji pdf.org to find these different kind of emojis. And remember, you have to well, at least I had to copy them from the website and then paste values to make 'em smaller, or I had to like figure out the size of them. But hopefully that was good. Hopefully your sheets are now better.
Well, if you go into a cell and you go one dot, it's gonna. Do that, and you sort of have to do this to get a one. Oh, and that's not really a numbering, right? Like you just want 1, 2, 3, 1 dot, two three dot. You can do this, right? And then, Sort to the left, right? But what if it's like, you want the standard just dot, so what you've gotta do is you've gotta do equals concat.
This is like a short version of concatenate. You can do concatenate if you want, but concat is just two arguments. And I used Roe here just to show you what it looks like for the entire, every ev, the entire sheet, everything. But you couldn't replace this with one here. You can go there. One's the same thing.
So then you have to write a line and you got a one dot, that's it. Just concat the one with the period. And I like to put a little space there next to it when you can say, first. Second, give it a little white space there. And the other thing is bulleting. So I, I've just recently started to use emojis as bullets.
And these things just make a sheet sing. They just make the sheet just g pop, draw your eye, everything. So you have like sparkles here can have like dos and do nots like hearts and heartbroken. Like if you do this, my heart's broken. Or you can be like, yes or no, can have thumbs up, thumbs down. These emojis are available@emojipedia.org.
One thing I will say is that when I had to copy and paste them, I did have to copy and paste values or if I, it ended up being a really like big image. Yeah, that's it. I hope you enjoy this. This will make like your to-do lists Look really cool. Yeah. And try also, I, I do want to just one, one more thing.
Okay. The third thing I'll show you share with you. Usually we have like headers, right? But if you put these headers on the left I did a video on a great sheet by Gonz over at Seed Table, and he did this and I was like, oh, this is so awesome. So I wanted to take a chance to try it, and it looks great.
It turns my Google sheet's awesome. Where typically I'll put this as a header, little, tiny, little header there, and. This like, oh, sparkle. Heart thumb, you can tell. Oh, but yeah, yays and nays or nose and don'ts and, and sparkles and whatever. Like, this looks really cool. It like, really makes it look fun. And the only thing I would recommend is giving it a little more white space.
So you, the way you do that. Oh my God, I can't do it. Okay, I'll do it down here. So I'm gonna take these rows. Okay. It's gonna take a little finesse here. There you go. I'm gonna vertically align in the middle, then I'm gonna increase their size a little bit. Okay. So that, Hmm. Have to move my head around over here.
There you go. So then I'm gonna increase the size and see now that to do those dos and don'ts, you can really see each one individually. It's really nice. Hopefully this was helpful for you to be able to do a one dot two dot thing here. To be able to do bullets here. And these headers sort of to the side, I don't know, side headers, siders, I don't know what you want to call 'em.
You can go to emoji pdf.org to find these different kind of emojis. And remember, you have to well, at least I had to copy them from the website and then paste values to make 'em smaller, or I had to like figure out the size of them. But hopefully that was good. Hopefully your sheets are now better.
Topics