How to fill empty cells with previous row value in Excel
HTML-код
- Опубликовано: 22 авг 2024
- Have a lot of gaps in your data that have to be filled with the data above? Learn how to quickly & easily fill in previous data in cells. This is a simple trick to get all the preceding data into empty cells below. Maybe you already know how to use these tools and shortcuts, but never thought you could use them like this too!
------------------------------
** After this video, to learn in-depth about Pivot tables and charts, Enroll for an Online course conducted by me on Master Business Reporting with Pivot tables and charts in Excel
Also, as you are a special Viewer/ Subscriber,
we would like to give out a special discount just for you,
so click here -
www.udemy.com/...
------------------------------------
SUBSCRIBE NOW!
/ @excelrush
Click this link to learn more awesome functions in Excel
• Learn Excel's Tricks
Click this link to learn how to manage your personal finance using Excel
• Personal Finance
Thank you for watching
Keep Excel-ing!!
I was searching for exactly this same issue for so long time and your video came as like a gift to me. God bless you
You are my savior sir, subscribed now! and big Like! Thank you from Colombia my friend!
I was thinking a lot about how do I do this, but you made so much easier, thank you God bless you
It helped me with one of the most crucial data sorting tasks! Thank you so much!
Thank you so much!!! Helped me solve a problem that I just encountered. Very useful and informative. Please share more tricks.
I spent a day looking for this thank you!
Absolutely useful. Just helped solve a problem I was working on
Thank u bro ...... Very use full to me ... Thanks a lot
You just saved my 2+ hrs work.
Superb! Bravo👏👏👏
Thank you. U saved hours of my time 🙏🏽
Too good @ 5.41 solved a query dot on - Thank you so much !!
You have just sorted out my problem...thank you very much
Very useful and saved lot of time
This is so helpful!!! ILYSM!!!!
excellent. Just it solved my problem. Thanks
good thought
Super & more useful this formula for me
Very useful trick 👌
Very Very useful, thanks a lot!!!!
Do subscribe to the channel!
simple but yet powerful
Thank you sir you save my day
Do subscribe to the channel!
Wonderful… thanks 🙏
Thanks alot. Really appreciated :)
very useful, thank you for sharing
Thank you for helping with the short cuts
Thank u So much 😁😁
Thanks, Its good one
Superb 👌🏻
Thanks
THANK YOU SO MUCH!
Thank you
Thank you!!!
Thanks sir
Sir, how to insert blank rows before/above specific text ?
please reply.
yes, same doubt
Thank u so much
kya mast kam karta hai re tu maksud bhai
Hahaha thank you!
how to do this if I have data in 5 merged cells?
I have data in a merged cell (merged up and across), I want to paste this data into the cells below by merging them in a similar way. How to do that?
What if I need to take value from side
Can we not do for all columns in one go ?
Good Sir
How to do this using a formula?
It is not working, it is copying the cell address to blank cells
yes, same for me, while doing horizontal line.
Can you plz explain if data is more than 1 lakh then wht to do.
my god ilove you,
If i want to fill the series in each empty cell continue with the number just above it... How to do it.?.. If i have 2 in uper cell.. Thn I have to fill 2,4,5,6,7,8... Then with next cell in same column have 3 in upper cell..n want to fill next numbers below it ...have huge data... Please guide
Just type group 1 and group 2.. then select both cells.. and drag it down using the bottom right part.. it will happen
@@Excelrush m doing it... But its huge data.. Its takes so much of days to drag it manually...is there is any option like this video to fill it quickly
Use the Fill option in the HOME tab
Home - fill - series
@@Excelrush u r not getting my point.. Its not to one Series through out the table... For instance in this video.. In cell of group 1..i have to fill next blank columns with group 2,group 3.. So on.. There are some numbers in one columns with some blank cells below it.. Have to fill next numbers in all that blank cells with above cell value..so can not use fill option..
ok, but how to do the same in horizontal line?
No cells were found are showing
Really helpful .. thank you
Thanks alot. Really appreciated :)