Тёмный

Excel - Insert a blank row after every row or every Nth row 

Chris Menard
Подписаться 73 тыс.
Просмотров 55 тыс.
50% 1

Do you ever need to add blank rows in between rows? There are several ways to do this in Excel, but if you have a lot of data, right-clicking and inserting rows becomes tedious. We will use a helper column to quickly add blank rows after every row. We will also look at inserting a blank row after every 3rd row or every Nth row.
Chapters:
0:00 Intro
0:12 Helper column for blank rows
1:15 Every 3rd row, a blank row
#chrismenardtraining #msexcel #excetraining #exceltips
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ RU-vid keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

Опубликовано:

 

14 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 51   
@SanjogMainali
@SanjogMainali 8 месяцев назад
You Saved my entire day of work and I finished it in 2 minutes, Now I can go for lunch and chill. Thanks alot
@manishadevi619
@manishadevi619 6 дней назад
very clever, excel must be surprised :)
@hedisasrawan8668
@hedisasrawan8668 10 месяцев назад
Very clever and helpful!
@christophe8482
@christophe8482 9 месяцев назад
This was a great review and i can not believe i never thought of this. This became very handy as I have to do a lot of data loads into our ERP system and the way they built the integration load is if the same item has multiple suppliers attached to it, they each get their own row. so when I am loading hundreds of them, it is easier to have the space between them all rather then adding it when it is needed.
@anatoliilipatkin8678
@anatoliilipatkin8678 10 месяцев назад
Thank you, Sir! Very consice and helpful 🙏🙏
@Rachaelthuo
@Rachaelthuo 9 месяцев назад
So hepful and precise
@user-zb6st2hi8c
@user-zb6st2hi8c 5 месяцев назад
That's exactly the information I needed, thank you! REASON FOR A BLANK ROW: I have to insert a Document number from a table given in Word. Document number in Word are lined up in a column and they do not have a space in-between. How can I do this, please help.
@user-zb6st2hi8c
@user-zb6st2hi8c 4 дня назад
I need to do the same and need help.
@sarababiker6654
@sarababiker6654 6 месяцев назад
Perfect it worked like a charm ❤ thank u very much
@arazick
@arazick 9 месяцев назад
That Was Genius!
@Beautymovesindia
@Beautymovesindia 10 месяцев назад
So Sweet and clever you are. so much problems hav been solved for me.
@jodydyche926
@jodydyche926 4 месяца назад
Brilliant easy!
@reyhancaliskan8135
@reyhancaliskan8135 Год назад
That's awesome! Thanks so much
@ChrisMenardTraining
@ChrisMenardTraining Год назад
You're welcome.
@kaushikbhatnagar3914
@kaushikbhatnagar3914 10 месяцев назад
Very Helpful sir. Thank you so much
@ChrisMenardTraining
@ChrisMenardTraining 10 месяцев назад
Most welcome
@Robert_512
@Robert_512 Год назад
Nice solution! I've used a helper column with alpha and numeric characters then Paste Special but basically the same principle.
@ChrisMenardTraining
@ChrisMenardTraining Год назад
Great point, Robert. That would work also.
@tomazkopac1075
@tomazkopac1075 29 дней назад
Ur the boss man! My masters degree is finishing in no time!
@calebbomske5170
@calebbomske5170 11 месяцев назад
Well, that was extremely helpful. I feel stupid for not thinking of this before.
@ChrisMenardTraining
@ChrisMenardTraining 11 месяцев назад
LOL. Thank you.
@user-zb6st2hi8c
@user-zb6st2hi8c 4 дня назад
@@ChrisMenardTraining Please see my comment/question above, I need help for the next step.
@ishaisha6023
@ishaisha6023 5 месяцев назад
Thank you sir I learn it
@ChrisMenardTraining
@ChrisMenardTraining 5 месяцев назад
TY
@atanudey1887
@atanudey1887 Год назад
Thats great!
@ChrisMenardTraining
@ChrisMenardTraining Год назад
Thank you.
@harishsingh_424
@harishsingh_424 Год назад
amazing trick
@ChrisMenardTraining
@ChrisMenardTraining Год назад
Thank you.
@ChillinFuckinSippin
@ChillinFuckinSippin 11 месяцев назад
youre a freakin life saver man
@ChrisMenardTraining
@ChrisMenardTraining 11 месяцев назад
Glad to help.
@islamicislamicknowledge2546
@islamicislamicknowledge2546 5 месяцев назад
Awesome
@ChrisMenardTraining
@ChrisMenardTraining 5 месяцев назад
Thank you.
@venkateshyoutube
@venkateshyoutube 10 месяцев назад
helpful Boss
@yonasmisganaw6023
@yonasmisganaw6023 2 месяца назад
i really enjoyed this video of your and thanks for that yet i have questions what if the number of row is in group and i need one blank between each group ?
@ZEZ633
@ZEZ633 Год назад
Hi Chris. How can I add row during active filter in the sheet? Thx.
@Hypealpha06
@Hypealpha06 Год назад
I'm working on a large spreadsheet and need a blank row between order numbers. Is there a way to automatically insert a blank row when the order number in column A changes?
@roywilson9580
@roywilson9580 Год назад
Nice solution to the problem. I just hope never to see a dataset with every alternate row as a blank though I am sure someone will use this trick to make their data look "pretty" and "nicely spaced" :D
@ChrisMenardTraining
@ChrisMenardTraining Год назад
I'm with you. I gave up a long time trying to figure out why people want to do certain stuff in Excel. Things I would never do. :-)
@allenrose2213
@allenrose2213 Год назад
I work for a small business and we use excel to actually “program” spreadsheets to help us move inventory around and do all the math, but I do have to make things look pretty to facilitate ease of use for my employees. That being said, this worked phenomenally and I’m kind of annoyed I didn’t think of it sooner! Thank you!
@user-qw7gk7cu2l
@user-qw7gk7cu2l 3 месяца назад
How to copy the row size format in other rows Sir ?
@zabedhosen803
@zabedhosen803 Год назад
Wow...
@Sandeepkol3
@Sandeepkol3 Год назад
Hello, please advise how to insert 2 blank rows after each row having name of companies from cell A1 to A30
@jtkm
@jtkm Год назад
i need help converting phrases to numbers to export my data to SPSS
@user-zb6st2hi8c
@user-zb6st2hi8c 4 дня назад
I need to do this, the second step is to transfer cells from another column into the empty cells. PLEASE HELP
@asmarabadar
@asmarabadar 9 месяцев назад
okay I understood it! But I want to add 6 black rows how to do that?
@playlearn-kidsgamestv8529
@playlearn-kidsgamestv8529 10 месяцев назад
but smallest to largest, this order not showing in sort
@BhavinnTrivedi
@BhavinnTrivedi 7 месяцев назад
How to add the blank row after end similar names? e.g A, A, (blank row), B, (blank row), C
@poetsdeaddiary
@poetsdeaddiary 2 месяца назад
I need to insert a row after each 10000 entries , i m in logistics, so i have to do this every day, what i do is first put number on the right side then copy paste 1 to 10000 , upto the last data , then search for 10000 , then select the entire row below 10000 by control shift space , then control shift+ for adding row , then again do this for the next 10000 entries, for 3 to 4 lakh load i have to do this same process for 30 to 40 times, help me with this please
@tommyharris5817
@tommyharris5817 Год назад
I have a problem - when I type a formula, it covers the cell on the left which I need to click as it's part of the formula. Any solution buddy?
@ChrisMenardTraining
@ChrisMenardTraining Год назад
Tommy, get four arrows and move it. Here is a 22 second video app.screencast.com/MK71R2wX4nTj9
@razahilal4540
@razahilal4540 Год назад
What should i do if i need 50 rows between each rows? Copy 50 times?? So hard
Далее
Excel: move every other row to a new column
8:30
Просмотров 41 тыс.
Excel Tips - Don't Use Formulas! Use Ctrl + E Instead
2:53