Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Numbers offers intuitive organization features, allowing users to focus more on analysis and presentation. In Numbers '09 Essential Training, David Rivers explores the important features of this spreadsheet application and introduces the new tools for formula development and charting. He walks through the new functionality of charts, tables, and templates, and shows how to make spreadsheets effective and eye-catching. Exercise files accompany the course.
When you insert a table into a sheet in Numbers '09, default styling is applied to a table with a preset number of columns and rows. You are likely need to make changes to your table like resizing it and perhaps even repositioning it. So let's explore some table modifications using our Energy Savings Plan spreadsheet. And you will notice down at the bottom of the first sheet under Utility Costs, we have got a brand new table that's just been added. We'll begin with resizing our table, which can be done using different methods.
To resize this table by adding or removing rows and columns, we first need to select the table by clicking in any cell in that table. Now we can use the handles that appear in the corners to make changes. For example, to change the number of columns, we'll move to the top right corner handle and now when you click and then drag to the right you will increase the number of columns or drag to the left to decrease the number of columns. To adjust the number of rows we can move to the handle of the bottom left-hand corner, drag up or down to increase or decrease the number of rows. You can also change both at the same time by using the handle in the bottom right hand corner. Drag this handle up and in or out to change the number of columns and the number of rows simultaneously.
Let's create 5 columns with 3 rows. When you release, click anywhere outside the table to deselect it to see the end result. Now we can also resize our table without affecting the number of columns and rows. In this case, we select our table using a different method. Click the name of the table in the Sheets pane and you will notice handles appear around the outside of the entire table. Now we can resize this by dragging the appropriate handle. For example, move to the bottom right hand corner, when the double arrow appears click, then drag across and down to increase the size of the table keeping the same number of columns and rows but simply increasing the widths and heights of the columns and the rows simultaneously.
We can also reposition this table by moving to the outer edge of the table. When you see the four-sided arrow, you can now click then drag to move it around. Use the guidelines to help you line your table up with other objects on the canvas. When you release, deselect the table by clicking anywhere outside the table on the canvas. So although Numbers will provide you with a default number of rows and columns when you insert a new table, resizing and repositioning your table is easily accomplished when using the appropriate selection method.
There are currently no FAQs about Numbers '09 Essential Training.
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.