I want to copy and paste a table from Numbers to Pages, but the options I require from the 'Edit' list are greyed out.
I want to do this because I can't find a way of selecting just some columns from the table to print, so I thought if I transferred it to Pages I could delete them there.
Can anyone advise please?
Have you selected the Table?
Copy will be greyed until something is selected.
"I can't find a way of selecting just some columns…"
Numbers does not support selection of non-contiguous cells. You should be able to select columns C,D and E, but would not be able to select columns C,D and F.
To select a set of three contiguous columns CDE for example):
Click on any cell in the table to make the table active and show the row and column reference tabs.
Click the reference tab for column C
This will select all cells of column C.
Press and hold the shift key, snd click the column reference tab for column E.
This will add column E and all columns between it and the previously selected column C to the selection.
Pressing Command-C at this point will copy the selected cells.
Going back to the bigger situation: "I can't find a way of selecting just some columns from the table to print"
If the columns you want to print are a contiguous group, you can do this:
Select the first column tab of the set, then shift-click on the last column tab of the set.
With all cells in the group now selected, press command-C to copy those cells to the Clipboard.
Launch Preview.
In Preview, go to the File Menu and choose the first item: New from Clipboard.
Preview will now display a page containing a pdf image of the cells you selected.
You can print this directly, or copy the image and paste it into a Pages document and print it from there.
Regards,
Barry
Have you selected the Table?
Copy will be greyed until something is selected.
"I can't find a way of selecting just some columns…"
Numbers does not support selection of non-contiguous cells. You should be able to select columns C,D and E, but would not be able to select columns C,D and F.
To select a set of three contiguous columns CDE for example):
Click on any cell in the table to make the table active and show the row and column reference tabs.
Click the reference tab for column C
This will select all cells of column C.
Press and hold the shift key, snd click the column reference tab for column E.
This will add column E and all columns between it and the previously selected column C to the selection.
Pressing Command-C at this point will copy the selected cells.
Going back to the bigger situation: "I can't find a way of selecting just some columns from the table to print"
If the columns you want to print are a contiguous group, you can do this:
Select the first column tab of the set, then shift-click on the last column tab of the set.
With all cells in the group now selected, press command-C to copy those cells to the Clipboard.
Launch Preview.
In Preview, go to the File Menu and choose the first item: New from Clipboard.
Preview will now display a page containing a pdf image of the cells you selected.
You can print this directly, or copy the image and paste it into a Pages document and print it from there.
Regards,
Barry
Barry wrote:
Numbers does not support selection of non-contiguous cells.
Command click 😉.
@ mausom,
Duplicate the table (click once, anywhere on the table, then command D).
Command click on the column labels to select the columns that you do not want to print.
Delete Selected Columns
Move the new table to another sheet and print only that sheet.
Regards,
Ian.
Hello Ian, thank you for the above. That's useful information. As it happened I only wanted to print contiguous columns last time so was able to do it successfully with Barry's instructions.
Regards
Maureen
Hi Ian,
Thanks for the correction. 🤭
Regards,
Barry
Hello Barry, thank you very much indeed for your clear and easy to follow explanation.
I'm very grateful.
Maureen S.
Greyed out items in Numbers
