You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Importing a worksheet into a new document

I would like to import a worksheet into a document.


It seems like it should be an easy enough task, but not self-explanatory.


If I "add a new sheet", I can copy and paste the content from another worksheet, but I have to create the same number of columns and rows in order for the worksheets to match.


When I do this, images do not seem to carry-over to the new sheet.


It seems like there should be an easy way to drag and drop a worksheet into a document (with multiple sheets).


Please help!

MacBook Air 13", macOS 10.14

Posted on Mar 25, 2020 4:35 AM

Reply
Question marked as Top-ranking reply

Posted on Mar 25, 2020 10:10 PM

"If I "add a new sheet", I can copy and paste the content from another worksheet, but I have to create the same number of columns and rows in order for the worksheets to match."


That's because you are copying the content of the table, not the table itself. Numbers, text and formulas in cells are 'content'; fill colours and images in cells are format.


If you select the Table (Click a cell, to make the table active, and display its column and row reference tabs), then click the 'bullseye' at the intersection of the column and row reference tabs)to select the Table,


Then press command-C to copy the selection,

You get a copy of the table, including the content and format(s) of its cells.


Move to the destination document, choose the destination Sheet, and press command-V, and the Table, complete with contents and formatting, will be pasted onto the selected Sheet.


If you have other Objects on the source sheet, and want those to be included in the destination sheet, then:


After selecting the Table (an object), press command-A to Select All (objects).


Then copy, and proceed from there.


Regards,

Barry




1 reply
Question marked as Top-ranking reply

Mar 25, 2020 10:10 PM in response to rofitzpatrick27

"If I "add a new sheet", I can copy and paste the content from another worksheet, but I have to create the same number of columns and rows in order for the worksheets to match."


That's because you are copying the content of the table, not the table itself. Numbers, text and formulas in cells are 'content'; fill colours and images in cells are format.


If you select the Table (Click a cell, to make the table active, and display its column and row reference tabs), then click the 'bullseye' at the intersection of the column and row reference tabs)to select the Table,


Then press command-C to copy the selection,

You get a copy of the table, including the content and format(s) of its cells.


Move to the destination document, choose the destination Sheet, and press command-V, and the Table, complete with contents and formatting, will be pasted onto the selected Sheet.


If you have other Objects on the source sheet, and want those to be included in the destination sheet, then:


After selecting the Table (an object), press command-A to Select All (objects).


Then copy, and proceed from there.


Regards,

Barry




Importing a worksheet into a new document

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.