Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Now that we have some data in our table, let's go ahead and begin applying some formatting to make our table look like the rest of our book. And let's begin with this first column here. When we look at the first column, the text in many of these cells is not quite wrapping right. We've got a couple of these rows where we've got three lines of text, and it would look a little bit better if we could get these to wrap a littler neater. So to do this, simply click once on the table to select it and then click once inside of the first cell to select that.
Then if you move your mouse from inside the cell over to the right-hand edge, you'll see that you get the double-headed arrow. You can then click and drag a little bit to the right until you get the text to align properly within that cell. By doing this, it makes this entire first column a little bit wider and takes some space out of the next column of text. The next thing we need to do is now clean up how much space each row is taking up in our table. And we do that by simply clicking in the first cell and dragging down, and that should select all of those rows.
We can then go over to our Table Format bar, and you want to make sure that you have Automatically resize to fit content checked. And then in the Row Height, simply click the down arrow one time, and it should auto-adjust the size of all of your different rows so that they're all an equal height. We can then deselect by clicking anywhere not inside the table, and we can drag our table back down until it's better centered on our page again. The next bit of formatting that we want to do is to go ahead and treat all of these values over here on the right-hand side of the table.
All of these values should really display currency. So to do this, make sure you've selected your table by clicking on it one time and then click one time in the cell that says 750. Hold down the Shift key on your keyboard and come down to the lower right-hand cell and click one time. By holding down the Shift key, it will increase your selection in both the horizontal and vertical direction so that now all of the cells that we want to format are selected. Go over to your Table Inspector and click on the Format tab, then in the Cell Format click the dropdown menu, and change from Automatic to Currency.
You'll notice now that all of the values are now listed in dollars with the correct amount of decimal places. If you want to change the number of decimal places, you can do that by using the up or down arrow for Decimals inside of the Cell Format area. I'm going to go ahead and leave mine set to just 2 decimal places. Now to clean up the alignment with our selections still made, let's go over to the Text Inspector and then right-hand align all of our values. This way all of the decimal places now line up and all of our text shows up towards the right-hand side of our page.
While we have our Text Inspector, let's go ahead and adjust some of the other text cells. Let's come down here to the bottom cell in the Difficulty's column and click and drag up into the right in order to select all of the cells in the Difficulty column and Days column. Then we'll go ahead and click the Center button in the Text Align so that all of the texts in those cells become center-aligned. We'll do the same thing for our top row. We'll click and drag to the right, and that will select all the cells, and then we'll center the text. That's starting to look a lot better.
The next bit of formatting that we want to do is we want to come over here and apply some formatting to the column that has the days of the tour listed in it. So we'll click one time on the first cell to select it, and then we'll come down to the bottom cell, click and drag up, that way we get the entire column selected. We'll then go back over to our Table Inspector, and in the Format option under Cell Format, we're going to go ahead and choose Duration from the dropdown menu. Now when this happens, we need to set the correct number of Duration Units.
And the first thing you want to do is grab the Units slider and drag it a little bit to the left so that the slider is showing over top of Days, Hours, and Minutes. Now our tours are not going to be that detailed, so we'll go ahead and grab the right-hand side of the slider and drag it over towards the left in order to make sure that only days are selected. We'll then select under Format the option that has days in it. Now our column is formatted correctly. The only problem is that in the current version of iBooks Author when you adjust this slider, any number values that you had inside of your cells will start off being numbered as hours rather than days. This is not a problem.
We can now just simply come into the first cell and type in the correct number of days. That would be 3, and then I'll hit the down arrow on my keyboard, and you'll see that it's now converted to 3 days. Then go ahead and type in a 1, hit the down arrow again on your keyboard, a 3, a 2, and a 4, hitting the down arrow in between each time. When you get to the bottom cell, simply hit the Tab key to jump over to another cell. Now that our days are formatted correctly, let's go ahead and adjust the formatting of some of the lines of our table itself.
To do that, click one time on the table to select it and then go over to the Table tab of the Table Inspector. And down here in this middle section called Cell Borders, we have the ability to go ahead and change the way that the cell borders appear. The first grouping allows us to select only the left-hand edge of whatever the selection that we have is. The next option allows us to select all of the center columns that are not around an edge. The right-hand option allows us to select only the right-hand edge of whatever our selection is.
The next grouping allows us to select the top edge, any of the middle horizontal lines, or only the bottom edge. The next option allows us to select all of the interior lines, and finally we can select the outer line. That allows us to make the selection and then apply whatever formatting that we want to use down in the bottom. So with the outside borders tool selected, let's go ahead and increase the thickness of the line from 0.5 to 2 points.
That will create a much thicker line around the outside edge of our table to add a little bit more definition to the table itself. To deselect, simply click off the table, and you can see the result. Click one time on the table, click one time on the first cell, then hold down the Shift key and click on the right- hand most cell on the top column to select the entire top row. This time we only want to apply some formatting to the bottom line of this set of cells. So to do that, we'll click the bottom line option, and then we'll increase the thickness of that line to 3 points.
If you wanted to, you could also change that line to be dashed or dotted. I like the way that it looks with the solid lines, so I'll go ahead and leave it set on that and deselect. That's looking a little bit better. The next thing that we want to apply some formatting to is this left-hand column that has all of the names of all of our tours. It would be nice if this column of text stood out a little bit more from the rest of the table. So to do that, we'll click one time on the table to select it, one time on the first cell, and then hold down the Shift key and click one time on the bottom cell.
This selects all of that text. Then in the cell background, we could set the dropdown menu, and we could choose to have a different type of fill such as a Gradient Fill on those cells. I like having a color fill, and then click the color chip in order to open up my color chooser. I'll then go ahead and select the same yellow color that we've been using earlier, and I'm going to go ahead and adjust the opacity of that color down to about 50%. That will allow the text to be highlighted a little bit, but it won't be overpowering.
We'll go ahead and close the color chooser, and that's looking a little bit better too. Finally, we can go ahead and adjust whether or not we want to have alternating rows show up in another column. By default, alternating rows already show up like this. We can uncheck the box and have all of our cells to be formatted without alternating rows. I like having the alternating rows having another color, it helps with readability a little bit for our table. All right. Things are looking much better. In the next movie, we'll go ahead and enter in a formula over here to do some calculations to calculate our complete tour totals.
Get unlimited access to all courses for just $25/month.Become a member
120 Video lessons · 57678 Viewers
119 Video lessons · 67222 Viewers
84 Video lessons · 16616 Viewers
125 Video lessons · 29509 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.