If you want to print or create a PDF with an area of a Mac Numbers spreadsheet you'll find that you can't do it like you can with Microsoft Excel. But there are various strategies you can use to print a selected area in a table or print only specific rows.
You can also watch this video at YouTube.
Watch more videos about related subjects: Numbers (200 videos).
You can also watch this video at YouTube.
Watch more videos about related subjects: Numbers (200 videos).
Video Transcript
Hi this is Gary with MacMost.com. Today let's look at printing a section of a Numbers spreadsheet. MacMost is brought to you thanks to a great group of more than 700 supporters. Go to MacMost.com/patreon. There you could read more about the Patreon Campaign. Join us and get exclusive content and course discounts.
A very common question I get is how to print just a section of a spreadsheet in Mac Numbers. A lot of people previously used Microsoft Excel and Excel allows you to setup a print area and just print that area of the spreadsheet. Taking a look here in Numbers one of the things we have to acknowledge about Numbers is that it is fundamentally different than Excel.
In Numbers you can have a document which is has multiple sheets in it. In this case this one has a budget sheet and a transaction sheet. A sheet is like a canvas. It's just a large white space where you could add all sorts of different things. In this case there's a text box, another text box, a chart here, another chart, and there's a table here. A table is what we usually think of in Excel as a spreadsheet. So we have five different elements here just laid out on the canvas of this sheet. Excel is very different in that a sheet goes edge to edge just cells. You can see there is no white space and there are no multiple tables. You've got columns and you've got rows that stretches as far as you want in this sheet.
Even spreadsheets that seem to have multiple elements really don't. Here you can see well there's some charts and what look like different tables but in fact they're not. You can see here there are columns across the top and each one of these things is a cell or group of cells in a column and a row. So everything has to be designed to fit in with the rows and columns here iIf you want to have multiple things on the same sheet. With Numbers I could just add as many tables as I want. I could create another table here and I could stick it wherever I want. I could make it a different size, a different shape. I could make the columns different widths and heights and everything. You have maximum flexibility.
But with that flexibility comes an issue when you try to print because you can't just simply say I only want to print a section of this because it doesn't really make sense when you have multiple elements on the screen. However that doesn't stop people from wanting to print just a portion of what they see on the screen. So let's take a look at some strategies.
Looking at the second sheet here it's just a long list of transactions. So this is a little similar to what you might use in Excel and here you just might want to print a section of this. So how can you do that? Let's say you wanted to print the first 20 rows here. So I could select this row by clicking on the number to the left. I can Shift Click and select this row. So I've selected here now the first 20 rows. Now how do I print just that? Well there's no way to do it with just Numbers but there's a helper tool that comes with your Mac that can be used in all sorts of different ways called Preview.
In using Preview you can do this fairly quickly. So here's what you do. All you're going to do with this selected is Copy. So Edit, Copy or just Command C. Now let's launch Preview. I can do it here with Spotlight or you may have it in your Dock already. So with Preview launched, you can see I'm running it up here, I can go to File and you can see New From Clipboard is the default for New. As a matter of fact Command N will get you there. When I do that you get a little document here that's exactly what I selected in Numbers. Numbers and Preview work together so that you can send the selection from Numbers into Preview and give you a nice little area to print out.
Now for most of us printing actually means saving as a PDF. Well at this point, when you're in Preview it is a PDF. So all you need to do is Save and you'll be saving this out as a PDF file wherever you want it. Or if you do actually want to print to paper you can just go Print here and print it out. So this could be fairly quick and it works with just about any selection in Numbers. So let's go back to the first spreadsheet here. I can click inside this sheet here and I can click the little circle here to the upper left or you can use the trick where you do Select Parent and now I've selected that whole table. Command C, launch Preview, Command N. Now I've got that table in there all by itself and I can Print.
You can even include other things in it. So, for instance, I can do these charts here although charts print as bitmaps so they don't look as smooth as printing out the text table. So if I select this, Command C, then Preview, then Command N it works. But if I zoom in you could see the pixels.
Now what happens if I just want to print a section of this like say these rows right here. Well I can do Command C, and then switch to Preview, Command N and I'll get those rows. But what if I want the Header row as well. If you try to select that, I'm going to hold the Command key down and select the first row, you can see I've got the first row selected and then rows 12 through 21. Now when I do Command C and then Preview and Command N I get the Header row and I get just the rows I've selected and everything else is blank. Which is nice that it's not showing those but I don't want these blank rows there.
So here's what you can do. You can simply use the Hide function in Numbers to do this. So instead of selecting the ones I want to Print I'm going to go and Hide a bunch of rows. So let me go and select this row to this row here, Shift Click to select that. Then I can go to Table, Hide Rows. Let's go and select a bunch of other rows here from 22 all the way down to the end. Shift Click to select those. I can also click on the little down arrow here and I can select Hide selected rows. So now I've got just what I want to print. I click the circle here to select the entire table. Copy, Preview, Command N and now I get exactly what I want.
Back here in Numbers I can just use Edit Undo or Command Z to Undo the first Hide and Undo the second Hide or I can go to Table, and say Unhide all rows to get back to where I was. So you do a little bit of prep work and then you go to Print through Preview and then you'll Undo that prep work to get back to the whole table.
You can also use Filters for this. For instance if I just want to print things that were in the Travel category here I could click here at the top column and say Quick Filter, Show Rows Containing and Travel. That's all I've got there. Now I select this whole table, Copy, Preview, New I get exactly that. Back here I can here and go to Quick Filter, I turn this off, or I can simply go to Edit Undo, Command Z, to get rid of the filter.
Here's another strategy people like to use. Create another sheet with what you want to print. So I'm going to select this whole table here and Copy it. Then I'm going to go and hit the Plus button here to create a new sheet. Let's delete this table here and Paste in a copy of that previous table. Since that was the only table on that sheet I could have actually gone here and just hit Duplicate to actually make a copy of that sheet. Since this is a copy I can go and do what I want. I can select some of these rows here and then click here and Delete selected rows. I could get rid of a column that I don't need. I can shrink a column if maybe it won't fit on a page otherwise. Do what I need here and then go to Command P to Print this. When I'm done I can then go and Delete this temporary sheet I've created.
Now if you want something a little permanent, something where you're always printing some rows and never printing others you can always add a column and filter by that column. So I'm going to click here, add a New Column After, and call this one Print. Then I'm going to double click on the column header so I select all the regular cells. I'm going to set the Cell format to Checkbox. Basically the idea is that anything you check will Print. So I can check a bunch of these different columns here. I'm going to create a filter here and the filter is going to be anything that's True. So you can see I've only see the rows that are checked. Then the next thing I want to do is Hide this column. Now I go to Print and I only see the rows that are checked off. If I want to change those I need to go here and Unhide that column there and also turn the Filter off and now I can play around with these checkboxes and then turn the Filter On again, Hide this column to Print again.
Also, another problem people had is you can't see what area is going to be printed until they hit Command P. Then you can see it. Well it's actually really easy. Command P, Command period. So you can see how quickly you can get through it. So let's say I wanted to print those checkboxes there but I wanted it to fit on a page. I could look at this and say well, you know what, I could probably shrink this description column a little bit. Command period. Let's go and shrink this column here. Command P. No, not enough. Command period. Let's shrink this category column a bit. Command P. Still not enough. Let's go and shrink the print column. Command P. Ahh! Now it all fits in. See how quickly I can switch between these two modes here and make adjustments.
So there's some different Printing strategies for you. Which one you choose depends upon your specific situation. For instance, copying and pasting into Preview works best when there are only a limited number of rows that are going to fit on a single page. Usually it has to be 200 rows or less although anything more than 100 rows the print gets really small. If you need to print really often it's best to design your spreadsheet from the very beginning for printing. So use Command P, Command period to get back and forth. Design your entire spreadsheet around the PDF or printout want to produce so that you don't have to go through any extra steps every time you want to print.
Remember it's always easy to experiment with Numbers' spreadsheets. Just duplicate the file. Then take the duplicate and play around with it. Maybe redesign it so that it looks better when you create a PDF or print. If you decide that you're headed in the wrong direction you can get rid of that copy and go back to your original. Make another copy and try again. Experimentation is how you're going to be able to get your ideal spreadsheet.
I'm going to use your tip for a "print" column with cell format set to checkbox every day. Thank you for the GREAT content.