+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: How do you print only some address labels from a large spreadsheet? (/showthread.php?tid=54503)
How do you print only some address labels from a large spreadsheet? - Microman - 05-08-2008
I have an address spreadsheet, and the wife needs to print some labels from it. How do I only print labels for the peple that I need and not all of the records?
Thanks.
I suppose I could add a column, and put an X in it, and only choose those with an X
Re: How do you print only some address labels from a large spreadsheet? - davester - 05-08-2008
I would add a column with an X in it as you said, but then select the entire area of data (including headers), go to Data/Filter and click Autofilter. Then, click the little arrow that appears at the top of the "x"s column and select "x". That will then show only the ones that you've selected. Print away!
Alternatively, if you already have a column that has a unique identifier for the ones you want to print, then forget about the "x"s and click the arrow atop that column then choose "custom" and make a filter for the identifier.
Re: How do you print only some address labels from a large spreadsheet? - Microman - 05-08-2008
Cool, got the spreadsheet with selected records, using the X in the column method.
But when I go to word, and choose GET DATA, to make the Label, I tried different choices of "entire spreadsheet" etc, but cant get just the data that I had chosen to make lables. It does ALL of them.
What can I do? Thanks
I copied and pasted the "only X" data into another spreadsheet, and printed the labels.
Just need to learn how to get to the chosen data from within the original spreadsheet, when making choices.
Re: How do you print only some address labels from a large spreadsheet? - davester - 05-08-2008
I don't think it's possible from Word. Why don't you print the labels from Excel?
Re: How do you print only some address labels from a large spreadsheet? - Microman - 05-08-2008
I searched excel for help and "labels" and I did not see anything. Let me look again