Thanks Thanks:  0
Likes Likes:  0
Needs Pictures Needs Pictures:  0
Picture(s) thanks Picture(s) thanks:  0
Results 1 to 3 of 3
  1. 12th August 2010, 01:27 AM #1
    KevinB
    KevinB is offline Senior Member
    Join Date
    Jun 2008
    Location
    perth
    Age
    79
    Posts
    144

    Default Problem with Excel spreadsheet

    Good people, this isn't a woodwork question. No. But believing all woodworkers to be caring and sharing, I believe that they are all knowing as well.

    With that in mind, I have a problem with Excel insofar as the column headings on my computer are 1,2,3..... rather than the A,B,C.... as they were last night.

    Since then, I've touched something I shouldn't have. Clumsy.

    Yes, the row headings are 1,2,3.... just as you would expect. The column headings are the problem.

    Does anyone have a solution?

    I shall be grateful to the moderators for letting this question through to the batsmen and women.

    Regards,

    Kevin.
    Reply With Quote Reply With Quote
  2. 12th August 2010 01:27 AM # ADS
    Google Adsense Advertisement
    Join Date
    Always
    Location
    Advertising world
    Age
    2010
    Posts
    Many





     
  3. 12th August 2010, 01:59 AM #2
    Tankstand's Avatar
    Tankstand
    Tankstand is offline SENIOR MEMBER
    Join Date
    Aug 2003
    Location
    Christies Beach
    Age
    59
    Posts
    972

    Default

    In the Excel options, formulas, have you checked the R1C1 button?
    The secret to creativity is knowing how to hide your sources.
    Albert Einstein
    Reply With Quote Reply With Quote
  4. 12th August 2010, 12:05 PM #3
    KevinB
    KevinB is offline Senior Member
    Join Date
    Jun 2008
    Location
    perth
    Age
    79
    Posts
    144

    Default Excel problem

    Thanks for your good advice, Tankstand.
    I went Tools, Options - and clicked the General tag. I unchecked the 'R1C1 reference style' and my spreadsheets returned to normal.
    Thanks again,

    Regards,

    Kevin.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Coving spreadsheet
    By AlexS in forum WOODWORK - GENERAL
    Replies: 5
    Last Post: 18th February 2011, 08:07 PM
  2. Tankstand needs Excel help
    By Tankstand in forum COMPUTERS
    Replies: 5
    Last Post: 3rd October 2008, 12:21 PM
  3. MS excel
    By Harry72 in forum COMPUTERS
    Replies: 4
    Last Post: 30th July 2008, 12:36 AM
  4. An Excel problem please.
    By watson in forum COMPUTERS
    Replies: 3
    Last Post: 24th January 2008, 04:34 PM
  5. Using a spreadsheet to calculate the amount of timber required for a project
    By Rocker in forum WOODWORK - GENERAL
    Replies: 4
    Last Post: 31st December 2005, 10:08 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules