Use Filter in Excel in Hindi .Filter your Excel data if you only want to display records that meet certain criteria.
Filter by specific text or numbers
Click the arrow Filter drop-down arrow in the table header of the column you want to filter.
If the column has numbers, click Number Filters. If the column has text entries, click Text Filters.
Pick the filtering option you want, and then enter your filtering conditions.
Filter items by color
If you've applied different cell or font colors or a conditional format, you can filter by the colors or icons that are shown in your table.
Click the arrow Filter drop-down arrow in the table header of the column that has color formatting or conditional formatting applied.
Click Filter by Color and then pick the cell color, font color, or icon you want to filter by.
To apply multiple filters:
Click the drop-down arrow for the column you want to filter. In this example, we will add a filter to column D to view information by date. ...
The Filter menu will appear.
Check or uncheck the boxes depending on the data you want to filter, then click OK. ...
The new filter will be applied.
To watch more videos and download the files visit http://www.myelesson.org
To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788 10 Most Used Formulas MS Excel
Learn Basic Excel Skills For Beginners || Part 1
10 Most Used Excel Formula
**Most Imporant Excel Formuls Tutorials**
Learn Vlookup Formula For Beginners in Excel
5 Excel Questions Asked in Job Interviews
Create Speedometer Chart In Excel
Learn the Basic of Excel for Beginners || Part 2
Create Pareto Chart In Excel
How to Create Dashboard in Excel
Excel Interview Questions & Answers
Hello sir thank you for you video..I have a small query,
Kya ye possible hai, agar main HONDA, BMW and VOLVO ke vehicle jitne bhi sale hue hai unhe sum karke neeche likhunga and main drop down mein jaake ke sirf Honda select karunga toh Kya muje answer milega ki kitne HONDA ke vehicle sale hue hai?
Amount of product 1 2500
Amount of product 2 350
Amount of product 3. 1050
Amount of product 4. 725
Amount of product 5. 430
Mujhe products choose karke unka amount ka sum janna hai
To ye excel may kaise karenge
Maan lijiye meri dukan me lagbhag 55 products hain aur meri absence may mera employee jo newly joined hai use sare products ki price yaad nahi aur kisi customer ne usse 12 products mange to wo easily amount ka total kaise kare
Plz bataiye thanks
Hello Sir I am Srikanth, I am Regular follower of your
videos, I have one doubt, if i am working on sheet 1 ex: if iam typing India it has to replicate same thing India in
Sheet 2 is it possible, if so please help me.
mere paas ek vba wala workbook hai usme vba me hyperlink kiya gaya hai main us hyperlink pe click karta hoon to mera sheet open hota hai but niche jahan sheet 1 sheet 2 likhta hai wahan sheet nahi dikh raha hai plz help
ya apna email vejiye sir main workbook mail karta hoon
I have problem with 2007
when I using filter and deleting row
my some of data is delete automatically
but select the row area and right click to mouse "delete rows" options it's perfectly delete.
only select "delet" then my hall sheet is deleted.
sometimes this feature can't showing "delete rows"
please sir help me
using XP and office 2007.
select the row area and right click to mouse "delete rows" options it's perfectly delete --- is the right option as while using filters a lot of rows get hidden and you may end up deleting important data.
We will accept entries between now and June 15th. Posters will ship in July.
YESTERDAY WAS EVERYTHING OUT JUNE 30th.
Filmed primarily during the tour celebrating the 10th anniversary of our debut album, this feature length documentary, directed by our friend Matthew Mixon, follows the band as we reunite with our original vocalist Jesse for the first time since our split a decade prior. The film explores the fatal tragedy that brought the band together and follows our journey across North America as we face old ghosts and attempt to reconcile the past.
Signal Spam is a public-private partnership that allows users to report anything that they consider to be spam in their e-mail client or webmail in order to assign it to the public authority or the professional that will take the required action to combat the reported spam.
The Spam Signal reflex.
A spam report allows to collect all the technical information required for the identification of a spammer, wether the report relates to a marketing abuse or cyber-criminal spam. Signal Spam is responsible for the qualification of your report and distributing useful information to the fight against spam.
Download the plugin that corresponds to your messaging environment and install it.
Report spam from your e-mail and track developments in your personal space.
Thanks to your reports, Signal Spam collects information essential to the identification of spammers , and share them with the authorized actors able to take action adapted to each specific report.
Consult the code of ethics.
The reports provide the digital evidence investigators and public authorities need engage legal procedures, controls and sanctions against companies which send abusive marketing e-mails, and legal actions against cyber criminals.
Easy-To-Use Tools For Hard Trading Decisions.
Find what to trade, when to trade, and how to trade with signals and tools for over 350,000 stocks, ETFs, futures, forex and mutual funds.
Managing your own portfolio is easier than you think.
Create Your MarketClub Account Now.