23K views · 72 reactions | 易 Excel Trick of the Day: Want to insert blank rows between each row in a column? Use this magic formula with #TOCOL: =TOCOL(CHOOSE({1,2}, A1:A10, ""), 1)  Instantly doubles your data with blank rows in between! #ExcelTips #ExcelFormula #office365premium | Excel By Vikal | Facebook

🧠 Excel Trick: Insert Blank Rows Between Every Row Using Sorting! Want to add a blank row between every row without VBA? Try this genius sorting trick! 🤯 🪄 Steps: Insert a helper column → In column A, type 1 in A2, 2 in A3, and drag down till the last row. Copy the helper column and paste it below the last number (e.g., if last number is 100, paste from A101 to A200). Now select your entire dataset (with the duplicate helper column). Go to Data → Sort and sort by the helper column. Voilà! 🎉