---
title: Avoid using Merged cells
description: EXCEL MERGED CELLS
---

[Skip to content](https://thetaglobal.co.uk/theta-im-excel-blog/avoid-using-merged-cells#main-content)

[![RGB Logo Glow](https://thetaglobal.co.uk/hs-fs/hubfs/RGB%20Logo%20Glow.png?width=180&height=146&name=RGB%20Logo%20Glow.png)](https://thetaglobal.co.uk)

Open main navigation

Close main navigation

- [Home](https://thetaglobal.co.uk)

[Home](https://thetaglobal.co.uk)

# Avoid using Merged cells

 Published by [Simon Jeffery](https://thetaglobal.co.uk/theta-im-excel-blog/author/simon-jeffrey) on Jan 27, 2023 4:49:55 PM

Merged Cells in Excel can be avoided with these simple steps

Are you often left frustrated when copying large blocks of data in Excel with merged cells in the destination worksheet preventing you from pasting the data?

This simple tip with an example can help you avoid merging Cells in column headings by using Excel's formatting functions.

Click on this link to download the spreadsheet:

[I+M Excel Tips - Avoid MERGE](https://thetaglobal.co.uk/hubfs/I+M%20Excel%20tips%20-%20Avoid%20MERGED%20Cells.xlsx)

###### Related News Articles

#### [Remember "Print Preview"? Add it back to your toolbar.](https://thetaglobal.co.uk/theta-im-excel-blog/print-preview)

Print Preview was always so useful, then Microsoft decided to hide it ...???

#### [Column headings using CHAR(10) function](https://thetaglobal.co.uk/theta-im-excel-blog/column-headings)

Controlling the configuration of Column headings

[![Turq Logo with glow](https://thetaglobal.co.uk/hs-fs/hubfs/Turq%20Logo%20with%20glow.png?width=210&height=170&name=Turq%20Logo%20with%20glow.png "Turq Logo with glow")](https://22037879.hs-sites.com/aspect/)

#### Company

- [About](https://25962224.hs-sites-eu1.com/about)

#### Services

- [Insights + Modelling](https://25962224.hs-sites-eu1.com/im)
- [Deal Advisory](https://25962224.hs-sites-eu1.com/deal-advisory)
- [Accounting Advisory](https://25962224.hs-sites-eu1.com/accounting-advisory)
- [Risk & Resilience](https://25962224.hs-sites-eu1.com/risk-resilience)

#### Contact

- +44 (0) 203 3918 5941
- [insights@thetaglobal.co.uk](mailto:insights@thetaglobal.co.uk)
- [www.thetaglobal.co.uk](https://thetaglobal.co.uk)
- [LinkedIn](https://www.linkedin.com/company/thetafr/mycompany/)

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Simon Jeffery",
    "url" : "https://thetaglobal.co.uk/theta-im-excel-blog/author/simon-jeffrey"
  },
  "dateModified" : "2023-01-27T16:49:55.426Z",
  "datePublished" : "2023-01-27T16:49:55.000Z",
  "headline" : "Avoid using Merged cells",
  "mainEntityOfPage" : {
    "@id" : "https://thetaglobal.co.uk/theta-im-excel-blog/avoid-using-merged-cells",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://thetaglobal.co.uk/hubfs/RGB%20Logo%20White%20BG.jpg"
    },
    "name" : "Theta Global Advisors"
  }
}
```