• Inserting Tables
• Moving Tables
• Table Navigation
• Modify Table Size
• Modify Row and Column Size
• Modify the Size of All the Columns and Rows
• Modify the Size of Individual Columns and Rows
• Copying Tables from Sheet to Sheet
• Change the Style of All the Tables on the Same Sheet
• Change the Style of a Table You’ve Tinkered With
• Create a Table Template
• Saving Your Template

Inserting Tables

Use Insert from main menu bar - or - the Table button on the Toolbar.

• If you want the name of your table to appear on your sheet above the table, check the Name box on the right end of the Format Bar (see image below):

• Go to the Table menu to add extra header and footer rows in your table.
• Control-Click on an existing header cell of a row or column and a drop-down menu gives you the option to make extra headers and footers (max of 5) under Header & Footer.

Moving Tables

1. Select the table you want to move in the Sheets Pane
- or -
Click the upper left-hand corner block of the table (see image below):

corner block

2. Move the cursor towards any edge until the cursor-plus-cross appears (see image below):

cursor-plus-cross

3. and then Click-Hold-Drag the table to where you want it to be.

Table Navigation

Hit:
Return – you move down one cell.
Shift-Return – you move up one cell.
Tab – you move right one cell.
Shift-Tab – you move left one cell.

When you are in a cell in the last column of your table and:

you hit Tab once – you won’t go anywhere
you hit Tab twice – another column will be added
you hit Return – you will either move one cell down or jump back to the first open cell below the last cell you started to originally Tab from before hitting Return.

Confused? (Look up and see where you are. Take a deep breath.) If you’re filling out information in a row straight across all your columns and then working your way down row-by-row – hit Tab to move right (as you’re adding info) and when you’re at the last column in your table – hit Return and you’ll be taken to the cell below where you first started using Tab to move right (see image below):

Modify Table Size

Remember: you can’t reduce the number of columns or rows over any filled cells this way:

1. Click anywhere in the table.
2. Click-Hold-Drag:
the lower right corner handle
– or –
the handles on the end of the column and row header bars.

Modify Row and Column Size

Control-Clickll to show pop-up me in any cenu options.
– or –
Control-Click a reference tab number or reference tab letter and use the pop-up menu (see images below):

reference tab number

reference tab letter
– or –
Click on the individual arrows that appear when you hover over each reference tab number of the rows or reference tab letter of the columns and use the pop-up menu.

Modify the Size of All the Columns and Rows

Select the table you want to change in the Sheets Pane
– or –
Click the upper left-hand corner block (where the column and row header bars meet on the table (see image below):

corner block

Click-Hold-Drag any of the little outside corner and side handles.

Modify the Size of Individual Columns and Rows

Click-Hold-Drag the expander icon inside the column and row reference tabs (see image below):

expander icon

When you are in PRINT VIEW – page header and footer fields will appear that you can fill in and they will appear on every page. Double-Click inside them and go to Insert for more options.

Copying Tables from Sheet to Sheet

1. Select your table in the Sheets Pane
2. Go to Edit - Copy
3. Select your new sheet
4. Go to Edit - Paste (to paste as is)
- or -
Edit - Paste and Match Style (to match the style on your sheet)

Note: You can copy and paste in tables from Keynote and Pages the same way.

Change the Style of All the Tables on the Same Sheet

Grab a style from the Styles Pane and drop it on your sheet in the Sheets Pane.

Change the Style of a Table You’ve Tinkered With

To use a different style from the Styles Pane on a table you’ve already made specific design adjustments to and want to get rid of:

Click the drop-down menu next to a style in the Styles Pane and choose Clear and Apply Style

Create a Table Template

1. Design your table and fill in all your repetitive headers and formulas.
2. Select your table
3. Go to Format - Advanced - Capture Table...
4. A window opens that lets you name it and decide if you want it to adapt its style (or not) when used.
5. Your new table is now added to the drop-down menu that opens with the Tables button in the Toolbar.

Note: You can copy cell formulas that have little warning triangles to other cells. The triangles go away when you later fill in the data to make their calculations.)

Saving Your Template

Go to –
File - Save as Template...

If you save it into the default folder of My Templates, it will be visible in the Templates Pane of the Template Chooser under File - New From Template Chooser...

To delete a template:
Go to –
Finder - User Folder - Library - Application Support - iWork - Numbers - Templates - My Templates

Any questions?

return to top