Home Page. Vipin sir Live Test Class -10
In the previous topic I will discuss how to Create a designer Table in ms Excel . If you don't shee the previous part then see it . In this part I will discuss about how to Filter data in Excel. First we make a Table like the below picture.
In the above picture given the date wise. If you want to Filter it then you follow the sixth step.
Step 1 :-
In this step we go to the small filter icon in table. Icon look like a below picture pointed by mouse pointer. When you click this icon then filter is open like the below picture. In this picture data filter all options is check.
Step 2:-
In this step uncheck the all show option in the filter box. If you click ok then all table data is eliminate. So don't click the ok without fallow the all step.
Step 3:-
In this step select the month whose date is filter right now. When you click the month then open the picture like below. But date is not show then click the + icon in left side of month.
Step 4:-
In this step when you click the left side of month + icon all month is show like the below picture.
Step 5:-
In this step select the date whose date is filtering. When you select the date then look at the screen like below picture.
Step 6:-
First you fallow all the above steps then In this step click ok button. As soon as you click the ok button then open the change table like below picture.
Again you want to eliminate the filter then you goto the filter icon and select the show all and click the ok button. Your all table is show again.
Some other topics:-
1. How to Create a designer Table in MS Excel
2. HTML Basic Programming Language Part -1
4. Who to Solved Script Error in MS Excel
5. Use Vlookup Formula in MS Excel UserForm TextBox
6. Who to Lock your MS Excel File
7. MS Excel UserForm Save And Edit Module Part-1
8. MS Excel UserForm Save And Edit Module Part-2
10. Daily Current Affairs | most important Questions
No comments:
Post a Comment