Auto-filling table cells


show more Auto-filling table cells provides you with in-depth training on Business. Taught by David Rivers as part of the Numbers '09 Essential Training show less
please wait ...

Auto-filling table cells

When entering data into a table in Numbers '09, you can save a lot of time using the Auto-fill feature. With Auto- filling you can use the content in one or more cells to automatically add values to adjacent cells. So let's use our Energy Savings Plan spreadsheet here to investigate the different ways to do this. In our List of Energy Savers table here, we have a single total showing up in the Total column. Let's click to select that cell. Notice it's column E and we are in the second row. The formula appears on the Formula Bar. Now, we could type in this formula for every other row in this column or we could save a lot of time using Auto-fill.

One way to use Auto-fill is to select all of the cells ahead of time. You can click and drag from the bottom cell to the top or from the top down. Once you have got your cell selected, click Insert, move down to Fill and here you will have two options, to Fill Down or Up. Fill Down is going take the top value and fill the other c...

Auto-filling table cells
Video duration: 3m 50s 3h 53m Beginner

Viewers:

Auto-filling table cells provides you with in-depth training on Business. Taught by David Rivers as part of the Numbers '09 Essential Training

Subject:
Business
Software:
Numbers
Author:
please wait ...