2 Amazing Tricks to Fill Blank Cell in Excel with Above Value | Hindi
HTML-код
- Опубликовано: 22 авг 2024
- 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...
Bet needful thi mere liye bht din se youtude ye trick search kr rha tha ab mili
Its best for me
Welcome Gopal
Excellent your teaching method is so good
thanks bhai apne problem solve kar di, isi baat par aapko ek like
Welcome
Hi tech to each sir I am really thankful to video
Welcome Rohit
Thanks a lot, You made my work very easy.
Glad to hear that
Thank U So Much Bro Help Ke Liye ❤
Great, Keep it up, Nayi video banate raho excel pe.
Thank you...Thank you....Thank you....Mere pass 40000 thousand rows ka data hai....mera kitna time save ho gaya ...Just awesome😘😘😘😘
This trick make me easy to work..............save lots of time ...................thanks again
Ashish Sir,
कभी कभी आते हो मगर genuine problem का solution लाते हो | ; )
Thanks for the Comment Puneet Bhai
Superb trick
Thanks for the comment Sachin solanki
Go To Special trick is awesome
Thanks sir 1st one easy
Sir ji kya baat hai topic bahut majedar tha
Thanks for the Comment Mithlesh Bhai
Best video....
Thanks for the comment Pabitra.
Thanks if very helpful to me
Wa..bahot hi maja aya ye formula se
Thanks for the Comment Vikas Bhai
Great sir
Welcome
And thanks sir.
Thanks Poonam
Sir very nice video
Thanks for the comment.
Super for gst R2A data making.. Thanks for making wonderful.. Video
Thanks for the comment Vijay Ji.
Amazing man.. My friend was struggling with this for long time 👌👌👍
Welcome
Awesome video
Thanks a lot sir... Super... This trick save lots of time for me... Thanks again
Welcome Bhai
Nice trick
Thanks Satessh
nice video bhai
Thanks
Thanks for quick found
Ur welcome
Thanks yar bhai....Very important topic for me
Thanks for the Comment Hemant Bhai
Very nice sir g
Thanks bruh.
Nice...
Thanks for the Comment Devendra
Great, I was aware about the 1st way, but thanks a lot for 2nd method. 👍
Thabkyou sir
Sir gud trick
Thanks
Superb
THANKS FOR THIS TRICK
Welcome Mohit
Great
Nice tricks
Nice Video
Thanks
Well done Ashish bro it is workable
Thanks for the Comment Vipin Bro
Useful
Excellent.. specially formula...
Thanks for the Comment Ubaid bhai jaan
Very good solution
Thanks for the Comment Awadhesh
Because of this. I was stuk in my office
So thank you so much🤝👍
thanks for sharing this trick.. 👍
Welcome Bhai
Formula se Value banane ke liye ek shortcut hai..... ctrl+alt+V value wala pop open ho jayega......
I am using Alt E S V for the same bro
Awesome trick bro... Me also ashish
Oh....n thanks
It's very helpful....great job Ashish
Thanks for the comment Narendra.
Dear ashish, kya ye trick or method pivot lagane k baad bhi kaam karta hai..??
Thanks Sir g nice video
Thanks for the comment.
2 nd method is more useful because of its universal application in open office
Wow. Finally got the solution
Nice
Really it helped a lot 🥰🥰
Nice 👏👏
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
Gajab hai Ashish bhai
Thanks for the comment Rohit.
Superb.
Welcome
Thanx
Welcome
Thank you.
Thanks for the Comment Hammad khan
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...
It is helpful
Thanks for the Comment Demon
Thank you sir👍👍🙏🙏😎😎😎😎
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
great dude
Thanks for the Comment Ivoomi
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
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.
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
Really helpful
Thank you sir
Thank you g
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
Agar down to up blank cell me karna ho to kya karenge plz suggest
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}
MIS ke scope ke bare me btye
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.
Sir aap vba ka or video upload kriye na
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?
Same query from my side
I want merje the data with respect to above one??
Can you solve this from below cell
Sir excel.me jab Koi value me type karu to automatic 100 plus Ho Jana chahiye
Mujhe ek aur help karoge?
How to remove that same cell values
Go To Special option not there in Excel
अब इसको just reverse कर सकते है क्या
I need shortcut form for put password to any file
I want
Ashish ji kabhi to file share kar diya kijiye
Sirf =c8 formula araha hai sabhi cells me
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
Thanks for Dismotivating me Rohit Ji.
Bhai tu hi Gyani HAI baki or bhi Bhai HAI..
Good can you sent me file please
shaikmohsin052@gmail.com
Send me file
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.
I have a?
What?
@@TeachToEach A1-B2
A1-B3
A1-B4
A1-B5.......HOW? Substraction
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.
@@TeachToEach thank u so much.....thank u....u r a genious youtuber....dua karta hu ki aap 1M tak jao.....
@@TeachToEach baki excel youtuber ko unsubscribe karke aapka video hi follow karunga....thank u.....e trick mera thakan dur kar diya
Send me
Bhai file dedo for practice Emil: onlyforjatin95@gmail.com
Bro it is Ctr + Enter
Not Ctr + Return 😂😂😂😂
Slip of the tongue 😆