# 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: vor 19 Tage
- 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: vor 14 Tage
- Author title: Customer-Facing Project Manager | Telecom Operations | Energy Optimization | IIT Delhi Intern |NIT Srinagar '24




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

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

## Related discussions
- [Wie gut skaliert Trello in ein größeres Team?](https://www.g2.com/de/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: vor etwa 13 Jahre
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/de/discussions/2-can-we-please-add-a-new-section)
  - Posted at: vor etwa 13 Jahre
  - Comments: 0
- [Quantifizierbare Vorteile durch die Implementierung Ihres CRM](https://www.g2.com/de/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: vor etwa 13 Jahre
  - Comments: 4