1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Renaming Comlumns in Excel

Discussion in 'Microsoft Office Specialist (MOS)' started by ThomasMc, Aug 14, 2007.

  1. ThomasMc

    ThomasMc Gigabyte Poster

    1,507
    49
    111
    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
     

    Attached Files:

    Certifications: MCDST|FtOCC
    WIP: MCSA(70-270|70-290|70-291)
  2. ThomasMc

    ThomasMc Gigabyte Poster

    1,507
    49
    111
    sorry for wasting time but i managed to get it, it was something to do with the seeting R1C1 refrence style silly me
     
    Certifications: MCDST|FtOCC
    WIP: MCSA(70-270|70-290|70-291)

Share This Page

Loading...