Forum Discussion
Making a simple report
I am a complete novice to Excel. I have a data sheet with names of people, last name in col. A, first in Col B and whether or not (Y/N) they are members in col H. First I want to isolate the non members (N in col H) and then print a report with the remaining names.
Having read some of the other questions, mine seems very simple, but not when I do not know what most of the terms used even mean.
Let assume you have such data
- select headers (click on A2, press Shift, click on H2, release Shift)
- click on Filter icon in Data section of the ribbon
On the right of each cell filter button will appear. Click on one in column H and deselect N
Result is
on ribbon File->Print->Print
3 Replies
You may apply filter to column H and print filtered range.
SergeiBaklan Thank you for the reply but remember my opening line. I have no clue as to how to do that. I would need a step by step. Such as go to ___ right click, select --- by left clicking etc. I understand the concept of a filter but not where or how.
Thanks again.
Let assume you have such data
- select headers (click on A2, press Shift, click on H2, release Shift)
- click on Filter icon in Data section of the ribbon
On the right of each cell filter button will appear. Click on one in column H and deselect N
Result is
on ribbon File->Print->Print
