Hey there stranger!

Sign up to get access.

Better Numbers and Bullet Points in Your Spreadsheets

About this Tutorial

Improve Google Sheets Readability
Improve the readability of your spreadsheets and supercharge your productivity with our top tips for better numbering and bullet points in Google Sheets.

Create Visually Appealing Sheets
Discover how to create clear, concise, and visually appealing spreadsheets that engage your audience and get results! Make your lists spicy hot with numbering and bullet points. Learn how to execute this to make your sheets look better.

Understanding the Importance of Readability in Spreadsheets Readability is crucial when it comes to spreadsheets. It refers to how easy it is for your audience to read and understand the data you are presenting. If your spreadsheet is cluttered, confusing, and hard to read, your audience will quickly lose interest and may not be able to make informed decisions based on the data you are presenting.

The Benefits of Using Bullet Points and Numbering in Spreadsheets
Using bullet points and numbering in spreadsheets can help to improve readability by breaking down complex information into more manageable pieces. Here are some of the benefits of using these features:
  • Bullet points and numbering help to organize information in a logical and easy-to-follow way
  • They make it easier to scan and find important information quickly
  • They can help to emphasize key points and make them stand out from the rest of the data 
  • They make your spreadsheet look more visually appealing and professional

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.