How to Title a Column in Excel – 5 Methods

The dataset showcases Sales Person, Product, and Sales.

Ways to Title a Column in Excel


Method 1 – Title a Column using the Cell in Excel

There are blank cells in B4:D4.

Title a Column Through Cell in Excel


Step1 – Title a Column

  • Select B4.
  • Double-click the cell.

  • Enter the title. Here, Sales Person.

Title a Column Through Cell in Excel

  • Press ENTER.

  • Add column titles to the rest of the columns. Here, Product in C4 and Sales in D4.

Title a Column Through Cell in Excel


Step 2 – Formatting the Column Title

  • Select B4:D4.
  • Click Increase Font Size.

Title a Column Through Cell in Excel

  • Click Bold to bold the texts.

  • Click Fill Color to change the color of the cells.

Title a Column Through Cell in Excel

  • Select a color. Here, Blue, Accent 1, Darker 50%.

  • Click Font Color to change the font.

Title a Column Through Cell in Excel

  • Select a color. Here, White, Background 1.

  • Select Center in Alignment.

Title a Column Through Cell in Excel

This is the output.

Read More: How to Create Column Headers in Excel


Method 2 – Using the Formula Bar to Title a Column in Excel

Add or change the column headings in B4:D4:

Using Formula Bar to Title a Column

Steps:

  • Select B4.
  • Go to the Formula Bar.

  • Enter the column title. Here, Sales Person.

  • Press ENTER.

Using Formula Bar to Title a Column

  • Add column titles to the rest of the columns. Here, Product in C4 and Sales in D4.

  • Format the dataset: follow the steps described in Method 1.

This is the output.

Using Formula Bar to Title a Column

Read More: Remove Column Headers in Excel


Method 3 – Title a Column using the Excel Name Box

  • Enter the following formula in C13.
=COUNTIF(D:D,D5)
  • Press ENTER.

Sales values are counted as $540 in C13.

Steps:

  • Select the Entire Column D. You will see D1 in the Name Box.

  • Enter Sales as the column name.

Title a Column via Name Box in Excel

  • Press ENTER.

This is the output.

Title a Column via Name Box in Excel


Method 4 – Using the Power Query Editor to Title a Column in Excel

Steps:

  • Go to the Data tab >> click From Table/Range.

Use of Power Query Editor to Title a Column

  • In Create Table, enter B4:D11.
  • Click OK.

  • In the Power Query Editor, click Use First Row as Headers to set the first row as the column title.

Use of Power Query Editor to Title a Column

  • The column titles are selected.

  • Click Close & Load >> select Close & Load.

Use of Power Query Editor to Title a Column

  • You will see the column titles.


Method 5 – Using a Table to Title a Column

Steps:

  • Select B4:D11.
  • Go to the Home tab >> click Format as Table >> select Light Blue, Table Style Light 2.

Using Table to Title a Column

  • In Create Table, enter B4:D11.
  • Check My table has headers.
  • Click OK.

This is the output.

Using Table to Title a Column

Read More: How to Create Excel Table with Row and Column Headers 


Showing Row Numbers and Column Headers

If the row and column headers are hidden:

Showing Row and Column Headers

Steps:

  • Go to the File tab.

  • Click Options.

Showing Row and Column Headers

  • In Excel Options, go to the Advanced tab.
  • Check Show row and column headers.
  • Click OK.

  • Row and column headers are displayed.

Showing Row and Column Headers


Download Practice Workbook


Related Articles


<< Go Back to Rows and Columns Headings | Rows and Columns in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Arin Islam
Arin Islam

Anowara Islam Arin, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Arin exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Besides, she is also interested in Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo