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
+125 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 59 | 1d | |
+85 | Updated LA Banking Scene (2024) | 61 | 22h | |
+42 | Ranking banks that went under | 26 | 4h | |
+39 | Burnt Out M&A ASO | 22 | 15h | |
+37 | Relevance of A-Levels for U.K. London recruiting | 25 | 20h | |
+37 | Intern Ettiquette | 9 | 22m | |
+33 | A strategy for SA applicants late to the game like myself | 17 | 19h | |
+27 | Series 79 Help / Tips to Pass The First Attempt | 11 | 3d | |
+26 | 2024 new grads who didnt get return offers update | 12 | 33m | |
+24 | What are hours like at BBs in London? | 48 | 19m |
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.
Illum aut voluptatum maiores. Asperiores velit corporis ut rerum veniam sed nostrum.
Et ullam magnam animi. Dolor vero praesentium alias. Minus quis unde quia qui assumenda quam. Velit rerum sunt voluptatem odit non voluptatem velit.
Ea quos magni id modi eos delectus unde eaque. Quasi porro laboriosam quos occaecati. Aut tempora accusantium dolor error rerum suscipit optio nobis. Adipisci nisi minus qui debitis dolore omnis. Ipsa dolor ipsam aliquam et. Quo fugit officia vel aut laboriosam quo nulla.
Perspiciatis ullam aspernatur animi ullam excepturi sit ad. Qui veritatis molestias non sit. Pariatur vitae reiciendis quae. Et corporis blanditiis impedit nam voluptate odio est. Omnis error quo vitae voluptatem at. Facere temporibus inventore et vero ut vel cum.
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...