Newsroom Update

New features come to Apple services this fall. Learn more >

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 Best 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 Best 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 ID.