Customizing the schedule title

- [Voiceover] In this movie I'm gonna talk about how you can customize the title bar in your schedule to create any kind of effect that you like. We can introduce additional cells, we can add additional text, we can bold and highlight and format, you can even add images. So let me show you what the final result is going to look like. I've got a schedule here called door schedule with custom title, and you can see that I've created a cell for it here, I've included a bold title and left justified, and then I've added a collection of abbreviations here that are used throughout the schedule, and all of that is part of the title bar at the top.

So I'm going to go to this regular door schedule here, the starting view, and show you how that was created, and we're gonna keep this 3D view open in the background just for reference to our doors here. So here is my schedule, and I go ahead and enlarge that a little bit, and let's get started. Now the first thing is, when you create a new schedule, by default it just puts these little carats around the name and uses that as the title of the schedule, but you can click anywhere in that title field and click Clear Cell.

Now that's important, because if you just click in there and start typing, it'll actually rename the schedule, so you need to do Clear Cell in order to disassociate the cell with the name of the schedule, so that's an important first step. The next step that I want to do is click this Merge/Unmerge button. When I do that it will actually separate that title cell into a separate cell for each of the columns in the schedule and so you can see they sort of have several columns across here. They don't really match the widths of the columns and that's 'cause prior to starting out here, I selected each of the columns and used this Resize button here to put in a certain size.

So if you look carefully at my columns you'll notice that they are different sizes. Now you can do the same thing with the cells here, so for example, if I wanted this cell to match the width of column P, I can click on column P first and click Resize to see how big it is, cancel out of there, then I can click in this cell, click resize again, and now I can make that size match, and now this cell up above matches the width of column P, and I could repeat that for each of them. But before I do that I want to actually subdivide my title bar here a little bit further.

So I'm gonna click anywhere in the first cell here, and under the rows panel I'm gonna click Insert, and I'll do Above Selected, and that's gonna create a whole new row all the way across. Now this is gonna be my title row, and I'm gonna click and drag through all of the cells in that title row and then I'll click the Merge/Unmerge button to create a single cell. Then I'm gonna click the Resize button here and set the height of that cell to a quarter of an inch.

Once I've done that I can click in there, type in the name I want my door schedule to have, and then go to the Font button and I could make it bold or italic or underline, or I could even change the font. So I'll choose Arial Black to make that nice and bold, and then finally left justify that like so. So that gives me the main title. Next I want to start configuring the widths of all of these cells down below before I start inputting the abbreviations I want.

Now, I want it to fit between columns A and O, so I'm gonna click and drag from A to O, click on my Resize, and that's gonna tell me that I currently have nine and a quarter inches in width there. So I need to divide my width accordingly into a total of that nine and a quarter inches. Now, ultimately I want eight columns there, and if we take a look back at my finished version, you can see that I had an abbreviation and then a definition, and I have that times four.

So one, two, three, four, five, six, seven, eight, so it's eight total columns that I'm looking for. So what I'm gonna do is just simply take a couple of these and merge them. Then I'll skip one and then take a couple more and merge them, and then a couple more and merge them, and then finally a couple more over here, so that's one, two, three, four, five, six, seven, and then this will be the eighth one. So there's my rough columns, a small column, then a big one, then a small, then a big, and then I'll just click in the first one, resize it, and I want that to be three quarters of an inch, and then I'll resize this one, and that's one and a half, and then this one, and as long as I start on one side and work my way to the next, it should work out just fine, and you'll see that my last column is a little bit wider, one and three quarters, but I can live with that.

Or if you prefer, you can do the math to make them all exactly equal, but that's a pretty good starting point for me right there. Now I'm going to click back in the first cell again, and back up here to rows, I'm gonna choose Insert Row Below Selected, and that's gonna create another new row. Now, it will match the widths that I indicated, but notice it did not match the merge. So not a big deal, I can just select those three, these three, these, and finally these.

I'll click in the middle cell here, resize, I want that a quarter inch tall, and then do it again here, resize, and a quarter inch tall. Now I'm ready to start inputting my abbreviations, and I'll just start typing them in. So when I'm done you'll see that the font is a little bit large and all the text is centered, so easy enough to fix that, I'll just click and drag through all of these cells.

I'll click over here on font, I'll change the font size to three 32nds, click OK, and then I'll use the horizontal alignment and make all of those left aligned. Now I want to take these two cells at the end that I'm not using and merge those together, and then I'm gonna take all of these cells, and I want to get rid of the center border lines. So you can click the Borders button right here and you can do a variety of things here. You can start customizing the line work to make them bold or medium lines or whatever, I'm just simply gonna click these two buttons right here to eliminate the inner border lines, and click OK.

And that gives me my completed schedule, complete with abbreviations across the top. So there's a lot more that you could do here. You've got shading, you could even insert image files. So I'll encourage you to experiment further, but as you can see, we can completely customize what we put in those title cells, and it allows us to add all kinds of useful information to the title bars within our schedules.