+ Reply to Thread
Results 1 to 4 of 4

columns

  1. #1
    Casey
    Guest

    columns

    How can I add columns without moving formulas. I need to have formulas stay
    in column a,b,c, When I add column formula goes to b,c,d, it needs to stay
    where is is.
    Thanks for any help

    Casey


  2. #2
    Forum Contributor
    Join Date
    03-12-2004
    Posts
    329
    Add a column after c?

  3. #3
    Casey
    Guest

    Re: columns

    the vallues in the columns have to move but not the formula

    "Morrigan" wrote:

    >
    > Add a column after c?
    >
    >
    > --
    > Morrigan
    > ------------------------------------------------------------------------
    > Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
    > View this thread: http://www.excelforum.com/showthread...hreadid=466290
    >
    >


  4. #4
    Jim May
    Guest

    Re: columns

    use indirect() - see help.
    =INDIRECT("B1")/INDIRECT("A1")


    "Casey" wrote:

    > the vallues in the columns have to move but not the formula
    >
    > "Morrigan" wrote:
    >
    > >
    > > Add a column after c?
    > >
    > >
    > > --
    > > Morrigan
    > > ------------------------------------------------------------------------
    > > Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
    > > View this thread: http://www.excelforum.com/showthread...hreadid=466290
    > >
    > >


+ 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