Hi this is Gary with MacMost.com.
Let’s look at using Tables with Headers and Footers in Numbers.
Using Numbers version 3 here and we’re going to take a look at how to create a basic table
with Headers and Footers and how to use those Headers and Footers.
We’ve got a blank sheet.
We’ll just choose from the template and it is going to give us a default table inside
of a sheet and it already has one header row and one header column.
The first thing we’re going to do is to learn how to shrink the table to fit what
we need.
We don’t have any data in yet so I can select the table here clicking on the dot at the
upper left hand corner of a table will allow me to select the entire thing and I can use
these other dots here with the two lines in them to shrink the table.
So since I don’t have any data yet I’m going to shrink it down to just include one
actual row for data, in addition to the column there, and then I’m going to also shrink
it this way.
So I only have just a limited number of rows to create a sample table.
Here is a good beginning.
I’m going to create some sample column headings here.
Let me do a simple inventory spreadsheet.
So we’ll do “count” and “cost” and “price”.
Then as a sample row we’ll add one product here.
Let’s say we have thirty of them and they cost 30 cents a piece and we sell them for
50 cents a piece.
The idea is that we have no excess rows here.
We just have this one.
If we hit return in any of these cells we automatically get a new row and we can type
in some new data.
I can keep hitting return to add more rows.
But first let’s add a footer column.
So I want to add one footer row.
By doing so I’m going to use Format, then Table, and then add one right here but it
is going to basically turn the last row into a footer row.
So I’m going to drag here and add one so I have one for it to use and I’m going to
add one like that.
You can see it is going to draw a thicker line there at the bottom and these are my
footer cells.
So here’s what I can do with them.
Let’s type a formula in.
I’m going to do equals sum and going to click on B here which identifies as count.
The reason it identifies as count is because that is its name in the header row.
So you can see it is already using the header there for something.
It gives me the total.
I’m going to also go in here and let’s say let’s do something like average.
The average price.
I can click on C there and it says cost and I’m going to copy and paste it in there.
So I’ve got the sum.
I’ve got two averages here.
So now I’ve got this in the footer row.
What happens now is when I want to add a new row for a new item here all is need to do
is hit return, like before, and you can see it inserts it there and moves the footer down.
So it recognizes that this area in the middle is the area for the data and the header and
the footer are different.
So the footer gets pushed down and I can add something in here.
You can see how it automatically updates this.
So remember this is the sum of this column, count, and it knows that it is not supposed
to include the header or the footer row.
So it is not adding itself to itself here.
It is just adding between the header and the footer.
The same thing with the average.
It is only adding the stuff between the header and the footer.
So having formulas in footer rows and then using the column names that allows you to
just basically perform operations on everything in the column without worrying about overstepping
its bounds.
Furthermore, it is going to use the labels here in the header column and the header row
for making formulas clearer.
So if I wanted to say add this you can see that instead of saying B3 it is saying count
orange plus count pear times cost pear.
So using these makes it really easy to figure out what your formulas are actually doing
and then using the footer there makes it easy to put together formulas that perform operations
on the entire column.
Then in addition to that it knows that the headers here shouldn’t move with the rest
of this text.
So if I actually scroll up the window you can see how the header stays there and the
same thing if I scroll to the left the header column stays there.
So it makes it very easy to fill in data and move throughout the spreadsheet without having
to set some sort of predefined, you know this stays and this doesn’t stay kind of thing.
In addition you’ve got a lot of formatting options under Table here.
I can change the table style.
You can see its got a style that takes into account these header columns and header rows
and footer rows.
So there is a lot you can do to make it very nice and easy like that if you’ve got these
predefined and your table put together correctly rather that just say putting the formula in.
If I had not defined row five as a footer and I tried to do some of these formulas it
wouldn’t quite work because it would be taking into account these cells here.
So that is how you put together a proper table in Numbers.