Avatar of tcmmaxt
tcmmaxt
Flag for United States of America asked on

how do you separate and print/list a certain group in an Microsoft Office Excel Worksheet

Expert:
New to Microsoft Office Excel Worksheet. I have an Excel Worksheet with a list of people's names in one column called "Names" and another column called "Group" which shows the respective group that the person belongs too. I need someone to show me how to break out and print/list the Names  by Group. any help how to do this would be great
Example
Group               Names
blue                 mary doe
blue                   joe doe
abc                  tom smith
xyz                   john doe
xyz                   jim  brownt
HYT                  larry doe
HYT                  betty kingy
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
nutsch

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
nutsch

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
nutsch

If you need to print groups separately, you can right-click the group field on the pivot, go to Field Settings, Layout and Print, and click Insert Page Break after each item.

T
tcmmaxt

ASKER
nutsch:  
I have lots of columns. Column A is the "Names" column  and column E is the "Group" column
A "Create PivotTable popup" appeared with
Table/Range: 'Report_(All_people)(1)'!$A$1:$G$1000  
and with default checkbox  =  New Worksheet

now please to tell me what do I have to do to "Put the Group and Names as column Fields" as you indicated?




nutsch

Which excel version are you on?

T
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
tcmmaxt

ASKER
again thanks:
the file has a .xlsx extension    excel 2007
nutsch

Check out the attached screencast.

T
nutsch-488056.flv