Efficient Data Formatting in Excel: Using Formulas to Organize Pasted Content

If you pasted data in Excel and it put it all in one column, don’t manually move the cells to fix the formatting. Instead, type equals, wrap rows and select your data. Type a comma and then indicate how many columns your data should have before starting a new row. Press enter and you’re done. Copy and paste values to hardcode the data.