Filter Table on Microsoft Office Excel
If you want to display the data base on some data from table on Microsoft Office Excel you can use facility Filter, For example i used Microsoft Office 2010.
Open your table that you want filter.
Block your table
Choose tab Data then click Filter
And then choose the data that you want filter. For Example I want filter coloum Price, I want Display that price is $ 1. Click combo list beside of Price.
Checklist the checkbox that you want display. Then click OK. You can checklist the checkbox more than one.
If i checklist $ 1. The display like that.
Its Easy. Right?
Open your table that you want filter.
Block your table
Choose tab Data then click Filter
And then choose the data that you want filter. For Example I want filter coloum Price, I want Display that price is $ 1. Click combo list beside of Price.
Checklist the checkbox that you want display. Then click OK. You can checklist the checkbox more than one.
Its Easy. Right?
No comments