Excel Help

Discussion in 'Windows Desktop Systems' started by Sinster, Nov 19, 2003.

  1. Sinster

    Sinster Moderator

    Messages:
    520
    Location:
    M*ssholechusetts
    I have a several cells I need information in on the same sheet. I tried to do ='Page1'!A1

    A1 will be where I input the information. I want when I put the information in A1 to fill in the others cells. I can do this if the cells is on a different sheet. But for some reason if I try to do it on the same sheet it only put the formula in the cell I want the information in.
     
  2. the_tazinator

    the_tazinator Are we there yet?

    Messages:
    177
    Location:
    In a house
    If I am understanding this, you want something like cell D24 to be the same as A1 where both cells are on the same sheet.

    If that is the case in D24 you would just put in =A1.

    It may also be that you have format view enabled so that you always see the fomulas and not the result. In that case, hit Ctrl+`(thats the key to the left of the #1 key) and it will toggle the formula view.
     
  3. Sinster

    Sinster Moderator

    Messages:
    520
    Location:
    M*ssholechusetts
    I did that. But is still only shows =A1 in the D24 Cell. The Formula view didn't work well.