tag:blogger.com,1999:blog-2788216437526312119.post3810971689861779160..comments2024-03-27T21:55:58.810+02:00Comments on Fors: Insert multiple blank rows between existing rows in ExcelGeorge B. Mogahttp://www.blogger.com/profile/13619656378366308760noreply@blogger.comBlogger23125tag:blogger.com,1999:blog-2788216437526312119.post-51529745656199073452016-10-24T16:00:02.958+03:002016-10-24T16:00:02.958+03:00Superb trick yaar. Thanks for the guidance.Superb trick yaar. Thanks for the guidance.Anonymoushttps://www.blogger.com/profile/05115204388510953044noreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-9543185810684301992016-08-10T16:17:15.476+03:002016-08-10T16:17:15.476+03:00its superb man its working for meits superb man its working for meAnonymoushttps://www.blogger.com/profile/16575957294650245716noreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-9158044985747348312016-08-05T09:00:27.869+03:002016-08-05T09:00:27.869+03:00I'm not getting insert option once I select mu...I'm not getting insert option once I select multiple rows. Plz helpAnonymoushttps://www.blogger.com/profile/03142641727691077316noreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-51019178372279780072015-10-08T17:20:19.980+03:002015-10-08T17:20:19.980+03:00Nice work done beautiful articleNice work done beautiful articleAnonymoushttps://www.blogger.com/profile/04573543473863950634noreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-26992746854395320212015-10-08T14:26:31.894+03:002015-10-08T14:26:31.894+03:00Very nice trick and really its working just you ha...Very nice trick and really its working just you have to exactly right click on left row of the spread sheet contains rown numbersinfoholick.bloghttps://www.blogger.com/profile/15758093677362527824noreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-8256754855663721832015-09-30T11:12:07.325+03:002015-09-30T11:12:07.325+03:00Hi Andres,
I'm not sure how familiar are you ...Hi Andres,<br /><br />I'm not sure how familiar are you with VBA in Excel, but it seems the easiest way to do this here - basically writing a small piece of code to do the manual job for you. George B. Mogahttps://www.blogger.com/profile/13619656378366308760noreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-29506430287796519292015-09-30T01:04:03.059+03:002015-09-30T01:04:03.059+03:00Hi George. I have a list of 50 names sorted vertic...Hi George. I have a list of 50 names sorted vertically/consecutively and I need to add 15 rows below each name. How can I do that in a simpler way other than having to repeat the 15-lines-insert for each name one by one? Thank you. Anonymoushttps://www.blogger.com/profile/18184063129164860822noreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-45615935237431508572015-09-30T00:59:06.808+03:002015-09-30T00:59:06.808+03:00Hi George. I need to do this. For instance: I have...Hi George. I need to do this. For instance: I have a list of 100 names oriented vertically all consecutively; I need to add 15 lines between each of the names. Is there a way to add the same 15 lines below each name with a command all at the same time? Or at least an easiest way other than adding them for each name at a time?<br /><br />Thank you.Anonymoushttps://www.blogger.com/profile/18184063129164860822noreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-49993791024430880972015-08-16T08:11:10.553+03:002015-08-16T08:11:10.553+03:00The error happens when you click an already highli...The error happens when you click an already highlighted row when inserting a new row. When selecting the row, try clicking the number to highlight the entire row when the black arrow appears. Click while pressing ctrl one row at a time. This is time consuming though. Now I'm trying to install kutools for excel appJohnPierrehttps://www.blogger.com/profile/05072749140036067969noreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-60764102950979620582015-04-22T14:09:44.601+03:002015-04-22T14:09:44.601+03:00Thanks so much - I just knew there was a simple ex...Thanks so much - I just knew there was a simple explanation out there!Mary Pnoreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-13079087176303000222015-02-14T17:10:50.978+02:002015-02-14T17:10:50.978+02:00You should switch your file format to the new Exce...You should switch your file format to the new Excel format (.xlsx), it supports over 1 million rows.George B. Mogahttps://www.blogger.com/profile/13619656378366308760noreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-90352588735190893722015-02-13T22:04:51.313+02:002015-02-13T22:04:51.313+02:00need help please? entering over 1 one hundred tho...need help please? entering over 1 one hundred thousand Karaoke songs on a spreadsheet (to use for song lists) and I ran out of rows (there are only 16,384 rows allowed). Now what can I do to add more rows so I can add more songs and be able to sort alpha? Anyone now exactly how I can fix this as I have already entered 16,384 song titles and have a lot more to add? Please helpAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-21033483590308699172014-04-29T15:57:28.879+03:002014-04-29T15:57:28.879+03:00In that case you can either use the original techn...In that case you can either use the original technique described on <a href="http://www.techrepublic.com/blog/microsoft-office/quickly-add-a-blank-row-between-multiple-rows-of-data-in-an-excel-spreadsheet/" rel="nofollow">TechRepublic</a> or write a quick macro in VBA for the task - that's probably the most efficient method.George B. Mogahttps://www.blogger.com/profile/13619656378366308760noreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-46272821289011414702014-04-29T13:00:46.458+03:002014-04-29T13:00:46.458+03:00Thanks i just tried that and it worked. However i ...Thanks i just tried that and it worked. However i have a challenge, im working on a worksheet with more that 2000 rows which i need to insert additional rows i between... clicking each row one by one is quite tedious, is there a quicker solution?Anonymoushttps://www.blogger.com/profile/10141906548632402730noreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-5469224534648881122013-08-07T20:11:49.899+03:002013-08-07T20:11:49.899+03:00There is a utility "add-on" available th...There is a utility "add-on" available that handles this in 4 mouse-clicks. Google "ASAP excel". It's an "add-on" and it adds a tab to the tool ribbon in excel. There's a free trial, and all 4 of us in my department were authorised for the full version because it was easy to demonstrate how much time we would save. The more we explore it the more cool stuff we find (like insterting multiple rows).Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-27867931797767743152013-06-10T23:44:00.238+03:002013-06-10T23:44:00.238+03:00Thanks! If you want to insert multiple copies of ...Thanks! If you want to insert multiple copies of a line, first make one copy and insert it where you want. Then click on its row number, and while holding the mouse button down hit and then drag the mouse down as far as you want. Release the left mouse button, click the right mouse button and select 'Insert'. This will create as many blank lines as you wanted. Then, select all the cells in the row you wanted to copy, and grab the right bottom of that group and drag down to fill the empty lines you created. (this last part is the standard Excel duplicate function)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-41712478600553782242013-06-04T20:55:43.358+03:002013-06-04T20:55:43.358+03:00Then you can either use the method linked here fro...Then you can either use the method <a href="http://www.techrepublic.com/blog/msoffice/quickly-add-a-blank-row-between-multiple-rows-of-data-in-an-excel-spreadsheet/2058" rel="nofollow">linked here from TechRepublic</a> (basically you add another column with odd numbers next to your table, then add the even numbers below them and finally sort the entire table by that column) - or you can write a macro for your specific use case. George B. Mogahttps://www.blogger.com/profile/13619656378366308760noreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-16484567677551509922013-06-04T15:01:01.423+03:002013-06-04T15:01:01.423+03:00and if i wana do it for big no of rows?and if i wana do it for big no of rows?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-25370844340328072792013-01-09T18:36:46.889+02:002013-01-09T18:36:46.889+02:00Brilliant. Just..brilliant.Brilliant. Just..brilliant.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-70087805688512724472012-07-03T10:43:55.232+03:002012-07-03T10:43:55.232+03:00Yes, that's pretty much the procedure. It does...Yes, that's pretty much the procedure. It does not work, indeed, if you want to insert multiple rows after the selection, mainly because Excel only inserts the number of rows you have selected - in this case you basically select one row (the extension of the selection with Ctrl doesn't count). You could select 3 rows at a time and use insert, this way Excel will also insert three rows, but I'm not sure if this helps you. I think for your specific case you would need to write a macro.George B. Mogahttps://www.blogger.com/profile/13619656378366308760noreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-3678954712060599932012-07-03T05:58:29.025+03:002012-07-03T05:58:29.025+03:00Thanks for your reply. I got it to work. I was hig...Thanks for your reply. I got it to work. I was highlighting the first row, then holding down Ctrl, then holding down the left button to highlight all the rows, including the first row. You need to click on the first row, hold down Ctrl, then, omitting the first row, click on each subsequent row. And each subsequent row needs to be clicked on individually, which can be kind of awkward when I have thirty rows to click on. So, am I correct that each row needs to be clicked one at a time, and that only one blank row is added between the data-filled rows? I usually have thirty rows and need three or four blank rows placed between them. In my case, it seems that I still need the TechRepublic method. Am I correct?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-91929061750091017542012-07-01T19:19:58.058+03:002012-07-01T19:19:58.058+03:00It's still working for me as described under O...It's still working for me as described under Office 2007 as well. You probably selected a regular cell along with the row/column, when I do that I get the same error message. Try to first select a row, then hold down CTRL and with CTRL down select the other rows one by one. That should work.George B. Mogahttps://www.blogger.com/profile/13619656378366308760noreply@blogger.comtag:blogger.com,1999:blog-2788216437526312119.post-36528288450457296272012-06-30T23:34:10.494+03:002012-06-30T23:34:10.494+03:00Your solution sounds much simpler than TechRepubli...Your solution sounds much simpler than TechRepublic's, but I can't make it work. I get an error message "Cannot use that command on overlapping selections" or "That command cannot be used with selections that contain entire rows or columns, and also other cells. Try selecting only entire rows..." in Excel 2007. Any ideas?Anonymousnoreply@blogger.com