Results 1 to 3 of 3

Thread: Is it possible to modify Excel Column Names

  1. #1
    Join Date
    Jan 2006
    Posts
    22

    Is it possible to modify Excel Column Names

    I came across a spreadsheet where both the columns and rows were numbered 1-2-3. How do I change the columns back to letters.

  2. #2
    Join Date
    Jul 2010
    Posts
    24

    Re: Is it possible to modify Excel Column Names

    Click on Tools > Options > General and check R1C1 reference style to show numbers or un-check to show letters.

  3. #3
    Join Date
    Jul 2010
    Posts
    74

    Re: Is it possible to modify Excel Column Names

    In the "Tools" menu choose "Options", you will see the dialog "Options" which has several tabs, choose the one that says "General". Among the options on this tab, check if it is on the box indicating "R1C1 reference style", disable and click on "OK" and you should be back in the letters column labels .

Similar Threads

  1. Sort a row or column in MS Excel
    By Itronix in forum Tips & Tweaks
    Replies: 1
    Last Post: 15-06-2011, 09:52 AM
  2. How can i display Formulas in Excel column
    By Visala28 in forum Windows Software
    Replies: 3
    Last Post: 03-09-2009, 07:46 PM
  3. Export file names to excel
    By PRIYAPEARL in forum Windows Software
    Replies: 2
    Last Post: 12-06-2009, 08:07 AM
  4. How to reverse column in excel
    By Vishant in forum Windows Software
    Replies: 2
    Last Post: 09-06-2009, 01:53 PM
  5. Displaying the column names of a table on a page
    By ricardoramey in forum Software Development
    Replies: 4
    Last Post: 04-08-2008, 01:31 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,714,266,297.05111 seconds with 17 queries