Revi 08:27 17 Oct 2004

In MS Excel I want to replace the column headings A, B, C.......... with captions (names). Can it be done?

  Revi 10:48 17 Oct 2004

^^ ^^

  GroupFC 15:10 17 Oct 2004

I don't think so - but at least this will bump you up the list.

Why don't you just have the names in the first row of each column - it seems much less hard work!

  daba 15:46 17 Oct 2004

You can't....

My guess the best solution is to use the top row (row 1) for your column 'headings'.

Then you can go to 'Tools->Options->View' and de-select "Row and Column Headings". This will unfortunately turn off the row number labels as well.

If you want to reference your columns, then you can 'Insert->Name->Define'. Here you can attach a name to a cell range reference. You could reference the name "Fred" to the whole column (=Sheet1!$A:$A), or to (=Sheet1!$A$2:$A$50) so that your column heading IS NOT included in your named range.

Depends what you want to do with it really.

More info for more help if needed.

  stalion 15:54 17 Oct 2004


  VoG II 15:58 17 Oct 2004


They are right, I don't think it can be done either.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment utiliser Live Photos ?