I think I am over thinking this but I have confused myself. I am using Numbers to create a spreadsheet of family names with their corresponding number. I would like to print multiple columns of names on one page to save paper but I can't figure how to do it. Will someone please help me???
Hi BestMommy,
Here is one way. Don't mess with your database. Create a new table for printing.
Database with a Header Row (named Table 1 as an example) might look like this:
# | Name |
1 | Name 1 |
2 | Name 2 |
3 | Name 3 |
4 | Name 4 |
5 | Name 5 |
6 | Name 6 |
7 | Name 7 |
8 | Name 8 |
9 | Name 9 |
10 | Name 10 |
11 | Name 11 |
12 | Name 12 |
13 | Name 13 |
14 | Name 14 |
15 | Name 15 |
New table for printing:
# | Name | # | Name |
1 | Name 1 | 8 | Name 8 |
2 | Name 2 | 9 | Name 9 |
3 | Name 3 | 10 | Name 10 |
4 | Name 4 | 11 | Name 11 |
5 | Name 5 | 12 | Name 12 |
6 | Name 6 | 13 | Name 13 |
7 | Name 7 | 14 | Name 14 |
Formula in A2
=Table 1::A2
Formula in B2
=Table 1::B2
Formula in C2
=Table 1::A9
Formula in D2
=Table 1::B9
So it loops back from the bottom of a page to start a new column.
I made this example small for the pics, but obviously you could have more rows and columns per page.
Having created your table for printing, select it, Cut, add a new sheet and Paste. Print just that sheet.
Have a look at 'More Like This' at the bottom of this page. Trying to format page to print table in two columns Jerry suggests using Pages instead of Numbers.
Regards,
Ian.
Edit: Having created your table for printing, select it, Cut, add a new sheet and Paste. Print just that sheet. Ian.
how do i print multiple columns on 1 page in numbers
