Results 1 to 4 of 4

Thread: Specific cell locking question

  1. #1

    Specific cell locking question



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Guys

    I have a very specific question for all of you.
    I'm an economy student and are currently working with daily currency convertion rates.

    In my worksheet i reference to the worksheet, in which my daily rates, so that shows the overview of present financial activs are in current day curreny.


    Here is my question:
    How do I lock a specific cell(in this case B4), in reference worksheet, despite adding new rows?

    Any helps?

  2. #2
    You could use

    =INDIRECT("B4")

  3. #3
    Thx for the advice @Bob However INDIRECT gives reference error when referring to another worksheet

  4. #4
    Does it? I thought it referred to another sheet just as easily

    =INDIRECT("Sheet2!B4")

Posting Permissions

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