How To Format Sheets for Notes

About this Tutorial

Create sortable notes in Three ways.
1. By adding the original word over and over again
2. Adding notes all in one cell with CMD + ENTER for new lines
3. Use Apps Script to sort the A column even with groups of rows.

Sheet Resources

Access Sheet

Copy Sheet

Preview Sheet

Video Transcript

<div>0:00 So you may be wanting to format your sheets like this. In a particular case we have diseases on the left and then some notes on the B column. 0:10 So what happens is you can sort this if and only if you put the same word in all of these A columns. 0:20 So, if we did this, we could solve this.

Select these, this range , and we could go up to data and we could sort range in column A, A to Z , there. 0:33 But if we don't have these particular things filled out, if we just want one word here, then now we have these sort of blocks that, to humans and to us, it's very readable. 0:45 We can see flu and then see these are blank and we can even see go to view, show, no grid lines, and it really helps, actually, that there's not all of these words here. 0:58 Uhm, another way to format without having to do anything else is to just put these inside of one cell, and this is actually what I prefer. 1:09 I do this with command enter, just a new line and then I can add some more.

Some more notes here, right? 1:16 And this disease over here, yes, now is, uh, is, uh, alphabetical-izable. You can sort it. That's, however, only if you want to avoid having to do some Apps Script , but I actually already wrote the Apps Script , go up to extensions, Apps Script . 1:36 Script, and we can go here, and we can see the Apps Script , and if you're watching this on bettersheets.co, down below, you can get this exact script. 1:46 If you're watching this somewhere else, there should be a link in the description to get this.

And what it is, is just sorting the groups. 1:55 These are groups, and it's saying, basically, go to the next, Let's delete that one. Let's go back. Go down here, see all of this. 2:02 This is all one group . Treat it as a group , and then sort it. Uh, and that's really all this is doing. 2:08 Uh, you can set a few variables here, like where you want to start the row. If you have more headers , you can have a start column where you want to actually alphabetize it by, and then how many columns you have, you can change that as well here in, um, lines 3, 4, and 5. 2:26 And there you go.

You can copy and paste this Apps Script , and I'll show you how it works is, we're on sheet 1. 2:33 It's actually the active sheet , and we can actually change this a little bit. If you want to change this, get active spreadsheet , get sheet by name, and just put sheet 1 there. 2:47 Now, every time I run this,</div>