excel wiz: if you have a bunch of rows...
and you want to insert a blank row after each row, what's the fastest way to do it? thanks
and you want to insert a blank row after each row, what's the fastest way to do it? thanks
+258 | My chaotic IB journey | 27 | 15h | |
+211 | MS M&A vs GS HC | 49 | 2h | |
+182 | Ending My Life if I don't get an SA 2025 Offer | 63 | 1d | |
+115 | Anyone live in a different country before? What’s it like? | 43 | 1d | |
+74 | Hazing in the Bullpen. What to do? | 15 | 16h | |
+60 | Improving in TMT | 27 | 2s | |
+53 | MD shoved food down my throat. Is this normal? | 16 | 1d | |
+41 | Later Chodes - I'm Taking My Talents to The Mega Fund Leagues | 10 | 5h | |
+37 | Basically necessary to be a varsity athlete to get BB IB from Bowdoin? | 22 | 1d | |
+22 | Good jokes for interview? | 10 | 15m |
Career Resources
alt i r inserts a new row
hit the down arrow twice then hit F4, rinse and repeat until done.
say there are 1000 rows, i want to insert a blank row after each of the 1000 rows. alt i r doesn't insert after every row.
insert a row then move down 2 cells (relative reference). Then create the loop to repeat it 1000 times.
no need for macros for such an easy task
insert a new column put in numbers multiples of 2 with mod 2 value = 0 (0,2,4,6 etc.) in that new column in each row (many ways to do it, from dragging the corner of the cells to use a formula and then copy value)
put in numbers multiple of 2 with mod 2 value = 1 (1,3,5,7) in the empty rows below your last row with data, in similar manner
use a stupid sort on that column
delete the extra column
tada...
Now that is some creativity!
yup, i did 0.5 increment. thank you for your help!
would have never occurred to me. i like the outside-the-box thinking!
this sounds like an interview question...hmmmm
is that sometimes you get hit with unintended consequences.
I agree that the solution proposed by jajaja is an elegant one but only works if the rest of the dataset is hard-coded or absolute referenced for cells. If it isn't then the links will be messed up.
Commodi culpa facere rerum asperiores voluptas qui. A aperiam cumque ipsa et accusantium earum dolore. Veritatis dolorem qui delectus repellendus. Nulla unde sit sunt nulla animi numquam. Dicta doloremque voluptates et asperiores error magni.
Eos ducimus nisi ea. Consequatur qui voluptas nisi consequatur. Id quo autem occaecati nemo quo assumenda odit.
Quis suscipit exercitationem unde a id laudantium. Nesciunt recusandae vitae dolor eos eius inventore. Non optio esse eum cupiditate assumenda dignissimos autem. Voluptatem incidunt ratione excepturi eos. In quibusdam atque praesentium nulla omnis labore. Et perferendis nisi porro.
Assumenda exercitationem voluptatem hic reprehenderit nihil quas. Incidunt totam eaque facilis aliquam eaque tempore. Consequuntur debitis laudantium sed perferendis. Eligendi nobis nihil eos vero eum numquam.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...