Тёмный

Sort Data - A to Z (alphabetically) in Excel | Excel in Hindi 

Excel Superstar
Подписаться 385 тыс.
Просмотров 131 тыс.
50% 1

Sort Data - A to Z (alphabetically) in Excel | Excel in Hindi
You can sort data by text (A to Z or Z to A), numbers (smallest to largest or largest to smallest), and dates and times (oldest to newest and newest to oldest) in one or more columns. You can also sort by a custom list (such as Large, Medium, and Small) or by format, including cell color, font color, or icon set. Most sort operations are column sorts, but you can also sort by rows.
Sort criteria are saved with the workbook so that you can reapply the sort each time that you open the workbook for an Excel table, but not for a range of cells. If you want to save sort criteria so that you can periodically reapply a sort when you open a workbook, then it's a good idea to use a table. This is especially important for multicolumn sorts or for sorts that take a long time to create.
Get 100% OFF on Excel Interview Essentials course Use Coupon Code - ESSJUL20
Hurry! Only 500 Coupons are available. Click here - bit.ly/2ZwT7vZ
When you reapply a sort, different results appear for the following reasons:
Check out our 22+ hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
Data has been added, modified, or deleted to the range of cells or table column.
Values returned by a formula have changed and the worksheet has been recalculated.
www.excelsuperstar.org/2016/0...
To watch more videos visit: www.excelsuperstar.org/
To Buy a Excel Course Pen drive visit: www.excelsuperstar.org/excel-...
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar

Опубликовано:

 

3 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 55   
@ExcelSuperstar
@ExcelSuperstar 4 года назад
Get 100% OFF on Excel Interview Essentials course *Use Coupon Code - ESSJUL20* Hurry! Only 500 Coupons are available. Click here - bit.ly/2ZwT7vZ
@geetadewanmusic145
@geetadewanmusic145 2 года назад
Thank You so much sir.These command can help us to do our work in less time and accurately🙏
@kongehmireille1348
@kongehmireille1348 4 года назад
Wow that was perfect
@sandeeppandharpatte5207
@sandeeppandharpatte5207 6 лет назад
sir you are superb!!!
@subhashsemwal5785
@subhashsemwal5785 4 года назад
Thank you so muchh....aapki trick ne mujhe mere pure year ka tension khtm krwa diya..
@Ragin_Mistri78
@Ragin_Mistri78 9 месяцев назад
Thank you so much
@sandeepbharati370
@sandeepbharati370 Год назад
Best idia diye hai❤
@hemujuyal1022
@hemujuyal1022 5 лет назад
Thanks a lot sir
@user-sl1to6jc5o
@user-sl1to6jc5o 5 месяцев назад
Thanks sir
@ritusinghal4857
@ritusinghal4857 3 года назад
It's really helpful ......thx sir
@SohailAgha3
@SohailAgha3 2 года назад
Vert helpfull for me
@ArbazKhan-tf7tu
@ArbazKhan-tf7tu 4 года назад
Bohut shandaar
@ArbazKhan-tf7tu
@ArbazKhan-tf7tu 4 года назад
Very helpful
@Defenceknowledgesandy
@Defenceknowledgesandy 5 лет назад
Kiya bat hai sir...Super
@ssomshekher5561
@ssomshekher5561 6 лет назад
Thankuu sir
@rotanabantawa9478
@rotanabantawa9478 Год назад
Thankyou❤
@fatimasiddiqua684
@fatimasiddiqua684 4 года назад
Sir thank u .
@biswajeetbarik4912
@biswajeetbarik4912 Год назад
Thank you
@FaysalEasyExcel
@FaysalEasyExcel 4 года назад
excellent.
@flytohigh6867
@flytohigh6867 Год назад
Thank you 🎉
@jeetbaro3187
@jeetbaro3187 2 года назад
Thanks sir helping
@jignesh_9761
@jignesh_9761 Год назад
Thanks you ❤
@aliasgerburhanpurwala5850
@aliasgerburhanpurwala5850 6 лет назад
thanx sar bhat acch video hi awr kam ka
@joydeepsamaddar8487
@joydeepsamaddar8487 Год назад
Thanks
@rashidansari5853
@rashidansari5853 4 года назад
thnx bro
@shrawansd
@shrawansd Год назад
Thank u
@chhabiacharya4597
@chhabiacharya4597 7 лет назад
Namaste!In Ms Excel, sorting a list alphabetically in English is OK but is this facility available if the list is in a language other than English(e. g. Nepali/ Hindi)?Thanks in advance!
@shonakmdheeraj7590
@shonakmdheeraj7590 6 лет назад
Sir all video for subtotal
@nitudeb9206
@nitudeb9206 4 года назад
Sir how to make barcode scanner move automatically next column without pressing keyboard please uploaded this related vedio.
@ps_cse4773
@ps_cse4773 6 месяцев назад
When I am trying to sort , a message is displaying - 'To do this, all the merged cells need to be the same size' . How to solve this issue..??
@bhaskarmukherjee7889
@bhaskarmukherjee7889 2 года назад
Sort option k koi shortcut b tha na Sir
@vikasrajani7122
@vikasrajani7122 6 лет назад
Sir if there are both numbers and alphabets in column then how we can sort it
@dushyantraja648
@dushyantraja648 4 года назад
sir a to z wale word ko kirm se lagane ke liye yk full vedio bna do sir
@Muhammad_Sakil
@Muhammad_Sakil 5 лет назад
Formula ka sequence kaise change kare......example AA1.....AB2.....AC3
@amritpatel5278
@amritpatel5278 5 лет назад
Ms excel main ham employ seniority list kaise banate hai iske bare main batayen sir ji
@rhhvankarvankar7123
@rhhvankarvankar7123 6 лет назад
Thanking you,excel,the easy way to remember the,any subject by an alphabetically order,the 1008 name of lord vishnuji,is the longest name on the earth.please ,try to an alphabetically?
@vikasrajani7122
@vikasrajani7122 6 лет назад
They are together same column
@Kunhal_sahu
@Kunhal_sahu 11 месяцев назад
Sir agar file a to z short me save ho gayi hai aur wapas hame use wesa ka wesa karna hai to Kya karu
@riteshsingh9342
@riteshsingh9342 4 года назад
Hello sir, Sir mere ko ek sheet duplicate amount delete krni hai or wo amount negative or positive me hai. Or ye amount bhut Sare unique I'd ke against hai. Mujhe duplicate entry delete kr ke . Every I'd ke against total amount pata Krna hai .please help me sir. Jaise -4,4,,-5,5,5,
@rameshwarsharma7151
@rameshwarsharma7151 4 года назад
सर आपको प्रणाम करता हूँ.... आपकी वीडियो बहुत अच्छी है लेकिन यदि हिन्दी मे इस तरह की सूची हो तो हिंदी में अकारादि क्रम में कैसे करे अल्फाबेटिकल ऑर्डर में हिंदी के शब्दों को लिखने का कोई फार्मूला....
@zxprogaming956
@zxprogaming956 7 лет назад
So like teaching Ki Tarah Excel kaise sikhte hai A to Z pura knowledge like stitching Jaise karwate hai na waise Mujhe RU-vid se dekh kar sikhna hai ki XL chalate hai kaise kaise create Karte Hai Kaise data entry Kaise accounts clear-cut hai please can you describe
@wasimakaram4357
@wasimakaram4357 4 года назад
Mere computer me capslock on krne per bhi small letter hi type ho rha hai isko kaise thik kre
@omarczar4057
@omarczar4057 4 года назад
PASAND AYA ...
@sahiljagtap3033
@sahiljagtap3033 3 года назад
Word me alfabet kaise kare
@gautamlahare5766
@gautamlahare5766 4 года назад
sir date ko alhabet kaise krte h
@ar11sports70
@ar11sports70 3 года назад
Hii
@niakhan5383
@niakhan5383 5 месяцев назад
Sort data - A to Z ko kese unsort kare jese pehla tha?
@nileshjain2982
@nileshjain2982 4 года назад
agar kisi column ke akhri word se sort karna hai to kaise karenge
@sahiljagtap3033
@sahiljagtap3033 3 года назад
Word Marathi me alfabet kaise kare
@shivakantsingh4489
@shivakantsingh4489 3 года назад
Sir agar hindi word ko isi tarah karana ho to kaise kare
@sonugupta-ix3od
@sonugupta-ix3od 4 года назад
Sir Hindi list ko kaese alfabet Kar ke nikale
@Rayatchishala
@Rayatchishala 3 года назад
मराठी alphabetical ऑर्डर करता येते का
@debasishdas441
@debasishdas441 4 года назад
very very poor knowledge
@akshayavchar4349
@akshayavchar4349 5 лет назад
Thank you sir
@RahulSharma-dy1oz
@RahulSharma-dy1oz 2 года назад
Thank you
Далее
MS Excel - Filtering Data
7:10
Просмотров 1,9 млн