Rename Columns

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hi All,
I was wondering how you rename the column headings from A,
B, C to my own choosing.

Thanks in advance
 
Hi,

You cannot I'm afraid. WHat you should do is type your
headings into the top row.

Regards,

Jan Karel Pieterse
Excel MVP
 
Hi

You can't - you only can switch to R1C1 style (column numbers are displayed)
and back to column labels.

When you want this for better lookout only (without any functionality), then
you always can set any number of top rows as header rows, and use Freeze
Panes feature to set them always visible on top.

When you want refer to them in formulas, then you can define them as Named
Ranges. An example:
Define named range TestNumber=Sheet1!$A:$A
Into any cell outside of column A enter the formula
=SUM(TestNumber)
All numeric data in column A are summarized.
 
Back
Top