2 Amazing Tricks to Fill Blank Cell in Excel with Above Value | Hindi

Teach to Each video on How to Fill Blank cells with above value in Excel in Hindi. The video is all about How to fill blank cell in excel | Hindi.
For an Example your sheet has a lot of blank cells under the heads in a particular column. You want to pick up these blank cells from the range, select and fill it with the above value. Of course, you can select each blank cell one by one manually, which may be time-consuming But Here I am introducing a couple of tricks to quickly select all blank cells using Go-To Special and fill these up with their headers.
Here I am teaching you two ways to fill blank cell in excel :-
1) With the use of Go To Special.
2) With the use of IF and ISblank Formula.
It is a very difficult task to anyone. If you are really interested to learn this trick then this video never lets you down. On youtube, only just few videos are available on how to fill blank cell in excel in hindi.
It is humble request to you. Please subscribe my RUclips channel by click on this link
/ teachtoeach
Some popular videos-:
1) Ache Vyaavhar Ka Fal | अच्छे व्यवहार का फल - • Video
2) Magic Trick - How to Find any Position of Space or Character in Excel - • Magic Trick - How to F...
3) Motivational Video for Students | अगर CBSE UP Borad Exam में फेल हो गए तो इस वीडियो को देखें - • Video
4) What is Objects Methods Properties in Excel VBA in Hindi | Part 4 - • What is Objects Method...
5) How to Create Class Intervals Auto Fill List in Excel in Hindi - • How to Create Class In...
6) Excel VBA Editor Tutorial in Hindi - • Excel VBA Editor Tutor...
7) Nested IF Formula in Excel in Hindi - • Nested IF Formula in E...
8) How to Record Macro in Excel in Hindi - • How to Record Macro in...
9) How to make Paytm QR code in Excel in Hindi - • How to make Paytm QR c...
10) Excel VBA in Hindi | Excel VBA Tutorial in Hindi - • Excel VBA in Hindi | E...
11) IF Formula in Excel Hindi IF Function in excel - • IF Formula in Excel Hi...
12) How to Find Duplicates Using Vlookup Formula in Excel Hindi - • How to Find Duplicates...
13) Reverse Name in Excel Hindi - • Reverse Name in Excel ...
14) How to split middle name in excel in hindi - • Split Middle Name in E...
15) Fill series option in excel - • Fill Series in Excel i...
16) How to split first name in excel - • Split First Name in Ex...
17) How to Count Length of All Character in Excel Hindi - • How to Count Length of...
18) Excel Interview Questions | MIS Interview Question | Excel in Hindi - • Excel Interview Questi...

[@GopalSingh-dl5wj]

Bet needful thi mere liye bht din se youtude ye trick search kr rha tha ab mili
Its best for me

[@TeachToEach]

Welcome Gopal

[@austindean9274]

Excellent your teaching method is so good

[@RudrakshiSinghAdm]

thanks bhai apne problem solve kar di, isi baat par aapko ek like

[@TeachToEach]

Welcome

[@rohinpal9752]

Hi tech to each sir I am really thankful to video

[@TeachToEach]

Welcome Rohit

[@user-lh3wc8ho7i]

Thanks a lot, You made my work very easy.

[@TeachToEach]

Glad to hear that

[@ThakurVickybisht]

Thank U So Much Bro Help Ke Liye ❤

[@yakshvlogs1675]

Great, Keep it up, Nayi video banate raho excel pe.

[@simplysagar2688]

Thank you...Thank you....Thank you....Mere pass 40000 thousand rows ka data hai....mera kitna time save ho gaya ...Just awesome😘😘😘😘

[@nbvoice1]

This trick make me easy to work..............save lots of time ...................thanks again

[@puneetvij8433]

Ashish Sir,
कभी कभी आते हो मगर genuine problem का solution लाते हो | ; )

[@TeachToEach]

Thanks for the Comment Puneet Bhai

[@sachinsolanki5639]

Superb trick

[@TeachToEach]

Thanks for the comment Sachin solanki

[@amitthesinger]

Go To Special trick is awesome

[@rajnadeem8533]

Thanks sir 1st one easy

[@MithleshKumar-qf3hk]

Sir ji kya baat hai topic bahut majedar tha

[@TeachToEach]

Thanks for the Comment Mithlesh Bhai

[@pabitrasahu6631]

Best video....

[@TeachToEach]

Thanks for the comment Pabitra.

[@sibajipatro1282]

Thanks if very helpful to me

[@SanviPatil2019]

Wa..bahot hi maja aya ye formula se

[@TeachToEach]

Thanks for the Comment Vikas Bhai

[@poojachoubey758]

Great sir

[@TeachToEach]

Welcome

[@PoonamSharma-nw8jt]

And thanks sir.

[@TeachToEach]

Thanks Poonam

[@navikaran1]

Sir very nice video

[@TeachToEach]

Thanks for the comment.

[@VIJAYSINGH-vj1eh]

Super for gst R2A data making.. Thanks for making wonderful.. Video

[@TeachToEach]

Thanks for the comment Vijay Ji.

[@doba4561]

Amazing man.. My friend was struggling with this for long time 👌👌👍

[@TeachToEach]

Welcome

[@srsandeepsinghnegi]

Awesome video

[@za2489]

Thanks a lot sir... Super... This trick save lots of time for me... Thanks again

[@TeachToEach]

Welcome Bhai

[@sateeshyeluri9866]

Nice trick

[@TeachToEach]

Thanks Satessh

[@MAFIAOFHARYANA]

nice video bhai

[@TeachToEach]

Thanks

[@flyingtechno3752]

Thanks for quick found

[@TeachToEach]

Ur welcome

[@hrentertainment6385]

Thanks yar bhai....Very important topic for me

[@TeachToEach]

Thanks for the Comment Hemant Bhai

[@chenrajbanshiwal3512]

Very nice sir g

[@rajeshkumarjha7306]

Thanks bruh.

[@devendrasharma8796]

Nice...

[@TeachToEach]

Thanks for the Comment Devendra

[@harkeshsharma3264]

Great, I was aware about the 1st way, but thanks a lot for 2nd method. 👍

[@lalitgarvargarvar4536]

Thabkyou sir

[@balwinderbanwala1947]

Sir gud trick

[@TeachToEach]

Thanks

[@raginijha7043]

Superb

[@mohit11931]

THANKS FOR THIS TRICK

[@TeachToEach]

Welcome Mohit

[@ajayaccountant8227]

Great

[@Shorthandwithsunitainm.v.3]

Nice tricks

[@shobhapanwar2451]

Nice Video

[@crrajesh143]

Thanks

[@vipinkumar-ui9jd]

Well done Ashish bro it is workable

[@TeachToEach]

Thanks for the Comment Vipin Bro

[@exploringearth1291]

Useful

[@ubaid40]

Excellent.. specially formula...

[@TeachToEach]

Thanks for the Comment Ubaid bhai jaan

[@AwadheshKumar-hv6em]

Very good solution

[@TeachToEach]

Thanks for the Comment Awadhesh

[@BilalKhan-su8xc]

Because of this. I was stuk in my office
So thank you so much🤝👍

[@vivek_01]

thanks for sharing this trick.. 👍

[@TeachToEach]

Welcome Bhai

[@entiredworld255]

Formula se Value banane ke liye ek shortcut hai..... ctrl+alt+V value wala pop open ho jayega......

[@TeachToEach]

I am using Alt E S V for the same bro

[@ashish803922]

Awesome trick bro... Me also ashish

[@TeachToEach]

Oh....n thanks

[@Narendrakumar-ho5oz]

It's very helpful....great job Ashish

[@TeachToEach]

Thanks for the comment Narendra.

[@Vishal80196]

Dear ashish, kya ye trick or method pivot lagane k baad bhi kaam karta hai..??

[@khalidalisubhanallah2947]

Thanks Sir g nice video

[@TeachToEach]

Thanks for the comment.

[@souravsharma8485]

2 nd method is more useful because of its universal application in open office

[@banglainfo9429]

Wow. Finally got the solution

[@mrmrsrajuvishuvlog5727]

Nice

[@MindbenderTechnical]

Really it helped a lot 🥰🥰
Nice 👏👏

[@bikramaggarwal4900]

waaoo, super video. i really want this formula. One more problem. we have large data of receipts. each day we have around 30 receipts i. e. 30 receipts in one day and 900 receipts in a month. But we want only those receipts between two dates like 10 april to 16 april. With filter option we can easily find out that date but we need to use formula. Bcoz i am working on a mini program, but hang at this point who to filter data between two dates. I am using office 10

[@RohitKumar-uy7cx]

Gajab hai Ashish bhai

[@TeachToEach]

Thanks for the comment Rohit.

[@arijeetkumarsharma226]

Superb.

[@TeachToEach]

Welcome

[@LordTiago]

Thanx

[@TeachToEach]

Welcome

[@Hammy41898]

Thank you.

[@TeachToEach]

Thanks for the Comment Hammad khan

[@vishalchandrani2962]

Nice n informatie video...Can you please upload or send video on how to find out percentile formula for school result in excel.. as in built formula doesnt working ... Hope of your reply... Thanking...

[@spuneet156]

It is helpful

[@TeachToEach]

Thanks for the Comment Demon

[@himanshubhatia4028]

Thank you sir👍👍🙏🙏😎😎😎😎

[@MrPZAHOOR]

Outstanding Ashish Sir. I have earlier requested for making a video or Excel file on class intervals on data given here as 01-01-2016 to 30-06-2016
01-07-2016 to 31-12-2016

[@kailash.samariya]

great dude

[@TeachToEach]

Thanks for the Comment Ivoomi

[@noorqamar7580]

Wow amazing sir G sir this can apply if I have to fill in coloumn but what if I have huge data and have to fill in rows thans sir

[@TeachToEach]

If we talk about the trick select row instead of column and for formula add a row and use the formula change the address only.

[@noorqamar7580]

sir there are so many rows and by selecting all the rows and then applying select blanks only and the formula =cell to the left it doesnot work

[@Mritunjaymishra]

Really helpful

[@RajeshKumar-fv8yl]

Thank you sir

[@excelcourseinnepali5719]

Thank you g

[@satscoolstyle4210]

Bhai agr mene ek text likha wa or mai chahta hu wo mere accordingly change ho jaye uska vba code kese likhege mjhe jha tk idea h replace formula lagana padega is pr video bna do

[@rakeshchaudharymaithil1383]

Agar down to up blank cell me karna ho to kya karenge plz suggest

[@missionstarget2212]

Sir ji, isme agr sbhi cell fill ho or apne so sirf ek hi cell me ek hi bar state ka name chahiye to uska formula btaiye. Plz... {Aapne jo btaya uska ulta formula btaiye}

[@rohinpal9752]

MIS ke scope ke bare me btye

[@AwadheshKumar-hv6em]

In this excel there is three column if there is missing data in any cell that how can i cut the row which containing blank cell and paste it into other sheet in single click.

[@kartavyatiwari8583]

Sir aap vba ka or video upload kriye na

[@seokjinforever9848]

This is great👏 but I got another doubt what if that cell isn't blank & filled with data how can we use that?? Which formula we need?

[@Ajithkumar-op2kp]

Same query from my side

[@vishalreddy8858]

I want merje the data with respect to above one??

[@ranjandas8486]

Can you solve this from below cell

[@learneverythingbypankaj]

Sir excel.me jab Koi value me type karu to automatic 100 plus Ho Jana chahiye

[@Muhammad_Sakil]

Mujhe ek aur help karoge?

[@apparaodevarapalli3287]

How to remove that same cell values

[@SarthakGuptaofficial]

Go To Special option not there in Excel

[@vinayagrawal5127]

अब इसको just reverse कर सकते है क्या

[@kalyanigundra4594]

I need shortcut form for put password to any file

[@aminakhan6828]

I want

[@Dpk1611]

Ashish ji kabhi to file share kar diya kijiye

[@santoshkumarchauhan3442]

Sirf =c8 formula araha hai sabhi cells me

[@siddusvlogs6259]

Are yaar itani simple chiz Kyo itna tricky banakar Dikha rahe ho just filter the column and use = n just drag it bas ho jayega

[@TeachToEach]

Thanks for Dismotivating me Rohit Ji.

[@VIJAYSINGH-vj1eh]

Bhai tu hi Gyani HAI baki or bhi Bhai HAI..

[@shaikmohsin5706]

Good can you sent me file please

[@shaikmohsin5706]

[e-mail]

[@NirajYadav-vw9mn]

Send me file

[@radheradhe9643]

Can you please update video to find the special characters from the given number. Like 9898#867#685786 I want to get only # from the given number.

[@Muhammad_Sakil]

I have a?

[@TeachToEach]

What?

[@Muhammad_Sakil]

@@TeachToEach A1-B2
A1-B3
A1-B4
A1-B5.......HOW? Substraction

[@TeachToEach]

Its very easy Sahih...Look
Need to Fix A1... IT means put $ sign ....... Write =$A$1-B3 ....then drag it to your limit ... I hope you get the answer.

[@Muhammad_Sakil]

@@TeachToEach thank u so much.....thank u....u r a genious youtuber....dua karta hu ki aap 1M tak jao.....

[@Muhammad_Sakil]

@@TeachToEach baki excel youtuber ko unsubscribe karke aapka video hi follow karunga....thank u.....e trick mera thakan dur kar diya

[@aminakhan6828]

Send me

[@jatinsagwan6456]

Bhai file dedo for practice Emil: [e-mail]

[@stayuptodate909]

Bro it is Ctr + Enter
Not Ctr + Return 😂😂😂😂

[@TeachToEach]

Slip of the tongue 😆