Top Secret trick how to hide formula in excel || Hidden tips & Tricks to make you excel expert

you can learn Top Secret trick how to formula in excel, this is hidden tips and tricks which will make you excel expert.
you can super hide your excel formula which in few simple steps. when i applied formula in my excel 2007 and excel 2013 i tried to hide formula so that no one can edit my excel sheet, but i was not able to achieve that step . but from now every one can hide there formula and only display values.
this is very nice excel trick you can use in your daily excel work.
you can even share with your friends how to hide formulas in excel without any VBA coading.
this trick will surely make you excel expert, hope you enjoy the video
#HideFormula
#Tipsandtricksinexcel
#Excelinhindi
download link :- drive.google.c...
---------------FOLLOW ON---------------------
Facebook :- / excelworldofknowledge
Twitter - / sohandey3
KZbin- / @gyanontube
Follow me on Instagram :- / gyan_on_tube
______________________
How to Use concatenate in excel || Replace vlookup and IndexMatch formula ⚡⚡ || Tutorial in hindi :- • How to Use concatenate...
New vlookup formula in excel || textjoin function in excel || index match function in excel :- • New vlookup formula in...
indexmatch excel || How to use index match formula from Basic to advance. :- • index match excel || H...
combination formula || How to make big formula in excel in hindi || combined variance formula :- • combination formula ||...
Xlookup for Free || New formulas for free || Xlookup and Filter formula in hindi :- • Xlookup for Free || Ne...
compress excel file || reduce excel file size || how to reduce excel file size in hindi :- • compress excel file ||...
How to use Xlookup in excel 😮 || xlookup formula in hindi 😮|| vlookup formula in excel :- • How to use Xlookup in ...
Array formula excel || array function in excel || Excel Vlookup ❌|| index Match Excel ❌ :- • Array formula excel ||...
xlookup in excel in hindi || Xlookup A to Z in details || New Xlookup with Search Mode :- • xlookup in excel in hi...
Xmatch formula in excel || Xmatch formula in excel in hindi || Xmatch with Index formula:- • Xmatch formula in exce...
filter formula in excel || how to use filter formula in excel in hindi 😮 filter formula in hindi :- • filter formula in exce...
Top 10 excel formulas 😮|| excel formulas and functions || excel functions and formulas :- • Top 10 excel formulas ...
How to use excel unique function || Excel unique formula in hindi || Remove duplicate values:- • How to use excel uniqu...
Drill Down in Pivot table excel || Classic Pivot table view in hindi :- • Drill Down in Pivot ta...
3D Pivot Graph in excel in hindi || Lean Pivot from beginner to advanced || lean pivot table:- • 3D Pivot Graph in exce...
excel slicer || how to use pivot table slicer || slicer in excel 2007 and above :- • excel slicer || how to...
advanced pivot tables || advanced pivot table excel || IF formula in Pivot :- • advanced pivot tables ...
Sort formula in excel || array formula in excel || how to use sort formula in excel :- • Sort formula in excel ...
interview questions and answers || interview questions || advanced Excel || Excel Interview 7 :- • interview questions an...
advanced excel :- Top 5 Advanced excel and word tips and tricks :- excel formulas in hindi :- • advanced excel :- Top ...
Job Interviews question !! Excel interview question in Hindi !! Job Interviews question part 3 :- • Job Interview Question...
Job Interviews question !! Excel interview question in Hindi !! Job Interviews question part 2 :- • Job Interviews questio...
Excel Interview Question 😮 MIS Interview Question in Excel in Hindi 😮 Excel Interview :- • Excel Interview Questi...
Interview question how to get first and last name in excel 😮 First and Last name in Excel in Hindi. :- • Interview question how...
Serial Number auto populate 😮सीरियल नंबर औटो पॉपुलटे कैसे करें 😮rows formula to populate serial no :- • Serial Number auto pop...
How to Change Excel background color In hindi ! office 2019 :- • How to Change Excel ba...
Advance Excel - Top 5 Excel Time Saving tricks 2018-2019 :- • Advance Excel - Top 5 ...
How to Separate all text available in a cell :- • How to Separate all te...
One Vlookup Multiple Worksheets :- • vlookup in excel !! बह...

[@abhipragya348]

इतना शानदार ट्रिक इतना आसानी से कभी किसी ने नही बताया होगा यु आर रियली ग्रेट👌

[@GyanOnTube]

Thank you so much 😊

[@SanviPatil2019]

kya jabardast trick batai sir apne..mast

[@GyanOnTube]

Bahut bahut sukriya vikas ji aapka...

[@arunkumarsinghark3024]

अद्भूत सर जी 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

[@GyanOnTube]

Thank you so much

[@atulverma05]

Excellent.. Explanation made is very easy... It is very useful too..

[@GyanOnTube]

Thank you so much

[@jsmundagod]

WODERFUL

[@GyanOnTube]

Bahut bahut shukriya 🙏🙏

[@onlyexcel493]

बहुत बढ़िया sir

[@GyanOnTube]

Bahut bahut sukriya Nileshgiri goswami ji... video ko share zaroor karna aapne friends ke sath..

[@onlyexcel493]

Definitely

[@GyanOnTube]

@@onlyexcel493 sukriya

[@pramodbhavsar4488]

Very nice tecnic sir

[@GyanOnTube]

Pramod bhavsar ji aapka bahut bahut sukriya..keep supporting

[@manojsable8482]

imp video sir nice

[@GyanOnTube]

Keep sharing keep learning

[@rajeevgosavi4514]

Truly appreciate your videos as they are simple to understand. Sir could you please tell how to unhide the hidden formula

[@GyanOnTube]

Thank you Rajeev, you can simply CTRL + ~

[@sunilkumarbali4779]

Superb sir

[@GyanOnTube]

Thank you so much Sunil Kumar ji.... keep sharing keep supporting

[@rohitmeena6368]

nice sir maza aa gaya

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@kishorpanara4191]

Good job sir protect sheet bina formula hide kar sakte hai

[@GyanOnTube]

Kishor Panara ji..ha kar sakte hai supper hidden karke vba ke through.

[@venkateshkulkarnilaxmanrao2358]

very good way

[@GyanOnTube]

Thank you so much

[@piyalighosalchakraborty8632]

Mind blowing sir

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@manojitkundu5201]

You are great in presentation ....good job boss....

[@GyanOnTube]

Thank you so much..do not forget to share this video for better reach

[@nareshbhagmal]

Superb Bhai

[@GyanOnTube]

Naresh Mawana ji aap ka bahut bahut sukriya..

[@ghumansaab2314]

very good way for hide the formula, Interesting ❤️👍

[@GyanOnTube]

Thank you Ghuman ji.. share the video with your friends as well

[@ghumansaab2314]

@@GyanOnTube ofcourse brother why not 👍

[@GyanOnTube]

Thank you

[@alpanadey8859]

Truly appreciate..your videos are out of the box.. superb 👍👍

[@GyanOnTube]

Thank you so much...🙏🙏🙏

[@amoljagtap3083]

Grt Trick 👍👍

[@GyanOnTube]

Thank you so much

[@EasyExplain]

Good Job. As always. 👍🏻

[@GyanOnTube]

Thank you Akash..

[@MukeshKumar-fd3up]

Pp

[@sanofamotivation]

Thank you soo much really helpful. 👍

[@GyanOnTube]

Thank you so much

[@rajpalthakur8397]

All PowerPoint ka ek advance video banaye.

[@GyanOnTube]

Nice thought Rajpal Thakur ji..sure we will work on it soon..

[@abhishekdivedi1940]

Good job

[@GyanOnTube]

Thanks

[@surender665]

Sir sumprodut advance pe or multiformulas kaise combine krte h plz in pe video bna do

[@GyanOnTube]

Surender kaushik ji aap koi bhi formula combined kar sakte hai bus logic clear hone chaiye..aap niche wali video dekh kar formule combined kar sakte hai.. kzbin.info/www/bejne/nIPEq5dpeqeeY9k

[@riturautela7331]

Very very nice video 👌👌..

[@GyanOnTube]

Thank you ritu.. please share the video with your friends and family

[@pankajnautiyal2156]

Supper sir..

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@karansingh-ny6qp]

Very helpful thanks for sharing 💯😍

[@GyanOnTube]

Thank you so much..🙏🙏

[@YourUtpal_007]

Thanku sir jee

[@GyanOnTube]

Thank you so much

[@miteshpatel7101]

Ha sir aek video colour filter no fill filter ka banavo na sir

[@GyanOnTube]

Sure point noted Mitesh Patel ji..bahut jald leke aata hu iske uper ek video

[@samd9526]

Thanks for sharing the video, may I request you to share a video on how to make numbers to text formula.

[@GyanOnTube]

Its very simple in next column just put ' and then concate both..your all numbers will be converted to text

[@samd9526]

@@GyanOnTube Thanks for your prompt reply, i can not understand what you have said. Could you please show me an example?

[@amdarus2587]

great trick.but i need to lock and hide formulas without protect the sheet

[@GyanOnTube]

Then we can do that through macro..else no other option

[@hemant.rayakwar46]

👍

[@GyanOnTube]

Thank you Hemant ji..aap logo ki support ki bahut zarurath hai..keep supporting

[@miteshpatel7101]

Amazing sir

[@GyanOnTube]

Thanks Mitesh patel ji..aap logo ks support chaiyee.. video ko aapne friend ke sath share zaroor karna..

[@onlyexcel493]

Good job sir

[@GyanOnTube]

Thank you Nileshgiri goswami ji..saw your msg after long time..

[@miteshpatel7101]

Sir advance filter me colour filtar or no fill filter ke se hota he

[@GyanOnTube]

Mitesh patel ji mene is uper ek video prepare kar rakhi hai... Agar aap aur advanced mein seekhna chate hai to for ek video prepare kar sakta hu

[@hemanthkumar8187]

Thanks

[@GyanOnTube]

Thank you so much

[@SanviPatil2019]

i love this video

[@GyanOnTube]

Vikas patil ji..aap ke comment ke liye bahut bahut sukriya..keep supporting and keep sharing please..aap logo ki support ki bahut zarurath hai

[@sunilkumarbali4779]

Please make video hide unhide and unprotect

[@GyanOnTube]

Thank you for your suggestion ..i will definitely make video on hide and unhide ..

[@onlyexcel493]

Sir हो सके तो kuch macro ke video भी banaiye

[@vimaldewangan9309]

Xlookup ke sath multiply & iferror kaise lagaye

[@GyanOnTube]

XLOOKUP mein iferror inbuilt hota hai

[@vishu001ful]

Nice video, but when i delete data in formula cell shows #DIV/0" etc, how to avoid this ?

[@GyanOnTube]

Are you deleting all cells or only one cell

[@rakeshmathur5560]

Does not work on dynamic array tables.Recalculations also stop.

[@ravindrapal2137]

Yes

[@GyanOnTube]

Video published..you can have a look

[@kavitanegi4719]

I am able to make changes on the data but can't apply filter option, as sheet is protected. Is there any other way to hide formulas so that I can use filter option as well?

[@GyanOnTube]

Hi kavita, we can not apply Filter on share basis...we can do the same practice on teams sharing file..

[@shaliniagrawal9554]

sir ek result sheet hai pass fail mai mujko Student jo ek se jyada Subject mai ab sent hai to pass fail kese bataye

[@GyanOnTube]

If mein and condition laga do

[@omimp1285]

Sumifs formula with different different coloum

[@GyanOnTube]

Mene iske uper ek video bana rakhi hai aap wo dekh sakte ho

[@spreadingsmiles9413]

WHAT IF WE HAVE TO SHARE THAT WORKSHEET...AND WE DUNNO WANNA SHOW FORMULA....?

[@GyanOnTube]

This way he can see the formula but can not edit..if you still wanna hide your formula you can apply super hidden open in vba...

[@horilalpal9097]

How to re-adit the hidden formula. Please share the trick

[@GyanOnTube]

For re-edit we need to apply same steps angain

[@horilalpal9097]

@@GyanOnTube thanks

[@satyajitchatterjee3713]

SIR, Comma , 2, 0 ka matlab kya hain please elaborate kijiye PLEASE..

[@GyanOnTube]

2 ka matalab kaunsa column... And 0 ka matalab exact match

[@satyajitchatterjee3713]

@@GyanOnTube Thank You Sir...🙏

[@arunkumarsinghark3024]

सर मेरी एक excel query है मैं आपसे कैसे connect कर सकता हूं कृपया मार्गदर्शन करे l

[@GyanOnTube]

Please check complete video..you will get to know

[@SRCOMPUTEREDUCATION]

Sir aa konsa green screen use krte ho

[@GyanOnTube]

Green screen to sabka same hota hai but light ka fark parta hai..

[@SRCOMPUTEREDUCATION]

@@GyanOnTube so sir please Light ke bare me b btaye na

[@GyanOnTube]

Aap iske liye KZbin mein video dekh sakte hai..mein yaha par light aur green screen ki information wali video nhi banata..hope you understand

[@SRCOMPUTEREDUCATION]

@@GyanOnTube yes sir apne konse lights aor kese kiya he wo bta denge to acha rhega

[@GyanOnTube]

Ok iske liye mein ek behind the scenes ki video bana Dunga

[@praveenkumarkharikghare1664]

सर इससे फार्मूला हाइट हो जाता है पर जब हम हेडर पर फिल्टर्ड का ऑप्शन चूज करते हैं तब फिल्टर ऑप्शन वक्त नहीं कर पाता है Plz Help

[@GyanOnTube]

praveen ji vese mene ye try kiya tha..mujhe esaa koi problem nhi aai...

[@mahajann.g.6705]

सर यह सब गुगल ड्राईव मे कैसे करे

[@GyanOnTube]

Means

[@shaliniagrawal9554]

hi sir

[@GyanOnTube]

Hi

[@ajitgurav3545]

यही फाईल अगर गूगल शीट मैं ओपन की जय तो फॉर्म्युला शो करता है हार्ड लॉक कैसे लगाये

[@GyanOnTube]

Uske liye mujhe check karna hoga..

[@atulshukal4072]

अगर यह टेबल हे की A1 >=6.00 B1 >=8.90 = 650 A2 >=6.00 B2 >=8.70 =625 वैसै फोर्म्युला कैसे होगा चाहे ईन्डेक्ष मेच या वीलुकप यही विडीयो बना जाय साहेब

[@GyanOnTube]

Iske uper mene video bana rahi hai hai..aap jaake check kar sakte hai

[@vinodgohil4556]

Vlookup batan sir

[@GyanOnTube]

Sure

[@ajsamota]

Isse unhide kaise kren

[@GyanOnTube]

Same option ko repeat karo

[@silvesteritur822]

how to hide formulas in excel without sheet protection

[@GyanOnTube]

That is again a different workaround..

[@giridhariprasad4088]

Who knows this trick, he can reverse these actions. this is not a permanent solution .

[@GyanOnTube]

If you want permenent solution..you can apply vba coading and then hide...no one will able to break...

[@puspenderkumardubey1732]

How to unhide

[@GyanOnTube]

Repeat the same step..

[@puspenderkumardubey1732]

@@GyanOnTube thanku sir