Renaming columns

  • Thread starter Thread starter Uberman
  • Start date Start date
U

Uberman

I'd like to rename the A B C D at the top to the name of my columns, o
at least leave the column headings at the top of my screen.

Does anyone know how
 
Tools>Options>View, uncheck "Row and column headers".
You can insert a row and a column with your own names, but they will not be
recognized in formulas the same way as "A1". But you can define row and
column names and use the intersection as an address in a formula. The
intersection operator is a space. So if you defined the name "Material" for
column A and "Coat" for row 4, you can use "Material Coat" (without the
quotes) as an address in a formula instead of "A4".
To make it look more like real row and column headers, select cell B2,
Windows>Freeze panes.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
You can create a name in the sense that Niek mentioned
by selecting a column and placing a name into the
name box at the left of the address bar.

You can delete names, or add them through the
Insert (menu), Name, Define, ...

I don't know if that is what you are actually looking for
as it just provides a means for you to address your
locations -- they do not show on the spreadsheet.
 
Back
Top