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.

how to print a specific area in a large number spreadsheet

Recently switched from Excel to Numbers. Have a large spreadsheet and only want to print a certain area of the spread sheet. i.e. columns A thru H and Rows 489 through 579. Is there a way to select this specific are for printing?

Posted on Jun 10, 2022 6:51 AM

Reply
Question marked as Top-ranking reply

Posted on Jun 10, 2022 9:14 AM

As you've probably noticed Numbers makes it easy to multiple smaller tables on the same sheet. (see templates at File > New in the menu to see examples of effective document design in Numbers). So there's much less need to try to grab specific areas of a vast expanse of cells that you often have to work with in Excel.


But there is a way, and it's much quicker and easier than it sounds. Just select the range of cells in the Numbers table, here A489:H579 if I understand you correctly, type command-c to copy, launch the Preview App, type command-v to paste, and print from the Preview App. The result is generally very high quality.


SG

2 replies
Question marked as Top-ranking reply

Jun 10, 2022 9:14 AM in response to waynefromzionsville

As you've probably noticed Numbers makes it easy to multiple smaller tables on the same sheet. (see templates at File > New in the menu to see examples of effective document design in Numbers). So there's much less need to try to grab specific areas of a vast expanse of cells that you often have to work with in Excel.


But there is a way, and it's much quicker and easier than it sounds. Just select the range of cells in the Numbers table, here A489:H579 if I understand you correctly, type command-c to copy, launch the Preview App, type command-v to paste, and print from the Preview App. The result is generally very high quality.


SG

Jun 10, 2022 10:30 AM in response to waynefromzionsville

Preview is your valued assistant for this task.


Click on Cell A489 to select it.

Shift-Click on Cell H579 to select it and all cells in the block between it and A489 to the selection.


Press command-C to Copy.


Bring Preview to the front, then click on Preview's File menu and choose New from Clipboard.


The copied cells will be placed in Preview as a .pdf image.


Print.


Regards,

Barry

how to print a specific area in a large number spreadsheet

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