In this video, learn how to identify different table types you can create, and then add a new table to a sheet. Also learn how to change the number and width of columns, as well as the number and height of rows. Also, learn know how to remove a table.
- [Narrator] The backbone of any file you create here in Numbers is going to be the tables. Tables are where we add our labels, numbers, and calculations. We are going to continue working on our Leaf and Mortar Budget File 0301 if you're catching up. This is an example where we imported content from Excel and we see different sheets with different tabs across the top, each of which contain a table. If we go to Expense Report, there is the table. Expense Details has a larger table. Income Details also a fairly large table.
Let's go back to Profit-Loss Summary. You can have multiple tables on a single sheet, that's fine. What we are going to do starting with this very first movie in the chapter is create our own table. If we wanted to recreate the table that came from Excel which has too many columns, too many rows, maybe it doesn't have the formatting we want, because it's such a small table it might be easier just to recreate it from scratch on our own and that's what we're going to do. Instead of deleting the table first, we are going to create the new table using some of the figures that we see here, so to insert a table you have a couple of options.
You can go to the insert menu, click there, you will see table down below. As you hover over that you will see the different table types you can insert. A table is a table with different options turned on and formatting, that's what we see over here to the right. These are some options that will give you a head start. For example, if you want a header row and a header column down the left, you can choose headers. If you only want a header row you can choose basic. If you don't want any headers at the top or down the left you can choose plain.
If you're going to be totalling up numbers at the bottom you can start with sums. There's a checklist option even for working with stocks. Now we don't get to see what these look like so let's click in the background. That closes up the menu and instead we will go to the table button on the toolbar. Click there and you will see the same six options. Instead though you will see a graphical representation of each. Here's headers with a header row and column. Here's our basic one with just the header row. Plain with no headers. Here's one that has a row at the bottom for sums and there's our checklist and our stock option.
We can see different formatting for these six tables by using the arrows. There's the same group of tables with different formatting. You can see different colors and options. Let's go all the way back to the beginning so the first dot is selected and as we look at the table we are going to be creating in the background here, it looks like it does have a header row and there are labels down the left so we might want to go with this first option here which is the headers option.
Give it a click. You can see a default table is added to our sheet and appears below the existing table. Now it's time to add our content. Let's start with the title where it says Table 2. Just double click to get inside, then click and drag over Table 2 so we can type over it, Annual Budget Overview 2018. This is a little bit different than the table that was brought in from Excel in that this is the actual title over the top of the table as opposed to inside the table.
Now we can go to that first cell where we see our first label Budget Totals. That's going to be cell A1 in our table. We will click there and type that in. Now we can move from cell to cell going left to right using our tab key. Estimated goes next. Tab over and type in Actual in cell C1 and tab over for the last label which is Difference. Press return and that wraps you around back to cell A2 where we can type in Total Income.
Press return, takes us down to the next cell. Total Expenses. Press return, Difference, there we go. Now all we need are some values so click where it says Estimated above and Total Income to the left, that's cell B2 and don't worry about formatting, we will get to that. 520491 is what we are typing in there. Hit your tab key. You will see the number doesn't even appear to be a dollar amount and the alignment is a little bit off so we will fix that up a little bit later.
The actual is 555401 and the difference is going to be a calculation so let's just go down here to cell B3 under Estimated next to Total Expenses, type in 551328. Tab over and that's 543584, and press return. So we have all of the labels and the numbers we want, all we need to do is add in the those calculations.
We will get to that a little bit later. Right now you can see we're going to have way too many rows and one too many columns, and here's the fastest and easiest way to adjust the number of rows and columns in your table. Use the handle that appears in the bottom right hand corner. Clicking and dragging that out to the right is going to add columns. Dragging it down adds rows. Dragging it up removes rows. Moving it to the left removes columns. So we want to go to four rows by four columns.
You can see next to your mouse it's showing up the total so you don't even have to count them. When you see row four column four you can release and there's your table. Now of course we might want to increase the widths of the columns, maybe the heights of the rows. The fastest and easiest way to do that is to select the table, let's go up to this selection handle in the top left corner, clicking that tells you that your table is selected when you see the handles that appear on the right, bottom right corner, and at the bottom.
This is for adjusting column widths and row heights. We can do both at the same time in the bottom right corner or do one at a time by using the handles at the right or at the bottom. For the column widths let's just go to the one on the right. When you see the double arrow horizontal appear instead of your mouse pointer, click and drag that out to the right. You can see the width in inches being adjusted. Let's go all the way out to eight. Go to 8.0 and release.
Notice the column widths are equal. They stay that way because of settings that are set up over here, we will get to those later. It's time for the row heights and we can go to the bottom handle, a double vertical arrow will appear when you're on that handle, click and drag that down to 1.7. When you get there, release and there's our table. Click in the background to deselect. That looks like the table above with some different formatting obviously.
We still need to add the logo et cetera. We will get to that later. Right now we are done with the table that came in from Excel so click anywhere in that table. Now you can click the handle in the top left corner for Table 1 with it selected we can tell by the handles, we can hit delete on the keyboard to remove it. It's gone. Now we can choose the Leaf and Mortar logo. We will probably need something like it but for now we don't need this so with it selected, hit your delete key on the keyboard and now we have our table that we added and this can be moved around.
Click anywhere in the table, click the handle in the top left corner to select the entire table and just click and drag from there. You can actually move it up near the top and release. Click in the background, looks pretty good. So that's how you add a table and of course we can add multiple tables to a sheet if we wanted to. Once you have your table in there, you have your labels, your numbers, you will probably want to add your calculations so formulas and functions for example. Then it will come time to make modifications to your table to make it look the way you want and that's all coming up in this chapter.
- Customizing the user interface
- Creating basic spreadsheets
- Importing spreadsheet data
- Adding and modifying tables
- Working with content in table cells
- Using and modifying table cells
- Using formulas and functions
- Working with charts, text, numbers, and objects
- Designing templates
- Sharing spreadsheets