---
title: Column headings using CHAR(10) function
description: Excel CHAR(10) Column Headings
---

[Skip to content](https://thetaglobal.co.uk/theta-im-excel-blog/column-headings#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)

# Column headings using CHAR(10) function

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

Controlling the configuration of Column headings

How to control exactly where the line break goes in the column heading without having to change column widths?

The tip contained in the embedded Spreadsheet explains the use of the Excel concatenation function "&" and the use of CHAR(10) to insert line breaks in to text.

Click on this link to download the spreadsheet:

[I+M Excel Tips - CHAR(10)](https://thetaglobal.co.uk/hubfs/I+M%20Excel%20tips%20-%20CHAR(10)%20column%20headings.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 ...???

#### [Avoid using Merged cells](https://thetaglobal.co.uk/theta-im-excel-blog/avoid-using-merged-cells)

Merged Cells in Excel can be avoided with these simple steps

#### [How to create Corporate Colours in a Dashboard](https://thetaglobal.co.uk/theta-im-excel-blog/how-to-create-corporate-colours-in-a-dashboard)

#### [Why you need to be using Excel Tables and how to create one.](https://thetaglobal.co.uk/theta-im-excel-blog/why-you-need-to-be-using-excel-tables-and-how-to-create-one)

[![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:52:01.611Z",
  "datePublished" : "2023-01-27T16:52:01.000Z",
  "headline" : "Column headings using CHAR(10) function",
  "mainEntityOfPage" : {
    "@id" : "https://thetaglobal.co.uk/theta-im-excel-blog/column-headings",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://thetaglobal.co.uk/hubfs/RGB%20Logo%20White%20BG.jpg"
    },
    "name" : "Theta Global Advisors"
  }
}
```