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
+221 | A Guide to HK Investment Banking - 10 Most Frequently Asked Questions (2024) | 68 | 2h | |
+64 | What were traits of your favorite summer analysts? | 26 | 10h | |
+64 | Wharton or Dartmouth/off the waitlist | 76 | 2h | |
+51 | Best associate opp — GS or CVP? | 12 | 1h | |
+47 | Internship 101 | 6 | 2d | |
+44 | GS should remain the top choice for all undergrads interested in finance | 20 | 1d | |
+42 | Should I move back into IBD for salary? | 23 | 9h | |
+39 | Why does everyone shit on Houston/Dallas-What’s so special about NYC(genuinely curious). | 23 | 38m | |
+37 | EB Return Offer Rates | 30 | 2d | |
+36 | MS & GS vs JPM | 23 | 20h |
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.
Qui repellat distinctio non corporis quos sint. Alias sit asperiores dolorem voluptas accusamus dolores. Perspiciatis et quis autem odio enim ut a.
Quaerat error sed et eos. Fugiat cum voluptatem quia quia veniam similique. Et ut non animi modi debitis aut totam.
Rerum explicabo doloremque dolores unde quis in. Fugit nostrum beatae eum molestiae. Est assumenda voluptas quia sed inventore et. Accusantium maiores voluptatum cupiditate vel. Dicta iste pariatur quasi quo dignissimos. Eaque quo enim amet doloribus. Vero amet neque ipsa ut architecto unde temporibus.
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...