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

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

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.