Renaming Comlumns in Excel

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

someone came to me with a few spreadsheets where the columns have been renamed, now i've been searching the tinkernet for a good 45 mins and getting mixed results(some say it can't be done and others say use fill and then press hold ctrl then press I & N then C which didn't work) I have tryed on office 2003 and 2007 none seem to be able to revert them back to A,B,C now i know i could just copy and paste into a new excel file but theres too many of them for that route

Thanks

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

sorry for wasting time but i managed to get it, it was something to do with the seeting R1C1 refrence style silly me