Welcome Guest
Log In | Register )
You last visited January 17, 2017, 9:54 am
All times shown are
Eastern Time (GMT-5:00)

Excel Question

Topic closed. 3 replies. Last post 4 years ago by SergeM.

Page 1 of 1
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Saskatchewan
Canada
Member #19992
August 9, 2005
2867 Posts
Offline
Posted: October 13, 2012, 4:19 pm - IP Logged

On my spreadsheets it shows numbers across the top and down the sides... how do i change the top row to read letters not numbers?

 

So cell is A-1 not 1-1

We are all Lucky... just some of us don't realize it!

    Avatar
    Florida
    United States
    Member #66575
    October 30, 2008
    3549 Posts
    Offline
    Posted: October 13, 2012, 4:24 pm - IP Logged

    On my spreadsheets it shows numbers across the top and down the sides... how do i change the top row to read letters not numbers?

     

    So cell is A-1 not 1-1

    Try going to excel options / formula tab and changing to R1C1 reference style

    Oops think I read your question wrong. You may already have R1C1 check and you need to uncheck it.. Sorry

    Carlig

      Rakster's avatar - praying hands.jpg
      Saskatchewan
      Canada
      Member #19992
      August 9, 2005
      2867 Posts
      Offline
      Posted: October 13, 2012, 5:37 pm - IP Logged

      Try going to excel options / formula tab and changing to R1C1 reference style

      Oops think I read your question wrong. You may already have R1C1 check and you need to uncheck it.. Sorry

      Carlig

      Thanks Carlig...

      We are all Lucky... just some of us don't realize it!

        SergeM's avatar - slow icon.png
        Economy class
        Belgium
        Member #123700
        February 27, 2012
        4035 Posts
        Offline
        Posted: October 14, 2012, 12:04 pm - IP Logged

        Stay with standard, when you switch computers you will find the same.