Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Help with simple Excel 2007 problem

  • 03-04-2009 10:24am
    #1
    Malari
    Registered Users, Registered Users 2 Posts: 18,150 ✭✭✭✭


    If anyone can provide an answer to this I would soooo appreciate it.

    I have formulas summed across a worksheet. I did this in the usual way, eg =sum(A1:A10) but I have clearly done something to it because now the sum looks like:

    =SUM(R[-6]C:R[-1]C)

    How the hell do I get it back the the other view?


Comments

  • #2
    Malari
    Registered Users, Registered Users 2 Posts: 18,150 ✭✭✭✭Malari


    It's ok, I've figured it out. :p


  • #3
    Capt'n Midnight
    Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 94,288 Mod ✭✭✭✭Capt'n Midnight


    It's burried in tools ,options, general somewhere look for R1C1 and turn it off


  • #4
    Malari
    Registered Users, Registered Users 2 Posts: 18,150 ✭✭✭✭Malari


    Thanks, that's what I was getting from all the websites I checked, but with Excel 2007, they have buried it even deeper in the Office button :rolleyes: then Excel options at the bottom, then formulas.


  • #5
    gaz wac
    Registered Users, Registered Users 2 Posts: 1,333 ✭✭✭gaz wac


    Malari wrote: »
    It's ok, I've figured it out. :p

    Was your answere -26 ? thats what im getting !


  • #6
    Gadgetman496
    Registered Users, Registered Users 2 Posts: 8,444 ✭✭✭Gadgetman496


    gaz wac wrote: »
    Was your answere -26 ? thats what im getting !

    :D:D:D Yep, he was soo willing to share so that others wouldn't feel the pain.....

    -

    "Everybody is a genius. But if you judge a fish by its ability to climb a tree, it will live its whole life believing that it is stupid."



  • Advertisement
Advertisement