How to change the names of the column headers in Excel

I would like to say hi!

The column headings in Microsoft Excel have automatically given the names A, B, C, and so on.
Some users want to change the names of the column headings to something more relevant.
Unfortunately, Excel does not let you modify the header names.

The same is true for Excel row names.
You can enter your chosen row names in column A for the associated rows, but you cannot modify the row names or numbers.

Instead, you can follow these steps to create appropriate column header titles.

  1. Insert a new row above the worksheet’s initial row by clicking on the first row.
  2. Enter the names you want in the inserted row.
  3. You can increase the text size, make the text bold, or add a background to it, in case you want to make this text more noticeable.

Once you inserted a new row and added column header names, if you want to hide the default column header names, you can do so by following the steps below.

  1. Click the File tab or the Office button in Excel’s upper left corner.
  2. Click Options in the left navigation pane.
  3. Again, in the left navigation pane click on the Advanced option in the Options window.
  4. Scroll down until you see Display options for this worksheet.
    Uncheck the box next to Show row and column headers.

The column and row headers text are now hidden.
If you want to show them again, repeat the steps and re-check the box in step 4 of the instructions above.