Excel Goto Special | Selection tips to use Goto Special options in Hindi | Fill Blank Tricks

Learn how to use Excel goto special option step by step.How to Fill blank tricks and Ctrtl Enter
1. How to select comment , Constants and Formulas in excel
2. How to select blank and fill blank cell using ctrl enter
3. How to select current region , current array and objects in excel
4. Row differences , column differences , precedents and dependent in excel
5. How to select last cell,visible cells only , Conditional formats and Data Validation in excel using goto special
Download the Practice Workbook Direct Link
drive.google.com/file/d/1dwBa...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#excelgotospecial #gotospecialinecel#Innozant #exceltipsandtricks #ctrlginexel

[@MrSanjogbaral]

Your teaching has taken my Excel skills to next level. Thanks a lot.

[@Innozant]

Thanks Dear🙏❤️Happy Learning and thanks for supporting.👍🙏

[@user-xi1iw5qz5r]

the way you are adopted for teaching is so amazing. i salute you

[@shahzadsiddiqui5117]

this one i needed the most, thanks as always...!Respect

[@chanchalsharma2456]

One thing I noticed Aap jo b topic lete ho usko briefly pdate ho 👌👌awesome videos U tube pr kisi b topic ko briefly n pdate sabhi teachers👍 Keep it up sir, Thanks sir, good way of teaching 🙏😊😊

[@Innozant]

Thanks Chanchal ❤️ Aapke valuable feedback ke liye..Meri humesha koshish rehti hai ki complete content deliver Kru na ki youtube par views paane ke liye Kuch bhi Bana Doon.Thanks Aapke appreciation ke liye .humesha mein best content deliver krne ki koshish krunga.👍🙏❤️

[@Innozant]

Thanks Chanchal ❤️ Aapke valuable feedback ke liye..Meri humesha koshish rehti hai ki complete content deliver Kru na ki youtube par views paane ke liye Kuch bhi Bana Doon.Thanks Aapke appreciation ke liye .humesha mein best content deliver krne ki koshish krunga.👍🙏❤️

[@sandeepaswal8944]

Sir That's a super trick!.. I learnt something new today. You are a very good instructor; very passionate. Made my life easier.

[@Innozant]

Thanks Sandeep for this wonderful feedback..M happy for you.Dedicated learner you are.👍🙏❤️

[@The-Fronted]

Ache teacher ki student kadr nahi krte. Itna kam Subscribe You are the best sir

[@Innozant]

Khan Sahab ..Logon ko entertainment chaiye hota hai kahan logic le apna dimag kharab karna..😄❤🙏Thanks fpr your love and kind support dear

[@Anony15100fd]

Sir your explanation is very nice and smooth and easy to understand subscribed

[@Innozant]

Thanks

[@PankajSharma-em2vn]

Sir u have Great knowledge of excel

[@jattsahab2102]

Very useful video

[@subhashchandrabaghel8158]

Sir, knew how use of GOTO option but really add skill in this pop up Thanks sir ji Wish you all best

[@Innozant]

Thanks Subhash.. Recommend you to watch Videos step by step from playlist -Basic Excel to adv.🙏♥️

[@RA-rh5lb]

Good Morning Sirji, Ek saath go to special maine pahele baar sikhi.. thanks

[@Innozant]

Thanks dear

[@imvny]

Your teaching style is very good. 💞💞

[@Innozant]

Thanks

[@atulshukal4072]

बढ़िया वर्क साहेब आभार

[@Innozant]

Thanks Atul Ji❤️🙏

[@manjharvalley8047]

Thank you so much sir

[@goodness377]

Excel guruji thank you very much, apke video se mera Ek bht bara problem solve ho gaya, jese india to Canada wala

[@Innozant]

Thanks Sinha sahab..happy learning dear

[@satishojha6240]

Awesome explanation I realised improvement day by day in excel thanku very much sir good night 🙏🙏🙏

[@Innozant]

Thanks Satish Ji,Hope you like the Goto Special concept.GN🙏❤️👍

[@shashijha682]

Hi Satish ji

[@hemantgusain1260]

Thanks you sir for explain go to special so deeply.

[@Innozant]

Thanks Hemant 🙏❤️👍Happy Learning

[@Karma4Good]

Your teaching technic very easy to understand thank u.

[@Innozant]

Thanks dear ..God bless you

[@moveon001]

teaching skills wow

[@bhoopendraraghav9781]

Really hat's of u sir...

[@Innozant]

Thanks Bhoopendra

[@sandipsingh8377]

I plan to watch all your videos

[@Innozant]

Thanks .. Start your Learning journey from playlist Basic excel onwards step by step

[@user-bu1fc8pq7p]

Thank you sir ❤

[@vikasgawaria5330]

Sir namaste nice video thankyou so much,sir Excel ke baad data science ka complete package upload kar dijiye please

[@rajeevpathak6172]

Very interesting and useful Sir

[@Innozant]

Thanks 👍❤️

[@manjharvalley8047]

super video sir jee..your voice is too sweet

[@Innozant]

Thanks Manjhar ..Happy learning

[@ramseshu110]

Excellent teaching sir

[@Innozant]

Thanks Ram🙏❤️

[@contracts6521]

Good Show

[@AnitaSingh-mk3gi]

Video is very useful

[@Innozant]

Thanks Anita ji❤️

[@laisonkc]

Sir, How we can do mail merge with personalised attachment. Pls help.

[@pa2happiness13]

👌🏼

[@samatsekh6063]

Every time getting to learn new things.

[@Innozant]

Thanks Samat🙏❤️

[@MohitNCR]

THANK YOU SO MUCH SIR

[@Innozant]

Thanks Mohit Ji,Hope you like the Goto special selection option.🙏❤️

[@pareshparikh7944]

Salute sir

[@Innozant]

Thanks Paresh 😀🙏❤️

[@arslantahir1708]

thanks dear :-)

[@gagansingh3481]

Hi sir facing issue on one excel problem could you please share of ID I will share the problem with you ....please provide the solution on it ....

[@muhammadhuzaifa4521]

Hi Sir Goto special me reference kis trhn pass karty hn? Sheet pr move hony ky liye

[@sonuyadav7518]

Thanks sir

[@Innozant]

Thanks dear

[@mohitchauhan7808]

👍👍👍👍

[@yourchannel6024]

Dear is there any formula that gives me laptop or cell registration number. By this formula any other device not use my excel file.

[@kkrcreationstatus6583]

👍👍👍👍👍

[@raufwaheed2955]

Go to special did not select blanks after last text either we have to type a additional character at last

[@meriawaazhindi5217]

❤️❤️❤️❤️❤️

[@vijaysahal4556]

nice sir 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻

[@Innozant]

🙏❤

[@user-lt3ct6zq1k]

it helps but why you left constant option and directly go to formula options in go to specials. i have confusion with logical and error in constant.

[@pawanmehta7651]

My question is that we made a file.in this files we created some name and their value.now I want to insert blank line in the end of every line.how we can it?

[@aadesh6122]

🙏🏻🙏🏻🙏🏻👌🏻👌🏻

[@virendersroha1754]

Koi special word ko serch kr skte h kya kse #N/A

[@atulpathak1045]

Divide multiply options please cover

[@ghanshyamayodhyaprasadgupt727]

Super sir ji

[@Innozant]

Thanks Ghanshayam Ji

[@ghanshyamayodhyaprasadgupt727]

@@Innozant welcome sir ji But really thanks to you for your support by you tube free video for learn👍

[@ghanshyamayodhyaprasadgupt727]

💐💐💐💐

[@Innozant]

Seekhte rahiye ,Humesha awesome content milta rhega aapko

[@SanjayKumar-uw9kn]

When I asked it in coaching they said that forget it, nothing special. 😂😂😂 Kash ap mujhe pehle mil Jate Ab lag raha hai me bhi MIS Interview crack kar paunga just because of you sir Thanks a lot.

[@Innozant]

Don't worry Sanjay..Jo beet gyi so baat gayi..abhi Jo apke paas hai wo hai Aapka mehnat..krenge to jaroor succeed.Beat of luck.

[@myclass4006]

Nice

[@Innozant]

Thanks

[@shivamonestop380]

Wow

[@Innozant]

🙏❤️

[@naeemulhassan1426]

Sir. Please launch a tutoriel on short keys of ms excel and also tell the when should be used the ctl and enter key and when use contl shift enter and when should b use only enter key also tell on which type of windows ur tutoriel of sum maharaj is work. I use window 8 it does not work for sum maharaj tutoriel tips. Regards.

[@Innozant]

Thanks Naeemul for your valuable opinion, in case of standard function use Enter,When there is bulk array use ctrl+enter and if you want to execute single array function then ctrl+shift +enter.. no issue will make more videos of shortcut dear

[@Anand1998_]

Sir date , week, month,year se related question nhi aate i mean use krna nhi ki kaha pr kasse use kre....

[@shrikantbadge3978]

INNOZANT तो ग्रेट हैं जी Deepak Sir की भेंट हैं जी Excel भरोसे मेरा पेट हैं जी Deepak Sir तो ग्रेट हैं जी

[@muhammadaamir4416]

Indirect function par video banayay

[@Innozant]

Aamir Sahab ye kehne ki jrurat hi nhi h apko🙂Choose finished ab indirect phir offset.Have patience 🙏❤️

[@dharminderkumar9370]

Sir mai ek excel se copy kar ke dusre excel ke paste karta hu to blank past Hota hai please solve

[@rahulrakshe1988]

video is nice but pl update separate practice file link in description bcoz not able to find file in all folder drive

[@Innozant]

Link broken ho gya hai...We need to fix all video link..will update it soon

[@satscoolstyle4210]

We can also go with f5

[@Innozant]

Yes..very true

[@Delightmotion1.0]

Sir tally erp 9 par videos banay❤️

[@Innozant]

Tally main nhi padhata hu dear.. Data Analytics & Data Science mera field hai.. Haan kisi dusre trainer ke videos aayenge channel par

[@manojvaghela5727]

Tz

[@gantisn1701]

good after noon i tried to use go to but the special command is not visible how to show please help thanks in advance

[@Innozant]

Which version of excel you are using now

[@vaijeenathsable6572]

Plz sir jaldi batayega,,,,,,

[@Innozant]

Aap kya chahte hain krna ye btaiye.as answr to apne khud hi bta diya h dear

[@mayankbhatt1790]

Your teaching is another level but I have a doubt that u r using if formula in this that is also a logical function but why don't show in logical ??? 🤔🤔🤔🙏🙏👌👌💯

[@Innozant]

Didnt get you mayanak..Offcourse uf function is under logical function category

[@mayankbhatt1790]

@@Innozantthank you for your precious time ♥️💕💗 jb ham if use kr rahe the formula pe toh go to special usko logical Kyu nii Bata Raha hai vo if function formula ke andar usko text Bata Raha hai jbki usko logical batana chahiye

[@Innozant]

kyu batyega text if formula is logical..?

[@choudhary2033]

Visible cell ka bhi bahut use hota hai Filter karne pe.

[@Innozant]

Yes Kundan ji..❤❤

[@karankapoor200]

sir Excel ma all function KO Explain home intert all function🙏🙏

[@Innozant]

Thanks Karan 🙏❤️

[@bishtlokesh1297]

Operation of go to

[@Innozant]

Thanks Lokesh.Hope you like it🙏❤️

[@ALOKSingh-ee2zd]

Kya aap online class karwate h

[@Innozant]

Yes..innozant websitw visit kriye

[@ghanshyampatidar6016]

Sir एक सेल को छोड़ कर एक सेल में कॉपी कैसे करते है फिर खाली सेल में दूसरा डेटा की कॉपी कैसे करते हैं

[@vaijeenathsable6572]

Go to Option me jake, agar muze filter lagake only visible data ko paseSpecial karna h to kaise kare

[@Innozant]

Answer to apne khud hi bTa diya hai dear..visible cells only bus check kr lekn uske baad copy and paste

[@vaijeenathsable6572]

Nahi ho raha h

[@vaijeenathsable6572]

Please jaldi

[@vaijeenathsable6572]

Maine Vlookup mara h, jo values male h usko filter me jake check laga ke filter kiya aur usko find values ko paste special karna h, lekin nahi ho raha h

[@bhavyadudeja5969]

I am unable to find and download this file please share the path thanks

[@Innozant]

It is available under master assignment main link folder

[@bhavyadudeja5969]

@innozant sir please share the path so that I can download this file

[@Innozant]

@@bhavyadudeja5969 you may find it in basic excel folder -other option

[@bhavyadudeja5969]

@@Innozant Sir can you please name the folder name, this will help me in locating this fast

[@bhavyadudeja5969]

Thanks you so much I am able to locate the file thanks for your prompt response and support

[@Yuvasena]

F5 dabANE SE BHI JAYENGE

[@Innozant]

Ys

[@bilalahmadzai7844]

YOU DID NOT TELL ABOUT THE SAME OF DATA VALIDATION

[@Innozant]

Didn't get your query Bilal

[@nishachauhan9103]

Poori vedio धुंधली रही है शुरू से अंत तक

[@Innozant]

Vido dhundhli nhai hai Nisha..Aaj aapka internet bht slow chal ra hai isliye dhundhli dikh rahi hai😀

[@siddhudhanshetti7530]

Thank you so much sir

[@anjlim8930]

Thank you Sir

[@Innozant]

Thanks Anjali❤️