Revi 08:27 17 Oct 04

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 04

^^ ^^

  GroupFC 15:10 17 Oct 04

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 04

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 04


  VoG II 15:58 17 Oct 04


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

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

iPhone 7 review: a range of small updates add up to an excellent phone

1995-2015: How technology has changed the world in 20 years

How New York’s Stylin’ Seniors became a golden social media campaign

23 Apple Watch tips & secret features: Master your Apple Watch, Apple Watch Series 1 or Apple…