How to change the name of the column headers in Excel

Updated: 01/24/2018 by Computer Hope

In Microsoft Excel, the column headers are named A, B, C, and so on by default. Some users want to change the names of the column headers to something more meaningful. Unfortunately, Excel does not allow the header names to be changed.

Instead, if you want to have meaningful column header names, you can do the following.

  1. Click in the first row of the worksheet and insert a new row above that first row.
  2. In the inserted row, enter the preferred name for each column.
  3. To make the row of column names more noticeable, you could increase the text size, make the text bold, or add background color to the cells in that row.

Named column header row in Microsoft Excel

After inserting the new row and adding column header names, if you want to hide the default column header names, follow the steps below to hide column and row headers.

  1. In Microsoft Excel, click on the File tab or the Office button in the upper-left corner.
  2. In the left navigation pane, click on Options.
  3. In the Excel Options window, click the Advanced option in the left navigation pane.
  4. Scroll down to the Display options for this worksheet section. Uncheck the box for Show row and column headers.

Hide column and row headers in Microsoft Excel

The column and row headers will now be hidden. To display them again, re-check the box in step 4 above.

Additional information