+ Reply to Thread
Results 1 to 2 of 2

changing cell references

  1. #1
    Louise
    Guest

    changing cell references

    Hi all

    A colleague of mine has a large, complicated worksheet which contains
    several large formulas.

    Several of the formulas are referencing a particular cell, B4 for instance,
    and he wants to change all the formulas to look at C3 instead.

    I don't know if I can use a simple find/replace for this, as it's the
    formulas themselves i want to change.

    Is there a quicker way, rathr than changing them all manually???

    Any urgent help is appreciated.

    Thank you.

    Louise

  2. #2
    Mladen_Dj
    Guest

    Re: changing cell references

    Yes, you can use find & replace, just in find and replace dialog be sure
    that in "Look in:" field selection is "Formulas".


    "Louise" <Louise@discussions.microsoft.com> wrote in message
    news:0708977E-8504-48A6-BDBA-9F401075D8FB@microsoft.com...
    > Hi all
    >
    > A colleague of mine has a large, complicated worksheet which contains
    > several large formulas.
    >
    > Several of the formulas are referencing a particular cell, B4 for
    > instance,
    > and he wants to change all the formulas to look at C3 instead.
    >
    > I don't know if I can use a simple find/replace for this, as it's the
    > formulas themselves i want to change.
    >
    > Is there a quicker way, rathr than changing them all manually???
    >
    > Any urgent help is appreciated.
    >
    > Thank you.
    >
    > Louise




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1