# How do you keep pasted text from breaking rows and columns in Microsoft Excel?

Microsoft Excel feels easy and fast for building reports and sheets, combining data from different platforms, and analyzing trends. The help option also makes it easier to find features, and the integrations with tools like Gmail and Outlook are useful. One frustration is that copy-pasted text from other sources sometimes doesn’t arrange cleanly into rows and columns and can mess up the layout. What steps or settings do you use to keep pasted data formatted correctly?

##### Post Metadata
- Posted at: 7 days ago
- Author title: computer software engineer, web developer
- Net upvotes: 1


## Comments
### Comment 1

select a couple of cells with data > run Text to Columns > uncheck all delimiter settings > finish. 

##### Comment Metadata
- Posted at: 1 day ago
- Author title: Customer-Facing Project Manager | Telecom Operations | Energy Optimization | IIT Delhi Intern |NIT Srinagar '24




## Related Product
[Microsoft Excel](https://www.g2.com/products/microsoft-excel/reviews)

## Related Category
[Spreadsheets](https://www.g2.com/categories/spreadsheets)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4