changing col/row names

[shaggi]

I don't know if this is even possible but there might be a work round. Does anyone know if it is possible to change the row and column headers in Excel, for instance col A would read "bookings" instead of 'A'......

cheers
Adrian

 

[TonyJollans]

Hi shaggi,

Someone may correct me but I don't think it's possible.

A possible work around might be to remove the headers from view (Under Tools > Options > View, uncheck "Row & column headers&quot, and to put your own values in the top row and left column and then select cell B2 and then select Freeze Panes from the Window menu. This does have some impact you may not want - it really depends what else you're doing.

Enjoy,
Tony

 

[shaggi]

thanks Tony,
thought it may be a big ask, if u guys can't do it, nobody can....thanks for taking the time on it though..
Adrian