Insert Blank Row After Each Row | Add Blank Column Between Columns | Excel in Hindi

preview_player
Показать описание
Teach to each video on how to insert blank row after each row / add blank column between columns excel in hindi. This excel tutorial you about how to add a blank row and column in excel.

After this topic you will learn:-

1) Add/Insert a blank row after each row in excel

2) Add a blank column after each column in excel

Steps to add a row and column in excel :-

A) First make a series in first row/column till the data you have.

B) If you need to add a single row after each row then copy the same series of number and paste it just below where the data ends and if you need to add two rows then paste it two times.

C) Press CTRL + A and filter it and sort with Smallest to Largest.

D) That’s it remove your series fill row you can use the same process for adding a column between each column.

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 how to use freeze panes in excel. Thanks for watching.

It is humble request to you. Please subscribe my YouTube channel by click on this link

Some popular videos-:

Рекомендации по теме
Комментарии
Автор

बिल्कुल time बचेगा, ऐसे ही जारी रखे | ; )

puneetvij
Автор

Sir If We have not a sr no data but sone 2raw some 5 raw on that time i would like to insert raw than how to insert raw

Jivansathi
Автор

Very nice ap ne to mera problem solve kia thankyou dear

abdulbasitkhankhattakkingk
Автор

Brother i have a doubt on you... i think your concept is copy from excel superstar channel... am i right ?

RonakGupta
Автор

Last me row kaise add kre taki table bhi extend ho jaye hmara aur formula bhi use ho jaye usme.?

vishalyadav
Автор

Agr ham nay 2nd row ka bad 2 row insert krni ho or 3rd ka bad 3 row insert krni ho tou ksy karain

imranali-iywk
Автор

Bhai har 25 row ke baad space rakhna ho toh?

pratikshelar
Автор

Hi sir First of all thanks allot yr way to explain is very nice a complete Nd correct information you r sharing and teaching us sir thankss

satishchaurasiaya
Автор

Sir, I have one more query, In office other employees merge cells inbetween data, Can we apply Vlookup to a part of data

kirandeepchoudhry
Автор

column, row insert karne pr pehle likhe huye formulas work nahi karte, ise kaise fix kare, ya formula firse type karne padenge

amolkumar
Автор

Hi sir, Plz can you share link of ms access and ms VBA if possible .

satishchaurasiaya
Автор

Sir, please explain if formula are applied inbetween columns plz answer

kirandeepchoudhry
Автор

Bhai jo videos aap banate ho me sab dekta hu or muje bhut kuch naya sekne ko milta ha... So thank So much

souravsinghbolt
Автор

In a bank statement how can I pick only day end balance, whereas there are 5 or 6 entries in a day, I need to check every day what was my day end balance.

NandanSinghAlmiya
Автор

And how to delete additional rows and columns in data with tricks?

hafizdanialbaig
Автор

good One bro..I appreciate your work..bhai ek excel ka data ka video bnao..and basis b smjhna aache se.intzar rehega apke video ka.. thnx

rajneeshkumar