Join David Rivers for an in-depth discussion in this video Customizing table cells and borders, part of Numbers 3 Essential Training.
Once you’ve created a table here in numbers there are a number of things you can do to improve its appearance. In this movie we’ll focus on the lines we see going around the outside of the table. As well as the lines on the inside known as gridlines, and some of the cell shading that we see here with our default table. We’re going to begin by clicking anywhere in the table. Now if you’ve skipped to this movie and need to get caught up just open up KEcoBudget0303 and here on the profit loss summary sheet you’ll see this table. So it really doesn’t matter where you click.
As soon as you do you’re going to see the inspector open up over here on the right hand side, and let’s start with the table tab. Yes there are styles we can select for formatting, but we’ve already gone through that. We have the style we want now it’s time to get specific, and we’re going to start with the table outline. So moving down the inspector you’ll notice the default solid line that’s created going around the outside of our table. You can see the color that’s being used, and you can see the width of that line. But all of these can be adjusted as well.
So let’s start by going to the dropdown. If you don’t like a solid line you could go with dashes or dots even. Select one of those and you’ll see the effect is around the outside of the table only. Let’s go back to that and select solid line. Even with solid line we can change the color if we wanted to. Click the dropdown inside the color to see the swatches. Maybe a nice dark gold would be good, and then if we wanted to we can use the arrows over here to bump up or down the size that’s the width of our line.
I’m going to go up and try to get to 1.75. Well if I use the arrows I go from one to two to three etcetera. So if I want 1.75 I’ll just bump it down to one, click just after the one and add the .75 and press return on my keyboard, and that’s the end result very nice. Now if you click the dropdown for the color and you don’t see the color that you really want click the color wheel to open up the colors palette. Now we have a virtually unlimited number of options when selecting the color.
I’m going to use the slider here with the color wheel selected. I’m going to drag it down just to make it a little bit darker, and when I’m done I’ll close up the colors palette there we go. All right just below the table outline we see that the gridlines have a number of buttons. All of which are selected that means that we’re seeing all of the gridlines. We’re seeing the gridlines that go horizontally left to right. As well as those lines going up and down. Not just in the table itself, but also in that header row.
These first two buttons are for the gridlines going horizontally and vertically inside the table. The next three buttons are for header columns, header rows, and the footer. Now in this case our table only has a header row. So if we try to change the footer or the header column button by clicking it nothing happens. However, we can turn off the gridlines if we wanted to for the header row by clicking that button. Same thing for the gridlines on the inside both horizontal and vertical.
Now sometimes you need them if you want to be able to line up the contents and be able to read it clearly. In this case we also have something going on with our cell shading. You’ll notice that we have alternating row colors, and that’s because that’s turned on as well. If we turn that off now you can see as we start adding content it’s going to be difficult to line it up. Especially if this table grows any larger. So, we might want to have some of the gridlines on. I definitely think we need them up here in our row header so let’s select it.
Now those lines appear, and then down below. I’m thinking we could use them vertically inside the table, and turn the row color that’s alternating back on by clicking the checkbox. Now we can change the shade that’s being used by clicking the dropdown for the swatches. Maybe we could go with a nice light yellow. Well that’s the lightest yellow there is to choose from there it’s kind of dark, but we can go to that color wheel don’t forget. To access our colors palette with the wheel selected. If we wanted to we could move this little guy around till we get into a nice light yellow shading.
Right towards the center we’re almost at a white there. So we want a nice subtle shade that looks pretty good right there and close that up, and that’s the end result. So we’ll be able to follow things along left to right horizontally thanks to the alternating row color. Then vertically we have the gridlines we need to get things lined up properly. The other thing we can do is select cells. Not just the entire table, but select specific cells that we want effected. Like our header row for example. We could click and drag across those cells, or just click the two in the very far left and the entire row is selected.
That means we can go to the cell tab now in the inspector, and change things like the fill color that we see here. We are using a color fill you can see the color is a shade of gray. We can click that dropdown and choose something different. Maybe a nice light yellow, want something darker? Let’s go back and try the darkest shade. Okay and maybe the font inside then needs to be changed if we go with that. We can also change it from a color fill to gradience.
You can see advanced gradience. Gradient fill’s going to use two color advanced. You can have more than two colors. We could fill it with a pattern called an image fill, and there are some advanced options here as well. Let’s go to gradient fill, now we get to choose the two colors that are going to be used. How about white and then for the bottom color we’ll go to that medium yellow. You can see the effect that we get there. It’s kind of a goldie look, that looks pretty good actually just as is. You can experiment with those.
We can even adjust the gradient angle if we wanted to. You can see it going left to right, right to left, up and down, or reverse those colors dark at the top. I like dark at the bottom because we have a dark font inside. So with light at the top we get the best contrast it looks pretty good. We could also type in specific angles if we wanted to. Or use the arrows to set it up, down, left or right. Let’s go back to the dropdown now, and try advanced gradient fill. From here you can see we have bar now where we can add additional colors to this bar just by clicking anywhere on the bar.
If we wanted a third color in there for example we could do so by selecting it from our colors palette. I’m going to choose something a little bit darker, and you can see we get a more gradual gradient fill. Or if we wanted to we could go from light to dark to light again. We could go way over here to white if we wanted to, and you can see the effect now that we’re getting. We’ll close up the colors palette, go back to the drop down and let’s go back to color fill. That gives us the option for a solid color, and we can click the dropdown either next to the color wheel or up at the top selecting from here until we get the color that we want.
I’m going to go with that one right there and we’ll deselect. So you can see our table looks a lot different than when we started by making a few changes to the border around the outside of the table as well as the gridlines and some of the cell shading.
- Creating and laying out spreadsheets
- Importing data
- Working with tables
- Adding images to cells
- Performing calculations with formulas and functions
- Creating charts
- Formatting text and numbers
- Including audio, video, and shapes
- Designing templates
- Printing and sharing spreadsheets