tag:blogger.com,1999:blog-2392561432908973850.post9028748526248260660..comments2023-03-24T16:58:50.565+05:30Comments on Microsoft Excel Tips: Insert a Blank Row after each Record without VBAPrakash Singh Gusainhttp://www.blogger.com/profile/05142222674787092917noreply@blogger.comBlogger37125tag:blogger.com,1999:blog-2392561432908973850.post-67374267769875929552019-03-12T12:13:14.743+05:302019-03-12T12:13:14.743+05:30Thanks Thanks pujuhttps://www.blogger.com/profile/17735800459623380812noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-27954357380469000412016-01-02T21:37:32.321+05:302016-01-02T21:37:32.321+05:30thanks a tonthanks a tonAnonymoushttps://www.blogger.com/profile/08820145445831422410noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-76562995705440594022013-09-22T11:53:55.971+05:302013-09-22T11:53:55.971+05:30Mujhe pata tha
Mujhe pata tha<br />Pawan G NAgarhttps://www.blogger.com/profile/05903565421451943203noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-27800509209043644872013-05-20T00:31:19.228+05:302013-05-20T00:31:19.228+05:30excellent!!!excellent!!!Shadab Shaikhhttps://www.blogger.com/profile/04480568687920766071noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-7079953824124772092013-04-29T22:20:59.321+05:302013-04-29T22:20:59.321+05:30Superb..... Thanks a tonSuperb..... Thanks a tonAnonymoushttps://www.blogger.com/profile/07019566709889166432noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-57214776964660345012013-04-20T15:04:10.381+05:302013-04-20T15:04:10.381+05:30many many thanksmany many thanksAnonymoushttps://www.blogger.com/profile/15945185967037266327noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-15915559563144310262013-01-09T11:45:17.860+05:302013-01-09T11:45:17.860+05:30great stuff, keep doing.great stuff, keep doing.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-31787115736558818172012-07-21T08:56:57.514+05:302012-07-21T08:56:57.514+05:30How would you do this if you have data from Column...How would you do this if you have data from Column A to Column M that you want left together?<br /><br />doe jane L M B 9 xxxxx xxxxx xxxxx <br />doe jane L M B 9 xxxxx xxxxx xxxxx <br />doe jane L M B 9 xxxxx xxxxx xxxxx <br />doe john l F B 9 xxxxx xxxxx xxxxx <br />doe john l F B 9 xxxxx xxxxx xxxxx <br />doe john l F B 9 xxxxx xxxxx xxxxx <br />doe john l F B 9 xxxxx xxxxx xxxxxAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-88597137777252685662012-07-21T08:45:44.519+05:302012-07-21T08:45:44.519+05:30How would you do this if you have data from Column...How would you do this if you have data from Column A to Column M that you want left together?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-74466584570424378062012-05-24T13:15:39.446+05:302012-05-24T13:15:39.446+05:30brilliantbrilliantAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-32382460243043149652012-05-06T23:32:23.354+05:302012-05-06T23:32:23.354+05:30Hi
For inserting 5 blank rows after every cell va...Hi<br /><br />For inserting 5 blank rows after every cell value, you can simply paste the number series 5 times after the original one and then sort the series in ascending order.<br /><br />Thanks<br />Anurag RastogiAnurag Rastogihttps://www.blogger.com/profile/00665113226398714092noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-63562774101975066592012-04-11T21:49:21.125+05:302012-04-11T21:49:21.125+05:30This helps sooo much...I would like to ask for one...This helps sooo much...I would like to ask for one adjustment. How would you change the code to insert 5 blank rows intead of only 1? Thank you!!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-32441744247851197312012-03-29T16:33:43.574+05:302012-03-29T16:33:43.574+05:30Awesome idea its helps...Awesome idea its helps...Vivekhttps://www.blogger.com/profile/12618173229772456935noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-15488584034957501142012-02-12T14:53:20.256+05:302012-02-12T14:53:20.256+05:30Really an excellent sharing by Mr.Prakash which ha...Really an excellent sharing by Mr.Prakash which has helped all of us doing our work a much faster.<br /><br />Thanks<br />ArunAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-40911505382157509932012-02-04T19:09:03.313+05:302012-02-04T19:09:03.313+05:30splendid....! I had managed to fetch all my SMS me...splendid....! I had managed to fetch all my SMS messages onto an excel file. But the data was cluttered. Your sorting technique was just what i needed. this helped me make my SMS file for my gf more readable.<br /><br />Thanks from both us.!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-52145122445600195752012-02-01T11:44:12.107+05:302012-02-01T11:44:12.107+05:30Inserting rows is ok but how do you copy the recor...Inserting rows is ok but how do you copy the records in the next row, example, row one has got data and using avobe trick we can insert new row, now we want to copy the data into the inserted rows for a range of records.muneshnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-85584375010020848822012-02-01T11:41:44.277+05:302012-02-01T11:41:44.277+05:30excellentexcellentmuneshnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-38392382453804078472012-01-14T13:44:41.408+05:302012-01-14T13:44:41.408+05:30THIS IS SO GOODTHIS IS SO GOODsreehttps://www.blogger.com/profile/18198215952749149938noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-10524271131423125082011-08-11T13:19:50.668+05:302011-08-11T13:19:50.668+05:30Dear Prakash!
This is very good stuff! This is rea...Dear Prakash!<br />This is very good stuff! This is real smartness for doing big things with less resources like lifting of a heavy weight with a small lever.<br /><br />About 12 years back I also solved a problem more or less with same trick. I will share it later.Muhammad Jawad Mirzahttps://www.blogger.com/profile/05979138436218123351noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-62976520489254785892011-08-09T23:13:53.976+05:302011-08-09T23:13:53.976+05:30Cool stuff.Cool stuff.Ashithttps://www.blogger.com/profile/04356613687283700996noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-28530903556597606482011-08-08T23:29:50.030+05:302011-08-08T23:29:50.030+05:30excellent trick, looking forward for few more !!excellent trick, looking forward for few more !!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-83920520366222754652011-08-06T03:02:19.064+05:302011-08-06T03:02:19.064+05:30Clever, but I'd change the row heights instead...Clever, but I'd change the row heights instead to keep the data contiguous for filtering, pivot tables, and other purposes.David Ringstromhttp://www.acctadv.comnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-5703500424479014812011-08-04T02:19:11.206+05:302011-08-04T02:19:11.206+05:30@Krunal: The first comment of this post has code t...@Krunal: The first comment of this post has code to do it using VBA. Do you want me to explain that to peeps? <br /><br />I think they are easy to understand for any programmer.<br /><br />"HAPPY LEARNING" Cheers!Prakash Singh Gusainhttps://www.blogger.com/profile/05142222674787092917noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-44115608917089815382011-08-04T01:41:30.340+05:302011-08-04T01:41:30.340+05:30Very nice prakash , and also it would be a great f...Very nice prakash , and also it would be a great favour if u comment ur vba code. Since there are many amatures who are keen to understand every line of vba codes.<br />Thanks for Ur efforts an guidance up till now.<br />Anticipating more..krunal mastanahttps://www.blogger.com/profile/15460942663825197351noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-55930665865476202242011-08-03T21:06:07.064+05:302011-08-03T21:06:07.064+05:30@Deepak: You're cent percent correct here dear...@Deepak: You're cent percent correct here dear!<br /><br />@Johny: I wish I would have posted it earlier, but the good thing out of it is that you know VBA now.<br /><br />@ALL: Thanx for your nice comments!Prakash Singh Gusainhttp://prakashgusain.blogspot.comnoreply@blogger.com