How to insert blank row after each customer in Excel (Creative Idea)
Вставка
- Опубліковано 5 жов 2024
- How to insert a blank row after each customer in Excel. In this video, you will find a creative Excel trick. When you have a large list of data with multiple customers, you may want to add a blank row after each customer. This helps to view the data clearly.
We will use the Subtotals feature covered previously to do this trick.
#ramgopalexcel
This video is created by Ramgopal from Presentation Process in Excel 2016 for Office 365. Visit Presentation-Process.com for more.
This will save us almost 2hrs of work when we make our books for year end. What a find THANK YOU SOOOOOO MUCH YOU ARE MY HERO!!!!!!!
You just saved me hours of work! Thank you so much! I love any tips that don't require add-ons or VBA. Love it!!
This is just brilliant! Doing this manually is just a huge pain. THANKS!
Really a huge pain, especially with loads of data
Yep, that's a cool way to use the subtotal feature for something unexpected. Very good
thank you again. I don't remember if I thank you before.
This was perfect!!!! I watched about 8 videos before I found this one & it worked GREAT!!! Thank you so much!!!
There are so many videos related to this, but you gave the exact thumbline.
Thank you! This was extremely informative and helped me with exactly what I need
WOW !!! SPENT HOURS DOING IT. YOU MADE IT EASY. THANK YOU.
This was great. thanks again. I need to remember this more often. I don't do this all the time.
You just saved me hours of work! Thank you so much! I love any tips
Dear frd thanks a lots.. the way you explained super and easily understand
That was really neat way of doing this, I have used formulas to do this and overlook so many of the build in features. Thank you.
Hello Ram. Today I used your tip again. Thanks a lot.
OMG great instructions ! Im going to be following your Excel How to Videos and share what I learn
Thank you very much. Looked everywhere and this worked flawlessly
Glad it helped
Thank you SO much!! This just saved me tons of time.. great presentation! easy to follow
Now I got the correct video, I was searching this information everywhere.
Where have you’ve been all my life? 😂😂😂Thank you so for this 👍🏼👍🏼👍🏼
Exactly bro same here 😂😅
I am working with 17,000 rows in excel...you have saved me hours of tedious work.
This is very helpful. Thank you so much!
Fantastic! save me a huge amount of time. Thank you
Woooow, I have been looking this video for so long, i tried a lot of tutorial but this one is the best. Thank you so much
This is simple and requires no external excel tools. I highly Recommend!
Thanks a Lot. Both information and presentation was impressive.
Awesome thank you this will save so much time
Was looking for it since long time and finally got your video!! Thanks bro
Thanks a lot, I was searching for the same scenario for my project.
Hello Ram. I really liked your video. It's exactly what I needed. I use it in my job. Thanks a lot.
Thank you bro, you are the best
You're welcome
I worked it out - amazing video. 😮🎉
Fantastic video. It's very helpful and save a big amount time thanku
That was smart. Thank you very much.
That's a great information bro. Thank you
Very usefull video sir thanx🙏
Most welcome
My gosh, this is crazy bro. The contend worth every second👌👍 Thanks a lot, bro❤
Thank you so much you saved many days of my life 🙏🙏
This so helpful, Thank you so much
Great ! Thanks for sharing
Thanks for watching
Bravo...i liked it
Good job! Love your presentation skills!😉
Hi, thank you so much for your video, it really helps me a lot with my work.
You're very welcome!
Thank you sir it helped me a lot.
So good saved my time which I hated the most
Excellent. It was really helpful. Thank u so much
Thank you , great help
This is genius!!! I am using this function/feature for a report that I am doing now. Genius! Thanks!
Oh my god!! Thank you so much!! You are like my saviorr!!
Brilliant🤜🤛😃
thanks for the very useful video
It's amazing and thank you so much
Was using VBA for this and then this came up... Thanks a lot!
Glad it helped!
Nah dude. You are a legend. Thank you thank you thank you
YOU ARE DA MAN! THANK YOU!
Awesome trick.
Thank you so much.
How can I highlight only the first rows in each separated customer name
Huge time saver! Thank you and subscribed.
Thank you! very nice trick!
Thank you very much for this idea
Thank you so much. It really helps me a lot.
Many Many Thanks Mr
THANKYOU SO SO MUCHHH!!😭😭😭😭😭
Excellent video.
that I want, is in this video.
Great and how add all subtotals at the end
Thank you!!!😀
Nicely done!
Can you help me on how to do this using the VBA in Excel?
Thank you soooo muchhhh❤️❤️❤️
Perfect ❤️ thank you!
i'm using in 2021, tq superb!
Amazing, Thanks a lot
Excellent
This looks like EXACTLY what I need, but my version of excel doesn't have a Subtotal feature under Data. I'm using version 14.7.1 of Excel for Mac2011
Hi Mr Ram Gopal, new subscriber here. I watched yr video. It was so easy. This was what I was waiting for. Can u teach me how to insert two rows in between customers?
Thanks and welcome
Please Sir, is there a way to add two rows after each customer?
Hello sir
How we can put headings upon each inserted blank rows?
GREAT !!!!!!!
Once you have the blank rows, assuming your data range is A2: G34, how can you insert rows from adjacent columns? The column names in H2:N34 are identical to the ones in A2:G34. Essentially, I would like to create two rows (one for origin and one for destination) for every one row in order to use in Tableau.
Is there a way to 'color' the blank rows added. I need to add 'white' rows to a sheet where all the others are a yellow color. When I add rows they are yellow too but would like them to be white to differentiate from the other rows. Is that possible?
ok...gfraet I list of bank activity and would like to the same thing adding blank row for reppited day of the month ,,,how can i do that ?
Really amazing trick
thank you sir
Mr Ram Gopal, can we use the same method to insert two rows after each customer. If yes, could u show me how. Thank u. Waiting for prompt reply
Thank a lot
Nice thanks
Super thanks
Wow mahn thanks
A-M-A-Z-I-N-G
😀 Thank you!
thanku so much
Pls how to add blank line after each 10 lines? Lets say i have 100 lines in total
Sir, how to insert blank row after mimimum value cell of column in excel🤔
Thank you.
❤️Better than chat gpt
Same condition can you provide the VBA code
dear sir, is there any shortcut key for this task?
Mine counted and spaced every customer name. It didn’t group them
hello sir what to do if i need 3 blank rows
Hi, Good video!!, what if you are comparing two Pivot Tables or the values of two different columns to know the variances and needs to create a blank row in one of them, how do you do that?, thanks!!
you prolly dont give a shit but does any of you know a tool to get back into an instagram account?
I somehow forgot my password. I love any assistance you can give me!
@Thomas Reuben instablaster ;)
@Ralph Ahmed Thanks so much for your reply. I found the site thru google and I'm in the hacking process atm.
Looks like it's gonna take quite some time so I will reply here later when my account password hopefully is recovered.
@Ralph Ahmed WTF IT ACTUALLY WORKED! I literally got access to my IG account details within roughly 30 mins by using the site.
Thank you so much, you saved my account!
@Thomas Reuben glad I could help xD
thanks
How we can insert spical raw not blank any one know?!
👌👌👌