# 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: circa 1 mese fa
- 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: 26 giorni fa
- Author title: Customer-Facing Project Manager | Telecom Operations | Energy Optimization | IIT Delhi Intern |NIT Srinagar '24




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

## Related Category
[Fogli di calcolo](https://www.g2.com/it/categories/spreadsheets)

## Related discussions
- [Quanto bene si adatta Trello a un team più grande?](https://www.g2.com/it/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: circa 13 anni fa
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/it/discussions/2-can-we-please-add-a-new-section)
  - Posted at: circa 13 anni fa
  - Comments: 0
- [Benefici quantificabili dall'implementazione del tuo CRM](https://www.g2.com/it/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: circa 13 anni fa
  - Comments: 4